SQL Server 2005 Diagnostic Information Queries (April 2010)
Since SQL Server 2008 R2 has gone RTM, and will soon be available for purchase, I am going to be...
2010-04-26
984 reads
Blog Posts
SQL Server 2008 R2 Books OnLine - available now...
SQL Server 2008 R2 is released on April 21st, 2010 and in parallel with this new release, now is available...
2010-04-26
2,929 reads
SQL University: Auditing SQL Server, Part I
Welcome to the Security and Auditing Week for SQL University. Last semester we looked at the basics of SQL Server...
2010-04-26
2,786 reads
SQLSaturday Sites Will be Offline For Part of April 27, 2010
We’re scheduled to begin moving web sites and data to PASS servers at 12:00 pm Eastern on April 27, 2010....
2010-04-26
488 reads
SQLSaturday Success! NYC #39, has left the building.....
Well, it’s Monday morning and back to the DBA salt mines!
Now that SQLSaturday #39 is all but a joyful...
2010-04-26
570 reads
SSIS : Conditional Split optimization
I have built an enormous number of packages for this project over the past few weeks (just over 60) and...
2010-04-26
551 reads
SSIS : Using the VariableDispenser object within Script Components
I have become accustom to modifying package variables within my Script Task using the VariablesDispenser object. It is convenient and powerful. I started working...
2010-04-26
3,085 reads
SSIS : Using the VariableDispenser object within Script Components
I have become accustom to modifying package variables within my Script Task using the VariablesDispenser object. It is convenient and powerful. I started working...
2010-04-26
1,548 reads
Upgrading your Beta/CTP Software
This is one of the reasons that I don’t like to put CTP software (or Beta software) onto machines that...
2010-04-26
1,158 reads
A DMV a Day – Day 25
The DMV for Day 25 is sys.dm_os_memory_cache_counters, which is described by BOL as:
Returns a snapshot of the health of a...
2010-04-25
1,698 reads
Blogs
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...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
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...
The String Distance I
Comments posted to this topic are about the item The String Distance I
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