May the source be with you! MDW Report Series Part 6–The Final Edition

Bill Ramos, Principal Program Manager, SQL Server Manageability Up until this point, I’ve walked through step by step how the MDW reports could be recreated to use SQL Server Reporting Services 2008 R2 and edit them in Report Builder 3.0. At last week’s SQL PASS, I announced in my Wednesday session that I would release…

16

MDW Reports–New Source Code ZIP File Available

In my MDW Reports series, I attached V1 of the RDL files in my post – May the source be with you! MDW Report Series Part 6–The Final Edition. Since that post, Rachna Agarwal from MSIT in India updated the RDL files that are ready to go in a single ZIP. The reports assume that…

9

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 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

SQL Server 2008 Management Studio Express – Released to the Web

I just wanted to let the community know that we have just released a new Express edition called SQL Server 2008 Management Studio Express to the web today! We teased out the Tools portion of SQL Server 2008 Express with Tools into it’s own download. It’s free and has most of the tools you would…

6

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

Using Live/Hotmail/MSN for SQL Server 2008 Database Mail

Over the weekend, I was playing around with trying to use my hotmail email account for SQL Server 2008 Database Mail. After searching, I found a promising post on the MSDN Forum under SQL Tools. In the forum posted, it was suggested that you need to use a premium account – this is not true….

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

Server Activity History Report–MDW Report Series Part 4

By Bill Ramos, Program Manager, SQL Server Manageability Team In part 3 of the report series, I showed how to get CPU data from the MDW and display it as a thumbnail chart in the Server Activity History report. In part 4, I’ll show how to extract data from the MDW for the Disk I/O…

4

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 lesson – don’t willy-nilly…

3