Combating the CXPacket Wait Type
Often, when DBAs are looking at total wait statistics on the servers they manage, CXPacket is at or near the top of...
2015-03-24 (first published: 2015-03-17)
7,452 reads
Adam Kreul | Blog
Making Sense of PCIe SSD Use with SQL Server
When Fusion IO burst onto the scene in 2007, offering a PCIe card that was said to be able to...
2015-03-16 (first published: 2015-03-10)
6,037 reads
Configuring a Complete Memory Dump
Imagine this scenario: One of your servers just crashed, and you open a ticket with Microsoft for them to perform...
2014-11-06
1,935 reads
Database Maintenance Plans: A Primer
Databases and newborns have a lot in common. They both require constant care. They both require constant monitoring. They also...
2014-10-20 (first published: 2014-10-14)
7,034 reads
Why I’m Not Excited About Hekaton (In-Memory OLTP)
A while back I had written a post about why I’m excited about Hekaton (now called ‘In-Memory OLTP’ – not sure...
2014-09-22 (first published: 2014-09-17)
8,448 reads
A CLR Application: Deleting Three Billion Rows
In one of SQL Server Central’s recent daily newsletters, Steve Jones’s editorial was inquiring whether or not anyone has been...
2014-03-06
1,170 reads
Fight Career Frustration With Learning
If you work in IT, the office becomes your second home. It’s where we make a living, and most of...
2014-03-11 (first published: 2014-02-28)
2,959 reads
I’m on Twitter! @AdamKreul
I’m just a little late to the party, but no time like the present, right? I plan to be very...
2014-02-15
638 reads
Make Your Storage Administrator Your Best Friend
That guy or gal over there going on and on about spindles and IOPS – that’s your SAN admin. For the...
2014-02-17 (first published: 2014-02-12)
1,630 reads
Configuring the RecycleTime SSRS Setting
If you administer a SQL Server Reporting Services server, chances are you’ve had users complain the report manager is loading...
2013-11-07
4,464 reads
Blogs
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
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...
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