Back To Basics: The SELECT Statement
There are four basic commands in databases. They are SELECT, INSERT, UPDATE and DELETE. Probably the most important of these is the SELECT command. The SELECT command is how the data in the database is retrieved and displayed. (All these code samples can be run on all versions of Microsoft SQL Server from 7.0 up.) […]
I’ll be speaking at the San Diego SQL Server Users Group
The good folks of the San Diego SQL Server User Group has invited me to come speak to them on March 20, 2008. The meeting starts at 6PM. If you are in the area I urge you to come and check it out. The topic of my talk will be Query Tuning as well as […]
New Paper Published: Bullet-proof Change Management – Don’t just Cross your Fingers and Hope
I’ve written a technical brief on how my company, Awareness Technologies, uses the Quest Software Change Director for SQL Server product to monitor for and track unauthorised changes to our environments.
T/SQL Back To Basics
I’ve seen a lot of posts online over the last few weeks with people asking about basic query syntax. So over the next few posts I’m going to show some basic T/SQL queries as well as some more “advanced” features and syntaxes.