April, 2008

At the SQL Connections conference in April of 2008 I gave a presentation on some of the new Manageability Improvements for SQL Server 2008. In this blog post I’ll talk about one of those new improvements – our new PowerShell provider for SQL Server. ...

At the SQL Connections conference in April of 2008 I gave a presentation on some of the new Manageability Improvements for SQL Server 2008. In this blog post I’ll talk about one of those new improvements – our new PowerShell provider for SQL Server. ...

At the SQL Connections conference in April of 2008 I gave a presentation on some of the new Manageability Improvements for SQL Server 2008. In this blog post I’ll talk about one of those new improvements – our new PowerShell provider for SQL Server. ...

http://edge.technet.com/Media/Real-World-DBA-Episode-9--SQL-Server-Features--SQL-Server-Replication/ This week: In the news, there’s a new way to read SQL Server Documentation. In this week’s feature, we’ll continue the introduction to SQL Server...

I’m here at the SQL Connections conference in April of 2008 and I’m giving a presentation on some of the new Manageability Improvements for SQL Server 2008. In this blog post I’ll talk about the Transact-SQL Debugger tool. Those of you who have...

I’m here at the SQL Connections conference in April of 2008 and I’m giving a presentation on some of the new Manageability Improvements for SQL Server 2008. In this blog post I’ll talk about a few of the enhancements we’ve made to SQL Server Management...

I’m here at the SQL Connections conference in April of 2008 and I’m giving a presentation on some of the new Manageability Improvements for SQL Server 2008. In this blog post I’ll talk about one three of the new performance troubleshooting features in...

I’m here at the SQL Connections conference in April of 2008 and I’m giving a presentation on some of the new Manageability Improvements for SQL Server 2008. In this blog post I’ll talk about one of the new features in SQL Server 2008, Policy Based Management...

Well, it’s the first day of the SQL Connections conference in April of 2008 (yes, on a Sunday, although this will post on Monday) and my booth duties are pretty light. There are some great presenters, among them Kimberly Tripp and Paul Randall, who I...

I usually type these blog entries on the bus ride to work in Redmond. I live pretty far south of the main Microsoft campus, since the housing prices in Redmond are, well, let’s just say they are “high”. Since my bank account doesn’t quite approximate...

http://edge.technet.com/Media/Episode-08-SQL-Server-Features-Mirroring/ This week: In the news, there’s a new Service Pack in the works for SQL Server 2005. In this week’s feature, we’ll continue the introduction to SQL Server Features...

In an article I read recently by Ian Bramley from Mainframe Executive Magazine, several advantages were put forth on why you should consider moving to or staying on mainframe applications. Many of these dealt with downtime and security, which I’ll capitulate...

I've completed documenting all of the Standard Reports in SQL Server Management Studio. You can get to them from the tags, but I thought I would post a list of them all here with the links. I hope that you've been able to put some of this information...

As you may know, we’ve created a SQL Server 2008 provider for PowerShell. With this very cool feature you’re able to navigate SQL Server and it’s objects as easily as you could the file system on your hard drive. You also have access to all of the properties...

The information for the Cumulative Update (CU) 7 is now available - make sure you check that out here: http://support.microsoft.com/kb/949095/en-us

I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the SQL Server Agent node. From the menu...

http://edge.technet.com/Media/Real-World-DBA-Episode-7--SQL-Server-Features-Clustering/ This week: In the news, SQL Server is now out of Mainstream Support – and I’ll show you where to find out what support options you have. In this week’s feature...

I was showing a visitor some of the new improvements we have in SQL Server 2008 and when I started SQL Server Management Studio (SSMS), he said "oh, I thought you had something new." He expected to see a new user interface for SQL Server 2008. I...

One of the biggest new features in SQL server 2008 is Policy Based Management (PBM), which used to be called Declarative Management Framework (DMF). This feature can be compared to a “state machine” – that means it can set a state for you and either...

We're at the end of "Mainstream" support for SQL Server 2000, which is April 8th, 2008. If you're still using this version in your enterprise, you need to plan to move off of that version platform starting now. Many folks are planning to "jump" from SQL...

http://edge.technet.com/Media/Real-World-DBA-Episode-6--Upgrading-SQL-Server/ This week: In the news, Microsoft updates SQL Server Webcasts, in this week’s feature, we’ll cover the processes and procedures you need to follow for an upgrade. The...

One of our Principal Architects, Eddy Bell, shared a great writeup with me that I think is a great way to leverage Windows 2008 and SQL Server 2008. It answers a need that I've seen over and over again - the ability to connect to SQL Server Management...

I wanted to show you some of the things the group has been working on. You might not see all these features in your latest CTP, but they are scheduled for the Final Release. I hope you like the list! Title Component Advantage What's the big deal? Connection...

One of the main tasks I have is thinking about how we should design tools to help visualize a system. There are plenty of challenges, as I've alluded to before. Do youshow an object-based paradigm or a task-based one, or some of both? How do you manage...

In most checklists for SQL Server, including the one I explained on my last Podcast , you're told to "check your system". In fact, most instructors and DBA Experts will not look kindly on you if you don’t. But what does that mean? Well, I’ll probably...