How to Use SQL Backup Inside a Maintenance Plan
When you create a SQL Server Maintenance Plan using the Maintenance Plan Wizard or the Maintenance Plan Designer, the SQL...
2010-01-13
1,592 reads
Blog Posts
LEFT(), or Left Out?
So the question came up earlier today about the RIGHT() and LEFT() functions in the SSIS expression language. Like the...
2010-01-13
665 reads
New Article on Clustering Myths in the PASS SQL Server Standard
The PASS SQL Server Standard has published a new article called “Busting 6 SQL Server Failover Clustering Myths”, by Kathi...
2010-01-13
378 reads
PASS 2009 Evaluation Results
The results are in, and I'm pleased, but not satisfied. I delivered a brand new session called Gather SQL Server...
2010-01-13
410 reads
PASS DBA Virtual Chapter Presentation
I got the opportunity to present to the PASS DBA Virtual Chapter today, discussing the properties and practical uses of...
2010-01-13
918 reads
Primary Key Discovery II
In Part I, I discussed a couple of scripts that could be used to help discover some vital information about...
2010-01-13
639 reads
SQL Pass session evaluations
I finally got the last of my PASS Summit session evals and so, like someotherpeople, I thought I’d make them...
2010-01-13
570 reads
SQL Server Standard Volume 7 Issue 1
Kathi Kellenberger’s fantastic new article is available in the latest issue of SQL Server Standard. There are a lot more...
2010-01-13
836 reads
Tally Table - String Cleaning
Overview
This is something that most people eventually need for reporting purposes. This function uses a Tally table to 'clean' a...
2010-01-13
4,200 reads
The Advantage of GUIDs
I never liked GUIDs, not really using them in most of my development until I had a conversation many years...
2010-01-13
686 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