(Ken Henderson) I will start this chapter on blocking by talking about waiting. Why would I start a chapter on blocking with waiting? Well, the two are very much related, and they are often treated as synonyms. Because they are so related, the SQL Server concepts and tools related to each are interm
Author: SSWUG Research
Journey to the Center of Fusion
(David A. Kelly) Making the pieces of your enterprise infrastructure work together wasn’t always easy. Proprietary and best-of-breed systems were cobbled together with proprietary, best-of-breed, and custom in-house middleware solutions. The result of this assembly was often a messy patchwork of app
SQL Server Interview Questions and Answers – Part 2
(Pinalkumar Dave) What is the difference between clustered and a non-clustered index?
Alert-based Transaction Log Backups – Automate your database Maintenance Part 2
(Allen White) Having a well thought-out, and tested, backup strategy is important to your disaster recovery plan. Your regular database backups and transaction log backups will allow you to recover from system failure or user error. However, one thing that even the best strategy cannot anticipate is
Passing an array of values to SQL Server (Stored Procedure) without parsing/string manipulation
(Tony Rogerson) If you are splitting a CSV that just contains numbers, for instance surrogate key id’s that you are passing in because of a multiple select checkbox or something and you know the values range then why split the string? It’s simpler than that – no splitting required, just use dynamic
Working with TreeView Controls
(Scott Lysle) This is a short article addressing some of the basics of working with a TreeView control; the article will address dynamically adding TreeNodes to a TreeView control, searching the nodes to find and highlight a single node or a collection of nodes matching a search term against the Tre
A Developer’s Guide to the MySQL User’s Conference
(Jay Pipes) Robin Schumacher recently gave us an excellent rundown on sessions at the upcoming MySQL Conference and Expo (April 23-26th in Santa Clara) for DBAs. As a proud developer I wanted to make sure that our enormous developer community had a similar guide. Now, developers will encounter the s
REXML: Proccessing XML in Ruby
(Dominic Da Silva) In this day and age of software development, it is inevitable that you will need to process XML or produce XML within your application. If your language of choice is Ruby, or Rails for that matter, there is a very simple and useful XML processing API for Ruby called REXML. REXML i
Why you should never ever copy code – An example of complete chaos
(Jeroen van Wilgenburg) It seems innocent, a few lines of code used twice in the same application. But before you know know it those lines appear 272 times in your application! You guessed it right and you’re probably wondering how could that happen. I’ll try to explain what happened and how to prev
Example corrupt database to play with and some backup/restore things to try
(Paul Randal) I’ve been asked several times over the last few weeks for an example corrupt database to play with, and for testing logic built around DBCC CHECKDB.