Know anything about bowling? Or writing hard core TSQL? Or test driven development? Even if you don't, this might be a good way to build those skills. Write a stored procedure that can score a bowling game and you might win one of our books and a shirt!
2004-07-22
9,329 reads
Andy discusses one of the questions he uses to screen senior developer candidates. While the question itself is interesting, we think it will be more interesting to see how many of you agree with one of his positions - that developers think of program code and sql code as different animals, especially when it comes to debugging.
2004-07-09
11,918 reads
In this follow up Andy looks into some of the options available when you're dealing with situations where you're joining a case sensitive column to a case insensitive column. We think after reading this you'll be ready to just say no!
2004-06-22
8,365 reads
See what a reader had to say about Part 1, make sure you've read Part 2, then feel the pain as the author describes a lookup table that should have had unique values and doesn't.
2004-06-15
7,394 reads
Are you prepared to handle a full or partial failure of your AC system? Ever thought about what would happen if it did happen. Once again Andy offers comments on a real world incident. While we'd all like to think it will never happen to us, we think sharing these incidents is a great way to prevent it from happening to others.
2004-06-07
6,158 reads
Your SQL Server has a case insensitive collation, but you need a case sensitive join? Do you know what happens? There are a couple options but do you know the performance implications of using each? Or a way to mitigate the performance degradation that can result?
2004-06-03
10,111 reads
Some days the simplest things go wrong. On this particular day Andy tried to remove a column that was part of an article in a transactional publication, wound up in an inconsistent state that required a snapshot to fix. Deeper investigation reveals the cause and a work around.
2004-05-25
7,549 reads
What happens when you have a day job, a web site, a new job at work, and a baby? Chaos! See what Andy's been up to the past few months. It's off topic from SQL of course, but it contains an interested bit or two.
2004-05-14
5,535 reads
The fourth and final installment in this series, this week Andy discusses how using XML can reduce the load you put on your network and on your server. This is a high level article that discusses concepts. We think you'll find a good idea or two in this one!
2004-04-23
8,991 reads
A very short article that discusses how nulls can ruin your day if you don't understand how they behave when you concatenate.
2004-03-15
6,087 reads
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Comments posted to this topic are about the item Restoring On Top II
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Comments posted to this topic are about the item Breaking Down Your Work
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers