Why We Follow Best Practices There are many reasons why we follow best practices. My own reasons have changed over the course of my career. Early in my career as a database developer and then later as a new DBA, I followed best practices because people who claimed to know more about SQL Server said…
| News From the Frontlines |  |
Tag Archive: Internals
The Barking Dog Analogy
The Barking Dog Analogy A discussion started today on Twitter about CXPacket waits. There had been a heated debate on the subject on Twitter the previous night (wow, does that sound geeky), so many of us got looped into today’s discussion. Someone had experienced a problem with a delete query on a large table causing…
(5 votes, average: 5.00 out of 5)
Loading ...Session Files for Replication Magic Presentation to WSSUG
Session Files for Replication Magic Presentation to WSSUG I presented my session on Replication Magic: Initializing from Backup to the Wichita SQL Server User Group last night. I took a little longer to post my session files so I could add comments to the SQL scripts. Session files are below. Powerpoint silde deck: ReplicationMagic.pptx (1.27…
(2 votes, average: 5.00 out of 5) Loading ...Counting Unreplicated Commands and Transactions
Counting Unreplicated Commands and Transactions Someone asked me a question via Twitter today that I couldn’t possible answer 40 characters at a time. The question was about how to get the count of unreplicated transactions and commands from teh distribution server without using system views. Well, I do use one system view, but only because…
(3 votes, average: 5.00 out of 5) Loading ...SQLU HA/DR Week – Database Mirroring Performance Counters
SQLU HA/DR Week – Database Mirroring Performance Counters Database mirroring debuted in SQL Server 2005 and had eleven performance counters for monitoring mirroring. There were ten new performance counters released with SQL Server 2008. We now have twenty-one performance counters to use for monitoring database mirroring. A list with a brief description of each can…
(2 votes, average: 5.00 out of 5) Loading ...SQLU VLDB Week – Archiving and Purging Data
SQLU VLDB Week – Archiving and Purging Data Welcome back for the final day of VLDB week at SQL University. Today, we will talk about one of the big challenges that all administrators must eventually tackle when working with a VLDB: archiving and purging data. This particular problem has a very simple solution; however, if…
(1 votes, average: 5.00 out of 5) Loading ...SQLU VLDB Week – Integrity Checks
SQLU VLDB Week – Integrity Checks Welcome back to day four of VLDB week at SQL University. Today, we will talk about running integrity checks – a.k.a. DBCC CHECKDB. In factuality, there are serveral DBCC CHECK commands for checking database integrity, not just CHECKDB. CHECKDB is the main function, the grandaddy of all DBCC CHECK…
(1 votes, average: 5.00 out of 5) Loading ...When Does Trustworthy Get Reset on a Mirror?
When Does Trustworthy Get Reset on a Mirror? When I’ve done sessions on automating database mirroring processes and in my book, I talk about incorporating steps to set properties that get reset during the restore process in the mirroring setup such as database owner and the Trustworthy property. When you perform the initial restores of…
(2 votes, average: 5.00 out of 5) Loading ...Does a Mirroring Failover Clear the Procedure Cache?
Does a Mirroring Failover Clear the Procedure Cache? I saw a question on the MSDN forums asking what happens to the procedure cache (also known as the plan cache) on the principal and mirror when a failover occurs. My reply was starting to get long, so I decided to move it out to a blog…
(2 votes, average: 5.00 out of 5) Loading ...Getting Fast Counts of Large Service Broker Queues
Getting Fast Counts of Large Service Broker Queues This question regarding getting a fast count from a service broker queue came in through a discussion group. Question: Fast way to get a count of records from an SSB queue Subject: Fast way to get a count of records from an SSB queue I’m looking for…
(No Ratings Yet) Loading ...-
My SQL Server Magazine Articles
- Database Mirroring for Disaster Recovery September 16, 2011
- Comparative Review: Database Schema Comparison Tools August 24, 2011
- 3 Log Shipping Techniques June 22, 2011
- Hardening SQL Server June 20, 2011
- Review: ScriptLogic Security Explorer for SQL Server February 8, 2011
-
Twitter
LinkedIn
TLF
RSS
WritersCafe
SQLPASS