Of course I had to read up on LEAD before answering this question. MSDN states: "Notice that because there is no lead value available for the last row of each...

I learned something new today. I've always used the "=" or "AS" when doing column aliases. So when I looked through the choices on this question, "select Id, name name...

The index fooled me too. I was not thinking about the PK.. At least I learned more about table variables today. I use them quite often, especially if I need...

Nice trick. I looked at the last number as 1000, but didn't take into account the first value was 0. At least I learned something new today, and while I've...

I was also stumped on the mirroring option. Did a quick lookup on msdn and found the alter database mirroring options are not available for contained databases. I guess I...

I was wondering why the answers were checkboxes too and not just radio buttons. The answer is 10, I looked it up on msdn just to be sure. So where...

I went for answer #2 as well, but then realized after the fact that the create index is indeed a seperate statement. So I learned a couple new things already...

I created a few vb.Net apps to backup and restore databases, but I used SMO as well. This way it's also easy to add a progress bar and thread it...

Nice post, though I didn't want to loop to send multiple files. Instead I added a script task to create an FtpClientConnection and passed a string array to the FtpClientConnection.SendFiles()...