Browse by Tags

• ALTER TABLE
• Performance
• SET Options
• SQL Server 2008
• Tools
• training
• Troubleshooting
• Upgrade
• user groups

• Did You Know? Query Options Setting in SSMS

  Hi folks I’m back from an amazing week at PASS and an awesome reception for SQL Server MVP Deep Dives Volume 2. I’m starting to plan and write my next book on SQL Server 2012 Internals so blogging will kept to a minimum, not that I’ve had a lot of time Read More... Posted Wednesday, October 19, 2011 6:09 PM by Kalen Delaney | 21 Comments Filed under: Management Tools

• Did You Know? Management Studio Got Smarter!

  Hopefully you're aware that there is no way using the ALTER TABLE statement to add a new column in a particular ordinal position within a table. I see people in the forums asking for this capability, and they may point out that it is possible to do this Read More... Posted Friday, January 23, 2009 3:32 PM by Kalen Delaney | 17 Comments Filed under: Management Tools, ALTER TABLE

• Did You Know? Free SQL Server Troubleshooting Tools

  I'm very excited about the new Management Data Warehouse coming in SQL Server 2008 (which was called Performance Studio at one point), but keep in mind there are lots of available tools in the current versions. One of the students in my class last week Read More... Posted Saturday, May 17, 2008 9:47 PM by Kalen Delaney | 141 Comments Filed under: Tools, Management Tools, Performance, Troubleshooting

• Did You Know? My First Talk on SQL 2008

  I gave my first SQL Server 2008 presentation yesterday, and also spoke at a Launch Event for the first time. It was a terrific experience, primarily because it forced me to really start digging into SQL Server 2008. I had been doing so much 2005 training Read More... Posted Wednesday, April 2, 2008 6:13 PM by Kalen Delaney | 11 Comments Filed under: training, Management Tools, user groups, SQL Server 2008

• Did You Know? Nobody upgraded the SET OPTIONS screen in SQL Server Management Studio

  In SQL Server Management Studio, the screen where you choose which SET options to enable for all connections appears to be left over from SQL Server 2000. I know there are a lot of different dialog boxes available through the Tools | Options menu, but Read More... Posted Tuesday, July 17, 2007 4:16 PM by Kalen Delaney | 12 Comments Filed under: Upgrade, SET Options, Management Tools