The Politics of SQL Server Performance
Like most DBA’s I’m sure you often find yourself delivering information to the business concerning the performance of your SQL...
2010-06-30
1,517 reads
Blog Posts
Truncating the Log and Database Mirroring
I saw someone post recently that they wanted to run this code on their principal server in database mirroring to...
2010-06-30
2,126 reads
‘Tis the Season for SQL Leaving
With the announcement of Brent Ozar (Blog | Twitter ) leaving Quest for SQL Skills, Exceptional DBA finalist Jorge Segarra (blog | twitter)...
2010-06-29
1,608 reads
ASK SQLServerCentral - The New Community Model
We had an unexpected switch last weekend. My boss decided that we were ready to move from the Stack Exchange...
2010-06-29
1,740 reads
Conference Calls Are Hard
Conference calls are a fact of life for most of us. Remote offices, remote workers, clients – lots of reasons to...
2010-06-29
1,426 reads
Does a missing data file send a database suspect?
Short answer: No
I keep seeing this come up on various forums when people ask what makes a database go suspect...
2010-06-29
2,035 reads
Getting Drive Info Part 1, sp_OA
This blog series will cover several different methods to collect drive information from a Windows server that is running SQL...
2010-06-29
2,642 reads
Manage Reporting Services using SSMS
Sometimes you’ll want to manage reporting services functionality through SQL Server Management Studio (SSMS). This would be the case if...
2010-06-29
2,330 reads
Partition Alignment and Late Night Infomericals
Late night infomercials make some amazing claims. “If you order now you too can cut through a cinderblock wall and...
2010-06-29
1,507 reads
SQL Saturday #28 (Baton Rouge) – All about User Groups
This year at SQL Saturday #28 we will be featuring a User Group Booth alongside the Sponsor booths. The User Group...
2010-06-29
1,566 reads
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