Welcome to my box of tricks (SQL scripts) for Microsoft SQL Server instance and database administration! I've put considerable effort, over many years, into creating my own scripts, as well as ...

I have worked with SQL Server for many years now, back to Sybase SQL Server days and there has always been confusion over Logins and Users. Even though they typically use the same name they are ...

In this issue's column I'll be providing a fundamental introduction to database and database management concepts. Many of you may think that they understand the basic concepts and fundamentals of ...

I am getting a lot more unsolicited questions these days such as this one: “My co-workers tell me there is no future for SQL Server DBAs. Will I have a job in the long-term? I’m confused and ...