Aliases! They can be quite helpful, but they can also be a major pain when setting up new servers or migrating to a new server. Trust me, we just got burned by this recently. A missed alias resulted in a critical app being down for a while until we figured it out. If you use aliases and don’t have them …
When is the last time you audited who has SQL Server access? No really? When did you last do this? Have you ever done it? If you have, great! If not, well, let’s fix that. Below I have a PowerShell script that can help enlighten you to your SQL Server security situation a little more. Before we get to that, …
It’s been quiet… Too quiet Yes, yes it has. Things have been quiet here as of late. Posts and podcasts both have been lacking. I felt it important to share will all of you what has been happening, and what is going to happen in the future with this site, my company WaterOx Consulting, and me. What Happened? 2015 …
The SQL Agent is our friend! Setting up SQL Server Agent to automate jobs and alerts is a great idea. It is always better to learn about a failing job or system prior to end users so we, as DBAs, can try to deal with it. But what happens when the SQL Agent stops and we can’t get those alerts? …
Trace flags can be good Are special codes we, the DBA, can use to change the way the SQL Server engine works. Some perform simple changes, like turning off excessive backup success notices in the logs. Other can completely cripple your SQL Server if you don’t know what you are doing; Trace flag T3609, is undocumented, but it tells SQL …
I am at the PASS Summit on day 2 heading to the regular sessions and the keynote. If you couldn’t make it, here are my notes streaming as things develop:
