Tempdb is used by the database engine and all user-created databases for a wide variety of tasks. The most visible task is the creation of temporary tables by user code, but that is often the least …
SQL Server Extended Events for Slackers, Part II
There are DBA's, SQL bloggers and writers who seem to know everything about almost every aspect of SQL Server. It is a mystery to me how they can keep up with all the new features Microsoft keeps …
Continue Reading about SQL Server Extended Events for Slackers, Part II →
SQL Server Deprecated Features
Each time Microsoft introduces a new version of SQL Server they publish a new list of deprecated features that will be removed from SQL Server in some future version. The list is divided into two …
Intelligent Reindexing
Achieving Near 24/7 Uptime Using SQL Server Standard Edition What obstacle stands between you and 24/7 uptime for your SQL Server? Many database administrators would say index maintenance, especially …
SQL Injection Damage Control
I have begun to get calls again about a SQL Injection attack that has compromised the caller's web site. A number of calls like this are often a warning that a new and successful attack is making the …
Extended Events for Slackers
For many SQL Server DBA's, mastering Extended Events (XE) involves a learning curve. First they must learn the syntax for creating XE sessions to gather system data. Then they will need to learn …