Browse by Tags

• denali
• LINQ
• Linqpad
• SQL S
• sql server
• SQL Server 2012
• sql server PDW
• ssms

• Linqpad – bring the power of LINQ to SQL Server development

  One of my biggest laments about being a SQL Server developer is that the tools provided by Microsoft to do our thang compare woefully to the feature rich, (largely) bug-free, “it-just-works” impression that one gets from seeing the tools available to Read More... Posted Wednesday, November 20, 2013 10:23 AM by jamiet | 5 Comments Filed under: LINQ, Linqpad, SQL S, sql server, sql server management studio

• Query window custom colouring now works properly [SSMS]

  SQL Server 2008 introduced a new feature that had the potential to be very useful, the ability to color colour-code a query window in SSMS to represent the server that was being connected to. This was configured using the properties of a server in the Read More... Posted Thursday, August 11, 2011 9:28 PM by jamiet | 5 Comments Filed under: sql server, sql server management studio, ssms

• Thoughts on Nexus in SQL Server PDW

  I have been on a SQL Server Parallel Data Warehouse (aka PDW) training course this week and was interested to learn that you can't (yet) use SQL Server Management Studio (SSMS) against PDW, instead they ship a 3rd party tool called Nexus Chameleon. This Read More... Posted Friday, June 17, 2011 12:49 PM by jamiet | 2 Comments Filed under: sql server, sql server management studio, sql server PDW, ssms

• SSMS in SQL Server Denali – “Insert snippet” and “Surround with”

  SQL Server Denali CTP1 has hit the streets! I’ve been lucky enough to have been playing with it for a couple of weeks (thank you to those responsible – you know who you are) and that means I can now start talking publicly about some of the cool stuff Read More... Posted Monday, November 08, 2010 11:40 PM by jamiet | 5 Comments Filed under: denali, sql server, SQL Server 2012, sql server management studio

• Recover Backed-up query files in SQL Server Management Studio

  This is a useful little tip that I discovered today. If SQL Server Management Studio (SSMS) ever crashes on you for whatever reason then there is a chance that you’ll lose whatever queries you had open at the time of the crash. Sometimes when you re-open Read More... Posted Monday, July 19, 2010 11:25 PM by jamiet | 31 Comments Filed under: sql server, sql server management studio