Sep 9, 2010 | SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server Internals |
This a short post looking at the Dedicated Administrator Connection or DAC for short. In extreme circumstances, when there is a complete lack of resources available, for example, it is possible for SQL Server to enter a state whereby no further connections can be made...
May 12, 2010 | DBCC CHECKDB, Integrity Checks, Snapshots, SQL Server 2005, SQL Server 2008, SQL Server Internals, SQLServerPedia Syndication |
Ever come across a scary error in the SQL Server log when running CHECKDB against your databases. The error looks something like this: 1 transactions rolled back in database ‘CHECKDB’ (32). This is an informational message only. No user action is...
May 5, 2010 | DBCC CHECKDB, Integrity Checks, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server Internals, SQLServerPedia Syndication |
I like to run integrity checks against my databases very regularly, sometimes daily if I can get away with it. For some of the larger databases that I manage I change how this is run but on my consolidated instances which can house several different smaller databases...
May 4, 2010 | Replication, SQL Server 2005, SQL Server 2008, SQL Server Internals, SQLServerPedia Syndication |
My first post in my replication series gave a brief overview of replication, before I dive into setting up and configuring the different types of replication I wanted to look a little more closely at the respective agents and the role they play in the different types...
Apr 29, 2010 | Scripts, SQL Server 2005, SQL Server 2008, SQL Server Internals, SQLServerPedia Syndication, System Databases |
How do you tell when your SQL instance was lasted restarted? I was reading a post by Joe Webb (Blog|Twitter) about a query he uses to to gather information about his clients SQL Server instance including how he find out when an instance of SQL Server was last...
Mar 11, 2010 | Database Mirroring, Performance, Snapshots, SQL Server 2008, SQL Server Internals, SQLServerPedia Syndication |
This post is the second post in my series about Database mirroring. For part one is titled Configuring Database Mirroring in SQL Server. I believe that high availability is the primary reason people mirror their important production databases. Depending on your...
