Connect Digest : 2011-12-20

Make SSMS start faster A couple of years ago, I blogged about some ways to make Management Studio start faster. With the latest builds of SQL Server 2012, it seems to be slower than ever, at least when starting SSMS for the first time after a reboot or install. So […]

New cumulative updates for SQL Server 2008 R2 are available!

Microsoft has just released cumulative updates for both SQL Server 2008 R2 branches – RTM and Service Pack 1. SQL Server 2008 R2 Service Pack 1 Cumulative Update #4 http://support.microsoft.com/kb/2633146/ Build number is 10.50.2796 Contains 53 fixes (as of February 6, 2012) SQL Server 2008 R2 RTM Cumulative Update #11 […]

T-SQL Tuesday #25 : T-SQL Tips 'n' Tricks

This month's T-SQL Tuesday is being hosted by Allen White (@SQLRunr) and is about sharing your T-SQL tips and tricks. Since I know many people will share their T-SQL magic and wizardry, I thought I would share a couple of productivity tips – so still T-SQL related, but more how […]

Connect Digest : 2011-12-01

Where is my graphical ShowPlan? Many of you on SQL Server 2008 R2 are experiencing a major annoyance with SSMS since installing service pack 1 – when clicking a plan from grid results, you get raw XML instead of the graphical plan. I wrote about this symptom and a workaround […]