You Can Say “No”
I heard about this new law that was passed to prevent employers from asking for your social media passwords. After...
2013-01-16
973 reads
Blog Posts
Day 13 of 31 Days of Disaster Recovery: Standard Backup Scripts
31 Days of Disaster Recovery
Today’s post took longer to prepare than I had anticipated which is why day 13...
2013-01-15
1,444 reads
Exam 70-432 - SQL Server 2008 Implementation and Maintenance
For years, actually more like a decade, I've been saying that I'm going to get certified in SQL Server. Well...
2013-01-15
895 reads
Join me at SQLBits for a day of SSIS
I’m happy to announce that I’ve been selected to deliver a full day of training at the upcoming SQLBits conference...
2013-01-15
742 reads
New Year Aspirations – Chris Webb – SQLBits
SQLBits holds a special place for me as it was the first technical conference that I had ever been to....
2013-01-15
937 reads
Pro SQL Server 2012 Practices
Hello Dear Reader. Every now and then professionally you get to be a part of something really cool. Back in...
2013-01-15
808 reads
Ragged Flat File Processing in SSIS
Frequently I am asked how to properly use SQL Server Integration Services to handle ragged flat files, an example of...
2013-01-15
2,171 reads
Regression Testing before CUs and Service Packs
Someone asked me on Twitter recently if I ran full regression tests before applying Cumulative Updates (CUs). I decided it...
2013-01-15
1,511 reads
Scripts to Detect Data Warehouse Issues
Standards and best practices are like flu shots you take before you’re infected; Database best practices protect your databases from...
2013-01-15
501 reads
Scripts to Detect Data Warehouse Issues
Standards and best practices are like flu shots you take before you're infected; Database best practices protect your databases from...
2013-01-15
560 reads
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers