Moving to MySQL
It’s time. After years of building this site to work with SQL Server, I sold it to Red Gate Software....
2009-04-01
488 reads
Blog Posts
Undocumented Trace Flag Improves Performance By Up To 25%
As a production DBA I love to tweak things to optimal perfection. After all, if I paid for the hardware...
2009-04-01
537 reads
Buying A Plane
There's been a lot of bad press about 'corporate jets' in the news over the past year. Not that planes...
2009-03-31
1,468 reads
Keeping Relevant in the Face of Changing Technologies
I was recently asked by a co-worker on my team at work what he should do to keep up with...
2009-03-31
1,885 reads
Lunch in Town
One of the guys I met at the Denver User Group pinged me last week for lunch, and I agreed....
2009-03-31
1,811 reads
Microsoft Project Migration Template for the move to SQL 2008
If you are planning a move to SQL Server 2008, although this process can apply for many Database Migrations, perhaps...
2009-03-31
4,821 reads
Orlando .NET Code Camp 2009 Recap
On Saturday, 3/28, I presented Useful T-SQL Statements You May Not Be Aware Of at the 2009 Orlando .NET Code...
2009-03-31
1,436 reads
SQLSaturday #15 in Jacksonville
The call for speakers is still open and will close April 6th, there's still from for a few more sessions....
2009-03-31
1,338 reads
The Prius Update
Our second major repair will take place on the Prius, and once again it’s a cosmetic item. In fact, we’ve...
2009-03-31
1,898 reads
Notes on the 2009 MVP Summit
Note: I was working on this at the Summit and then it got lost in the draft folder, so unfashionably...
2009-03-30
1,470 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
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