Uninstalling SSMS on Server Breaks SQL Powershell
I reviewed my daily report and saw that some jobs failed on six instances overnight, the common factor being that...
2014-01-30
2,304 reads
Blog Posts
Your own personal space
Somewhere to relax, get away from it all (by all I mean pesky Developers wanting code deployed on a bleeding...
2014-01-30
1,012 reads
[SQL Snacks Video] Importance of COPY_ONLY Backups
There are many features/options we sometimes overlook and then wonder later what went wrong. The COPY_ONLY option with backups is...
2014-01-29
686 reads
Forcing Results To Conform For Exports
This one is a bit off for me. I've had to make SSIS exports kick out in specific ways such...
2014-01-29 (first published: 2014-01-27)
1,524 reads
Have You Studied SQL Server Enough?
Photo Credit – yum9me
SQL Server is a fairly big and complicated product. There are quite a few areas that you can...
2014-01-29
1,493 reads
Master Data Services for the Beginner Part 02
Introduction
In the first part of this discussion, I discussed step by step instructions pertaining to getting up and running with...
2014-01-29 (first published: 2014-01-27)
5,221 reads
Master Data Services for the Beginner Part 04
Introduction
In yesterday’s discussion we looked at populating entities and their related attributes. In today’s discussion we shall be concentrating on...
2014-01-29
2,095 reads
New SSIS Training Class from Andy Leonard
Andy Leonard (b | t | l | f), a good friend of mine from Linchpin People, has announced a new training class...
2014-01-29
1,402 reads
Reminder: I’m Presenting Security, Compliance, and SQL Server Today at 3PM Eastern
I hope you can make time for a learning break at work today – register directly at https://www2.gotomeeting.com/register/279348610 to learn more...
2014-01-29
548 reads
SQL Server Data Compression
SQL Server Data Compression Overview
I have been reviewing the options for data compression in SQL Server and believe it can...
2014-01-29
1,288 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