RunAs Radio

Richard and Greg talk to Itzik Ben-Gan about all things T-SQL in SQL Server 2008. Itzik doesn't just talk about what's new, he talks about what's missing (in his opinion). This is a must-listen for serious SQL geeks! Check out Itzik's web site at http://www.sql.co.il/

Michael Anderburg returns to talk to Richard and Greg about code security. Focused around the book The Security Development Lifecycle (http://www.microsoft.com/mspress/books/8753.aspx), Michael describes the role of IT in making code security work. While it sounds like a topic for developers, the book is equally applicable to IT Pros and what they can do to help development and even third-party applications be more secure.

Richard and Greg bring back Wes Miller to talk about Windows Rights Management Services (RMS). RMS secures email and other Office documents to have precise security options, limiting the ability to view, print, copy and so on.

Richard and Greg talk to Stephen Choy about measuring and managing server performance. Stephen digs into the intricacies of performance monitor and other tools for measuring server performance. One of the tools mentioned is Performance Analysis of Logs (PAL) Tool at http://www.codeplex.com/PAL.

Richard and Greg 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. Check out Kim's blog at http://www.sqlskills.com/blogs/kimberly.

Richard and Greg talk to Michiel Wories about Powershell for SQL Server 2008. The latest version of SQL Server implements several object models through Powershell to let folks manage SQL Server without using the management tools. Michiel's blog is at http://blogs.msdn.com/mwories/

Richard and Greg talk to Paul Randal about the new file stream technology in SQL Server 2008. File streams provide a solution to very large files being connected with SQL Server transactionally while still storing the files themselves in the file system, rather than the database. Check out Paul's blog at http://www.sqlskills.com/blogs/paul

Richard and Greg talk to Jeff Goodwin about Microsoft Unified Communications. Jeff lays out the relationship between Exchange, Office Communicator and Unified Messaging Server to combine email, telephone and instant messaging. Check out Jeff's TechNet articles at http://www.shrinkster.com/11mj and http://www.shrinkster.com/11mk.

Richard and Greg 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 at http://www.sqlskills.com/blogs/paul/

Richard and Greg talk to Laura Hunter about all things Active Directory. Laura digs into the key aspects of Active Directory, breaking down the differences between simple single domain installations and complex environments. Laura also shares her favorite resources, including the Ask the Directory Services Team (blogs.technet.com/askds).