sql server

Richard and I talk to the illustrious Kim Tripp in a rare interview without her husband Paul Randal. The conversation delves deep into the wonders of indexes in SQL Server, including the value of clustered indexes, their impact on non-clustered indexes and a huge number of details on why some indexes rock and other suck. [...]

The latest version of SQL Server implements several object models through PowerShell to let folks manage SQL Server without using the SQL management tools.
We’ve just published a new episode of the RunAs Radio podcast with Michiel Wories, in which we dive into SQL Server 2008’s PowerShell features. Michiel is certainly the one to know and [...]

Richard and I talk to Paul Randal about the involuntary DBA — those folks that end up being the DBA without previous training or expectations. Kim Tripp (Paul’s wife) pops in here and there to support her husband’s ideas. Check out Paul’s blog.
Paul S. Randal is the Managing Director of SQLskills.com, which he runs with his [...]

Richard and I run a panel discussion on the compliance features of SQL Server 2008 while at Tech Ed US IT Pro week in Orlando, Florida. The discussion focuses around the tools built into SQL Server to make it easier to support compliance requirements like SOX and PCI.
The SQL Server Compliance Panel is made up [...]

Richard and I talk to Allan Hirt about using virtualization with SQL Server. Allan digs into where virtualization makes sense for SQL Server and when it doesn’t. And yes, its true, sometimes virtualizing SQL Server really does make sense!
Allan Hirt has been using SQL Server in various guises since 1992. For the past ten years, [...]

Richard and I talk to Erin Welker about Data Partitioning in SQL Server 2005 and 2008. Erin digs into the advantages of partitioning for OLTP and OLAP, as well as the changes between 2005 and 2008. Check out Erin’s blog here.
Erin has spent 25 years in Information Technology development, management, database administration and business intelligence. [...]