Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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: 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: 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 Post: 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...
  • Blog Post: 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 Studio and in Visual Studio...
  • Blog Post: Navigation As You Type in Object Explorer Details Pane

    In my previous blog entry I talked about how Search works within the Object Explorer Details window in SQL Server 2008 Management Studio. What people often forget is that the Object Explorer Details window has a navigate as you type capability. Assuming that you have the Object Explorer Details window...
  • Blog Post: Search in Object Explorer Details Window

    There have been quite a few blog postings about the new Search feature in SQL Server 2008 Management Studio. Here are some examples of what you can find: MSDN - Using Object Explorer Details and SQL Server Object Search Buck Woody’s Carpe Datum - SQL Server 2008 Improvements Practical's - Object Explorer...
  • Blog Post: Find strings fast in SQL Server Management Studio

    This is the first of a series of video based blog entries where I will share tips and tricks within the SQL Server Management Studio (SSMS) shell. Many of these techniques are the result of using Visual Studio as the shell for SSMS. This video demonstrates how to use the “Go To Find Combo” command for...
  • Blog Post: Where is that darn Activity Monitor in SQL Server 2008?

    Technorati Tags: SQL Server 2008 , Activity Monitor , SSMS You may have heard – we rewrote the Activity Monitor from the ground up. However, I’ve seen feedback on the Connect site and from others looking at SQL Server 2008 who claim they can’t find the Activity Monitor. Well – I guess I learned a...
Page 1 of 1 (14 items)