SQL Azure Diagnostic Tool
One of the CSS Engineers from Microsoft has released a diagnostic tool for SQL Azure. It’s worth a look. It’s...
2011-04-26
1,014 reads
Blog Posts
SQL University: Who has access to my SQL Server?
Welcome to PowerShell Week #2 for SQL University! One of the frequent questions I hear is, "Who has access to...
2011-04-26
2,787 reads
Transforming SSIS' sysssislog Entries Into Something More Readable
The format of sysssislog in SSIS 2005 and 2008 isn't great for human consumption, so what follows is an attempt to reformat it for easier digestion. It isn't perfect...
2011-04-26
7 reads
Transforming SSIS' sysssislog Entries Into Something More Readable
The format of sysssislog in SSIS 2005 and 2008 isn't great for human consumption, so what follows is an attempt...
2011-04-26
1,946 reads
Transforming SSIS' sysssislog Entries Into Something More Readable
The format of sysssislog in SSIS 2005 and 2008 isn't great for human consumption, so what follows is an attempt to reformat it for easier digestion. It isn't perfect...
2011-04-26
4 reads
A Caution About Checkpoints
Checkpoints in SSIS are a great tool and they definitely have their place. The downside to them is that they...
2011-04-25
1,102 reads
A SQL Server Hardware Nugget A Day – Day 25
For Day 25 of this series, I want to talk about how you go about picking a CPU for your...
2011-04-25
538 reads
Disable SQL Agent Jobs with PowerShell
I had a need today to disable all of our admin jobs while I moved our admin database to another...
2011-04-25
2,833 reads
Do You Enable “Optimize for Ad Hoc Workloads”?
Most of the time when I run a poll on my blog, I run it for at least a month...
2011-04-25
2,488 reads
Enjoy Your Life
A sad weekend, and shocking news Sunday morning. I was out running errands when I checked email and found out...
2011-04-25
1,588 reads
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers