Posted in: Microsoft SQL
I’m putting together a new series to cover the materials you’ll need to know in order to pass the 70-433. Microsoft’s exam that covers Database Development using Microsoft SQL Server 2008. I’m going to list the topics covered in several posts, each one will include links to details to those...
Posted in: Microsoft SQL
How many of you have heard me rant against using "SELECT * FROM tableName"? If you have I'm sure you've heard me mention the following reasons why SELECT * is
Posted in: Microsoft SQL
One of the more frequent questions I get for SQL Server is how to format a DATETIME into a specific date format. Here’s a summary of the different date formats that come standard in SQL Server as part of the CONVERT function. Following the standard date formats are some extended...
Posted in: Microsoft SQL
OK, so we’re all familiar with triggers now, right? You have seen that using a trigger you can log a change to a table in a special log file, or we can create a related record in another table. But all of these events happen after the action that triggers...
Posted in: Microsoft SQL
I’ve contributed another story to ficlets. This time I added a sequel to another author’s work. Russell Ruffino created an interesting start with “Day 44″. I followed up with “Another Cover Story“. I’ve included it here —– “We rounded up another 34 today sir…” The young lieutenant reported matter of
Posted in: Microsoft SQL
In previous versions of SQL Server we had what we called "owners" of objects. Nearly every time you talked about an object "owner" you were talking about dbo.
Posted in: Microsoft SQL
My personal goal is to post an article every Monday, Wednesday and Friday. What I’d like to do is create stubs in my content database with each of those days already set aside. That way, I can look at the next stub available and simply start writing. The challenge for...
Posted in: Microsoft SQL
I’d like to introduce you to my new site. ToyboxCreations.net. I wanted .com, but it is currently being squatted on. But that’s besides the point. This site will be my virtual home base. I’ll keep track of all my projects, my SQL training, photography, etc. Hopefully this site will introduce...