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 ...

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 ...

I'm supposed to be a software developer/consultant. However, I'm also the guy people look at when the application isn't running "fast enough." With business applications, speeding up the application ...

There are plenty of ways to get the most out of SQL Server without just upgrading to the latest version. For database admins working with older (maybe much older) SQL Server systems, here are four ...

SQL Server Database Administrators are responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems. Their main goal is to ensure the ...

While I am a general Linux admin, I have never administered or used PostgreSQL, although I do admin a few MySQL instances. I have just been told that a system currently hosted on SQL Server 2008 R2 is ...

In SQL Server 2005, Microsoft introduced the Upgrade Advisor. This was a great idea to be able to analyze your current SQL Server in a safe environment and start the planning process of an important ...