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.
Hopefully you’ll find these syntaxes useful.
All the code syntaxes will cover SQL 2000 and SQL 2005. Where code only works in one version or another it will be noted.
I’ve recently published a new tip on SearchSQLServer.com called “Configuring SQL Server memory settings“.
I’ve published a new tip over on SearchSQLServer.com entitled “Create an upgrade plan for your move to SQL Server 2005“.
While it’s based on upgrading to SQL Server 2005 it can be used to upgrade to SQL Server 2008 as well.
Well the call for speakers for the PASS Summit 2008 should be coming up shortly, and I’m trying to decide what to submit to speak about. And I decided that I’d ask the community here; If you were going to go to the PASS Summit this year what sessions would you like to attend? Please post your ideas to the comments below. Nothing is to crazy (as long as it’s got something to do with Microsoft SQL Server).
I’ve got a few ideas which I plan on submitting already, but I want to make sure that what I submit is what people want to actually here.
For those who haven’t attended PASS in prior years it is a great place to network and learn a ton about Microsoft SQL Server. There isn’t a whole lot of info posted yet, but the dates and basic info is posted on the PASS web site.