SQL Server Code-Named “Denali”–Getting Started with Availability Groups and Keyboard Customization

Bill Ramos Principal Program Manager, SQL Server Manageability If you missed SQL PASS or you didn’t get your copy of SQL Server code named “Denali”, you’re in luck. You can now download it from: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9 For the full experience, you will want to run the 64 bit version on Windows Server 2008 R2. You can…

0

Enabling SQL Server Management Pack Alerts with System Center Operations Manager 2007 - Enabling the Blocking Sessions Rule

Bill Ramos, Principal Program Manager, SQL Manageability In my previous blog post Installing the SQL Server 2008 R2 Management Pack for System Center Operations Manager 2007 R2 I showed how you can install SCOM 2007 R2 on a “bare-metal” VM using  SQL Server 2008 R2 as the back end. One of the big features of…

2

Transact-SQL Debugger for SQL Server 2008 – Part 3

In part 3 of working with the debugger, I’ll talk about how to set breakpoints and the trick to setting them in stored procedures and triggers. This 3 part series covers: Basic debugging Configure remote debugging & best practices Debugging triggers and stored procedures with breakpoints The trick with setting breakpoints in called stored procedures…

5

Transact-SQL Debugger for SQL Server 2008 – Part 2

This blog will go over what you need to know for setting up your environment for remote debugging along with best practices and other things to consider when using the debugger in SSMS. This 3 part series covers: Basic debugging Configure remote debugging & best practices Debugging triggers and stored procedures with breakpoints The debugger…

4

Transact-SQL Debugger for SQL Server 2008 – Part 1

In my next series of blog posts, I’ll explore the Transact-SQL Debugger for SQL Server 2008. This feature only works against database instances of SQL Server 2008. If you need to use a debugger for SQL Server 2005, you’ll have to use the Visual Studio Professional SKU or better. Please refer to the MSDN topic…

9

SQL Server Management Studio Tips – Part 4

This is the fourth in a series of posts highlighting Scott Cate’s video series of Visual Studio tricks over the last few months from Sara Ford’s blog. As I mentioned in Part 1, many of the commands are documented in the  SQL Server 2008 help topic – SQL Server Management Studio Keyboard Shortcuts. Blog Post…

1

SQL Server Management Studio Tips – Part 3

This is the third in a series of posts highlighting Scott Cate’s video series of Visual Studio tricks over the last few months from Sara Ford’s blog. As I mentioned in Part 1, many of the commands are documented in the  SQL Server 2008 help topic – SQL Server Management Studio Keyboard Shortcuts. Blog Post…

1

SQL Server Management Studio Tips – Part 2

This is the second in a series of posts highlighting Scott Cate’s video series of Visual Studio tricks over the last few months from Sara Ford’s blog. As I mentioned in Part 1, many of the commands are documented in the  SQL Server 2008 help topic – SQL Server Management Studio Keyboard Shortcuts.   Blog…

2

SQL Server Management Studio Tips – Part 1

Scott Cate has been publishing a video series of Visual Studio tricks over the last few months from Sara Ford’s blog. It turns out when you use the Standard keyboard scheme in SSMS under Tools | Options Keyboard, many of them work because SSMS is built on top of Visual Studio’s code base. Just about…

6

Window – Window – Where art thou?

If you are a fan of using dual monitors like I am, you have – without a doubt – had a situation where you’ll issue a command and you’ll wait and wait and wait – only to figure out that the window appeared off the screen. This frequently happens to me in SQL Server Management…

1