Do you code or Don’tcha?

I’ve met a lot of DBA’s that don’t do a lot of coding. Sure, they know basic T-SQL, and are probably pretty handy with a scripting language, but they don’t write code for a living. In some shops where I’ve worked (usually larger ones) we had separate disciplines for DBA’s that write code (T-SQL or…

1

Go get me a switch!

You probably access SQL Server Management Studio (SSMS) using an icon somewhere in your Start menu or on your desktop. But did you know that there are several command-line switches that you can use to start SSMS and end up right where you want to go? Drop to a command-prompt and type this: Sqlwb /?…

2

Templates

I’ve run into quite a few DBA’s who aren’t using the Templates feature we provide with SQL Server Management Studio. If you spend a little time becoming familiar with them, I think you’ll find they are a powerful tool. Templates are really just a series of Transact-SQL statements that live on your hard drive –…

1

SQL Server Management Studio Standard Reports – Performance – Top Queries by *

I’m continuing my series on the Standard Reports in SQL Server Management Studio. Today I’m covering four reports at a time – the performance reports that are broken down by average and total times. The reason I’ll cover all four of them is that they have exactly the same information, just arranged in a different…

6

CTP5 is out! OK, so maybe you already know that…

I got back from vacation (more here if you want to read about where we go and what we do every other week) and we released SQL Server 2008 CTP5. If you have been waiting for a bit to install and learn more about it, this is a good release to try. Make sure you…

1

Happy Thanksgiving

I’ll be offline for about a week. For those of you reading this blog outside of the US, we have a holiday called “Thanksgiving” where we are all encouraged to be thankful for the things we have. I think this is a great tradition, and one of the things I’m thankful for is a great…

2

More info on those reports

I spoke with Andrew Fryer yesterday via e-mail when I noticed he was also covering some of the same information we’re looking at here on the Standard Reports in SQL Server. I think that’s great – I had been wondering if there were many people using these reports. From what I’ve been learning, more and…

1

SQL Server Management Studio Standard Reports – Performance – Object Execution Statistics

We’re in the performance section of the series of Standard Reports you get with SQL Server Management Studio. The report we’re covering today, located in the “Server” level of reports is another Performance Report, and it is interesting because it brings up something I’ve been asked about before. This report is almost identical to another…

0

It’s the little things that count

As I’ve mentioned, I’ve only been in my current role a few months. I’ve inherited a lot of things from the Program Managers who have gone before me, so I can’t take credit or blame for everything I’m now responsible for. But going forward, I want to do the best job I possibly can, from…

2

SQL Server Management Studio Standard Reports – Performance – Batch Execution Statistics

I’m working my way through the Standard Reports you get in SQL Server Management Studio. I’ve gone through several of them already, and today we finally move out of the locking and blocking reports. The next report in the list, and we’re still only on the server-level reports, is the start of the Performance reports….

3