PowerShell Script Examples from DAT314

I’d like to thank everyone who attended my TechEd session today titled “Manageability Series: Microsoft SQL Server Automation on Steroids, Including PowerShell Support”. Sean McCown – SQL MVP – and all around DBA – creator of the Midnight DBA videos available at: http://midnightdba.itbookworm.com/ – was kind enough to stop by after the session to point…

1

Welcome to TechEd 2009

This is my first TechEd in a long time. The last time I spoke at a TechEd was back in 1997 in Japan! I have three sessions this Tuesday, Wednesday, and Thursday that talk about how to get the most out of our manageability suite of tools in SSMS.  If you happen to be at…

1

SQLPSX from Chad Miller

I’ve been playing around Chad Miller’s SQL Server PowerShell Extensions – SQLPSX 1.5 on CodePlex getting ready for my TechEd session Manageability Series: Microsoft SQL Server Automation on Steroids, Including Powershell on Wed 5/13. Chad has developed huge library of Powershell cmdlets, functions, and scripts that hit the key scenarios for SQL Server DBAs. All…

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 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 Saturday 47 Phoenix February 2011

Today I presented data collection strategies for SQL Server 2008 at Phoenix SQL Saturday 47. I’ve attached my deck to this post so that you can get the links and references that I presented. To learn more about the Data Collector, check out these links. SQL Server 2008 Data Collector Proof of Concept – How…


Post Web Cast Questions – Answered

Over 900 attended my web cast on Monday. With the help of Bruce Prang and Michael Benkovich, they were able to keep up with most of the questions. This article lists the questions that were asked and their responses. There are still several handfulls of questions that I need to get through, and they will…


Finding Bill Ramos at SQL PASS 2010

With the SQL PASS conference beginning tomorrow and in the spirit of Jen & Sean of the MidnightDBA fame I thought I would give you a run down of what I’ll be up to and things you might consider attending – just because. Monday SQL PASS Welcome Reception 6-8pm This event is taking place at…


Viewing MDW Reports with a Low Privileged User Account

Just last week, one of our technical sales people asked me the question, when will we release the source RDL files for the Management Data Warehouse (MDW) feature that we shipped with SQL Server 2008. The reason that he asked was that his customer wanted to host the reports on a Reporting Services server so…


Server Activity History Report–MDW Report Series Part 3

By Bill Ramos, Program Manager, SQL Server Manageability Team In part 2, I added the hyperlink to the MDW Overview report to launch the Server Activity History report. In this post, I’ll show how to get the data and display the thumbnails in the report for %CPU. I’ll follow up post 4 to include Disk…