Quick Audits of Schema Changes
I saw someone post a question recently about tracking down who deleted a stored procedure. I suggested the default trace,...
2010-05-25
959 reads
Blog Posts
Space Used
At long last I am bringing the next installment in this mini-series. You can find the rest of the articles...
2010-05-25
1,430 reads
SQL Saturday #35 Notes and Observations
First of all, I want to congratulate all the volunteers that made this happen. It was a very well organized...
2010-05-25
1,172 reads
SQL Saturday Dallas Top Ten(ish)
So for those of you who attended SQL Saturday Dallas this past weekend, here’s my Top Ten(ish) list from the...
2010-05-25
615 reads
The Power of Regex in PowerShell
PowerShell is probably banned in MLB as a performance enhancing substance. You won’t find red-blooded American baseball player admitting to...
2010-05-25
718 reads
Time Off, Recharge, Rethink
Some of you may have noticed that I haven’t posted for a while. The 12th May was the date of...
2010-05-25
625 reads
Yesterday's Vermont SQL Server User Group Presentation on Database Mirroring (Official PASS Chapter for Vermont)
To celebrate the Victoria Day Holiday in Canada I drove down to the U.S.A. with 'ol Volvo Wagon (not Smart this time, since 3k of...
2010-05-25
1,393 reads
Content Copy Followup
Last week I posted an article about plagiarism. This is a follow-up to that. After posting that blog article, Steiner...
2010-05-24
940 reads
Create Indexes from the Missing Indexes DMV
Glenn Berry (Blog) writes a lot of queries to extract information from the system DMV’s. One of them in particular...
2010-05-24
2,413 reads
East Coast PASS Event Options
After asking members about where the PASS Summit should be located and then deciding to keep it in Seattle for...
2010-05-24
794 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