Handling Database Mirror Failover within an SSIS Package
Recently I was asked how to handle a Mirrored Database Failover within an SSIS package. For those of us that...
2010-01-07
2,580 reads
Blog Posts
How to Read the Results of SELECT @@VERSION in SQL Server
The simple query SELECT @@VERSION can quickly tell you quite a bit about a SQL Server installation (and the underlying...
2010-01-07
4,145 reads
Recharging
I was hoping that 4 days in the mountains would be a nice time to recharge. Unfortunately, with my wife...
2010-01-07
447 reads
Speaking at SQLSaturday #32 in Tampa on January 23, 1010
I’ll be heading to Tampa the afternoon of the 22nd for the speaker party, and then presenting Social and Not...
2010-01-07
326 reads
SSC Syndication
Steve Jones at SqlServerCentral.com has created a Blog for me over there at SqlServerCentral.com. I will be syndicated there and...
2010-01-07
614 reads
Too Much Data – Idiocracy or Star Trek?
I used to think that too much data was never a bad thing. That having more information out there is...
2010-01-07
372 reads
10 Goals For 2010
As is the traditional thing to do at the beginning of a new year I'm making goals for what I'd...
2010-01-06
723 reads
Goals for 2010
So I’d planned to already have this done and published before the new year rolled around, but life got in...
2010-01-06
1,184 reads
Identity Values – Two things to know
I saw someone post a question recently about running out of identity values in an INT column. It happens, it’s...
2010-01-06
3,521 reads
Identity Values – Two things to know
I saw someone post a question recently about running out of identity values in an INT column. It happens, it’s...
2010-01-06
534 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers