It is all fine and good to be able to manipulate a database, but that will get you nowhere in the Real World unless you can also create a new database and add the information that you want in it. I am not all that unusual in that I have a lot of photographs...

I hear a lot about this file, as it is a very important part of SQL Server, but as you dive into it a bit more, you learn a few things about it. First, the log is not actually one file, but a series of files called Virtual Log Files. These VLFs act as...

I came across this topic when it was pointed out to me by Larry Franks, a colleague of mine from North Carolina. As I look for topics to write about, I go through a variety of sources to see what people are having trouble with, and installation is by...