Retrieving Deadlock Graphs with SQL Server 2008 Extended Events
Learn how to get deadlock graphs from the SQL Server 2008 default system_health session with Extended Events.
SQL Saturday Comes to Pensacola
SQL Saturday comes to Pensacola, June 6, 2009. Read on to get more information and sign up for a one day, free training event.
Why Are There So Many Editions?
SQL Server has grown from two editions in the v6.5 days to 7 with SQL Server 2008. Why are there so many editions? Steve Jones gives his thoughts.
Can you shrink your transaction log files to death?
can undermine server performance. An expert runs various tests to determine how transaction log file size responds to various T-SQL commands.
Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?
Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.
Do You Verify Your Database Backups?
Backup verification is a vital part of a well-designed database maintenance plan and yet some DBAs neglect to do it. Brad McGehee ownders why.
Do You Verify Your Database Backups?
Backup verification is a vital part of a well-designed database maintenance plan and yet some DBAs neglect to do it. Brad McGehee ownders why.
Why Are There So Many Editions?
SQL Server has grown from two editions in the v6.5 days to 7 with SQL Server 2008. Why are there so many editions? Steve Jones gives his thoughts.
Why Are There So Many Editions?
SQL Server has grown from two editions in the v6.5 days to 7 with SQL Server 2008. Why are there so many editions? Steve Jones gives his thoughts.
Why Are There So Many Editions?
SQL Server has grown from two editions in the v6.5 days to 7 with SQL Server 2008. Why are there so many editions? Steve Jones gives his thoughts.
Blogs
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers