T-SQL Enhancement: Sequence
Many applications need sequentially incremental number as unique/primary key for records. SQL Server 2008 supports identity columns as the primary...
2011-06-07
555 reads
On the exorcism of Ghost Records
There was a question earlier on one of the SQL forums as to whether or not Ghost Cleanup overwrote the...
2011-06-07
1,898 reads
Another Idea for SQLSaturday
I spend a lot of time just looking at events, watching for new ideas. At our recent SQLRally we had...
2011-06-07
647 reads
Pragmatic Tools: DTSxChange (Or DTS Must Die!)
Ah DTS packages…they suck. Seriously, it’s 2011. It’s been over a decade and we still have SQL 2000 and DTS...
2011-06-07
898 reads
Free Dynamic SSIS Webinar Today
If you were able to make it out to SQL Saturday in Pensacola this past weekend I want to say...
2011-06-07
647 reads
June 2011 – PASSMN Meeting Announcement
PASSMN has announced it’s June meeting. A little of the SQL and a little of the non-SQL. Get a brush...
2011-06-07
623 reads
Combinations and Permutations
I ran into an interesting question from someone asking for all combinations of numbers. The thread was here, and it...
2011-06-07
15,983 reads
T-SQL Enhancements in SQL Server Denali (2011)
In the next couple of weeks we’ll do a series of blog posts with some of the T-SQL enhancements that...
2011-06-07
470 reads
Planning Your Upgrade Well
Yesterday I talked about the importance of having a tested business recovery plan. If you didn't read yesterday's post, the...
2011-06-07
975 reads
Improved partition loading
We have a table that contains just over 1.7 billion records and requires a daily feeding of around 9 million. It is split into 10, roughly equal, partitions. I...
2011-06-06
23 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
My PASS Summit West 2026
Comments posted to this topic are about the item My PASS Summit West 2026
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers