Lost in Translation – Deprecated System Tables – sysfulltextcatalogs
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-10-17
627 reads
Blog Posts
PASS 2012 Countdown – 3 Weeks To Go
Another week down and there are now 3-weeks until this year’s PASS Summit. Take a moment and register now if...
2012-10-17
1,742 reads
PASS Election Results Posted
Congratulations to Wendy Pastrick, James Rowland-Jones, and Sri Sridharan on winning a two year term on the PASS Board of...
2012-10-17
804 reads
Querying database usage
A question that a DBA will often be asked is what databases are actively being used on my SQL Server?...
2012-10-17
3,378 reads
SQL In The City: Seattle
If you missed all the great speakers on the five city tour of SQL in the City, don’t despair. Many...
2012-10-17
1,144 reads
SQL Server Database Backup Report using T-SQL
Today, I am going to share few very useful scripts which will report us on Database Backup from different view...
2012-10-17
952 reads
Why Tune Queries?
It’s just a query against the database. If things are running slow, buy some more memory, a faster CPU or...
2012-10-17 (first published: 2012-10-15)
2,997 reads
Windows Server 2008 Cluster: Understanding the Cluster Log Behavior
In any system, logs are very important to troubleshoot the issue. In the case of windows cluster, cluster logs are...
2012-10-17
1,029 reads
Generate Uniqueidentifier with SSIS
If you are trying to generate Uniqueidentifier/Newid() in SSIS data flow, you will soon realize that there is no out-of-the-box...
2012-10-16 (first published: 2012-10-10)
11,473 reads
RML Utilities and SQL Server 2012
I’m working through some code that I haven’t touched recently and I’m running it for the first time on a...
2012-10-16
1,466 reads
Blogs
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,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
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