Extract Objects from SSRS Reports
A discrete list of database objects is extracted from SSRS using SQL, SSIS, and RegExtractor in order to identify reports that might break when a schema upgrade is performed.
The Impact of Outages
Steve Jones talks about the problems of outages, and why we ought to perhaps introduce failure into our systems to help us learn to cope with them.
CLR Performance Testing
Are Common Language Runtime routines in SQL Server faster or slower than the equivalent T-SQL code? How would you go about testing the relative performance objectively? Solomon Rutzky creates a test framework to try to answer the question and comes up with some surprising results that you can check for yourself.
SQL Saturday #64 - Baton Rouge, LA
Come join Steve Jones for a day of SQL Server training in Baton Rouge on Aug 6, 2011. Free training!
Geeky Distractions
This Friday Steve Jones has a non-work related, but fun poll. Let us know what your geeky media recommendations are this year.
SQL Overview V - Monitoring Long Running Jobs
Continuing with his series on monitoring your SQL Servers, David Bird now looks a a way to fin those long running, active jobs.
Backup to multiple files for faster and smaller SQL Server backup files
Write your database backup to multiple files. In addition to writing your database backup to one file you have the ability to write to multiple files at the same time and therefore split up the workload. The advantage to doing this is that the backup process can run using multiple threads and therefore finish faster as well as having much smaller files that can be moved across the network or copied to a CD or DVD.
Third Normal Form
The third article in our series on normalization from Tom Thomson continues with an explanation on what constitutes third normal form.
You Can Telecommute
Today Steve Jones tells you can implement telecommuting at your job and gives you a few ideas how to get it approved.
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
Jabatan Imigresen Certified Translators: Trusted Support for Official Documents
When preparing documents for immigration in Malaysia, accuracy and compliance are essential. Working with...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers