In this RunAs Radio podcast, Richard talks to Adam Machanic about parallelism in SQL Server. Executing queries in parallel has been in SQL Server since version 7, but with the number of cores in servers rising dramatically, parallelism is more and more important. Adam digs into the details of how to make parallelism in SQL Server work effectively. Check out Adam’s blog here.
Adam Machanic is a Boston-based independent database consultant, writer, and speaker. He has been involved in dozens of SQL Server implementations for both high-availability OLTP and large-scale data warehouse applications, and has optimized data access layer performance for several data-intensive applications. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including SQL Server 2008 Internals (Microsoft Press, 2009) and Expert SQL Server 2005 Development (Apress, 2007). Adam regularly speaks at user groups, community events, and conferences on a variety of SQL Server and .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, Microsoft Certified IT Professional (MCITP), and a member of the INETA North American Speakers Bureau.
SQL Server Execution Plans shows you what’s going on behind the scenes in SQL Server. This book provides you with a wealth of information on how your queries are being executed by SQL Server, including:
- Which indexes are being used, and where no indexes are being used at all.
- How the data is being retrieved, and joined, from the tables defined in your query.
- How aggregations in GROUP BY queries are put together.
- The anticipated load and the estimated cost that all these operations place upon the system.
SQL Server Execution Plans is the only in-depth look at how to improve your SQL query performance through careful design of execution plans.
In this RunAs Radio podcast, Richard and I talk to Brent Ozar about his experiences doing the Certified Masters in SQL Server 2008 program at Microsoft — a three week intensive course that stretches your knowledge in every aspect of SQL Server. The conversation also ranges into SQL Server 2008 R2 and the latest features of SQL Azure. Check out Brent’s blog posts here.
Brent Ozar is a SQL Server Expert with Quest Software, and a Microsoft SQL Server MVP. Brent has a decade of broad IT experience, including management of multi-terabyte data warehouses, storage area networks and virtualization. In his current role, Brent specializes in performance tuning, disaster recovery and automating SQL Server management. Previously, Brent spent two years at Southern Wine & Spirits, a Miami-based wine and spirits distributor. He has experience conducting training sessions, has written several technical articles, and blogs prolifically at BrentOzar.com. He is a regular speaker at PASS events, editor-in-chief of SQLServerPedia.com, and co-author of the book Professional SQL Server 2008 Internals and Troubleshooting.
In this RunAs Radio podcast, Richard and I talk to Kevin Kline from Quest Software about SQL Server 2008 R2, the challenges of Business Intelligence, and even have a discussion around the No SQL Movement.
Kevin Kline is the Technical Strategy Manager for SQL Server Solutions at Quest Software, a leading provider of award winning tools for database management and application monitoring on the SQL Server platform. A Microsoft SQL Server MVP since 2004, Kevin is a founding board member of the international Professional Association for SQL Server (PASS) and served as president from 2002-2006. He is the lead author of SQL in a Nutshell, and SQL Server MVP Deep Dives (Manning), a co-author of Pro SQL Server 2008 Database Design and Optimization and Database Benchmarking: Practical Methods for Oracle & SQL Server. Kevin writes monthly columns for SQL Server Magazine and Database Trends & Applications and blogs at SQLBlog.com and SQLMag.com. Kevin is a top rated speaker, appearing at international conferences like Microsoft TechEd, the PASS Community Summit, Microsoft IT Forum, DevTeach,and SQL Connections. When he’s not pulling his hair out over work, he loves spending time with his four kids and in his garden.
In this RunAs Radio podcast, Richard and I talk to Lara Rubbelke about the Enterprise Policy Management Framework (EPM). EPM is a freely downloadable framework for managing detailed policies around SQL Server 2008, 2005 and 2000. You can get EPM here.
Lara Rubbelke brings her passion for architecting, implementing and improving SQL Server solutions to the community as a Data Platform Technology Specialist for Microsoft. This is a role that is a pre-sales role for SQL Server. Her expertise involves both OLTP and OLAP systems, data management, performance tuning, encryption, ETL, and the Business Intelligence lifecycle. Compliance and configuration management are near and dear to her heart. She is an active board member and advocate of the Minnesota chapter of PASS (Professional Association for SQL Server) and regularly delivers technical presentations at local, regional and national conferences, user groups and webcasts.
Notably, Lara has presented at Tech Ed, the PASS Summit, the Minneapolis SQL Server Launch, and delivered numerous webcasts on MSDN and TechNet. Lara authored a number of the Microsoft whitepapers and was a contributing author of “Expert SQL Server 2005 Development” (lead author Adam Machanic). Prior to joining Microsoft, Lara was a Microsoft Most Valuable Professional (MVP).
[awsbullet:Enterprise Policy Management Framework]
In this RunAs Radio podcast, Richard and I talk to Jessica Moss about SQL Server Reporting Services (SSRS). SSRS can replace typical reporting products like Crystal Reports, but also provides a tool for having users build their own reports. The conversation also moves into the Business Intelligence side of reporting, looking at how SSRS works with Analysis Services to provide a deeper level of reporting.
Jessica M. Moss, a Microsoft SQL Server MVP and business intelligence mentor with Solid Quality Mentors, is certified as an MCDBA, MCTS: SQL Server 2005 BI, and an MCITP: SQL Server 2005 BI. She has been working with SQL Server 2005 and SQL Server 2008 since their releases and has participated in many warehousing and reporting solutions. Jessica enjoys working with the local community and is a regular speaker at user groups, code camps, and conferences. You can read about her work on her blog.
Richard and I talk to Allan Hirt about failover clustering in SQL Server 2008. SQL Server got a major update in the clustering side of things for 2008, Allan talks about the changes, improvements and why you’d want to do this in the first place. Check out an alpha version of Allan’s book here.
Allan Hirt has been using SQL Server in various guises since 1992. For the past ten years, he has been consulting, training, developing content, speaking at events, and authoring books, whitepapers, and articles related to SQL Server architecture, high availability, administration, and more. His upcoming book Pro SQL Server 2008 Failover Clustering (Apress) is due to be published in the spring of 2009. He has also authored various articles for SQL Server Magazine. Before forming Megahirtz in 2007, he most recently worked for both Microsoft and Avanade, and still continues to work closely with Microsoft on various projects including contributing to the recently published SQL Server 2008 Upgrade Technical Reference Guide. He can be contacted through his Web site.
For anyone who follows the “I always wait for the first service pack” method of deploying products, your excuse for waiting on SQL Server 2008 disappeared this past week, because SP1 for Microsoft SQL Server 2008 is now available.
Among the features, I like the slipstream install capability (install SQL server and the service pack in the same installation process), and the ability to uninstall the service pack separately.
Service Pack 1 for SQL Server 2008 is now available to customers. The Service pack is available via download at Download Center and is primarily a roll-up of Cumulative Updates 1 to 3 and minor fixes made in response to requests reported through the SQL Server community. While there are no new features in this service pack, customers running SQL Server 2008 should download and install SP1 to take advantage of the fixes which increase supportability and stability of SQL Server 2008.
The complete announcement is here.
This entry was originally posted at greghughes.net on April 11th, 2009. Stop on by if you want to talk about video Easter eggs and development and network security.
Richard and I talk to Kim Tripp about how developers and DBAs inter-relate around SQL Server. Kim tells a story of how she encountered developers who saw SQL Server as a “set it and forget it” technology. What should the relationship between developers, DBAs, and database be? We tackle the topic!
Kimberly L. Tripp is an SQL Server MVP and a Microsoft Regional Director and has worked with computers since 1985. Her career with database technologies began with IBM in 1988 and with Microsoft SQL Server in 1990. Since 1995, Kimberly has worked as a Speaker, Writer, Trainer and Consultant for her own company SYSolutions, Inc. (aka SQLskills.com). Kimberly is a writer/editor for SQL Server Magazine; was a founding writer for T-SQL Solutions magazine; was a technical contributor for the SQL Server 2000 Resource Kit; and co-authored the MSPress title SQL Server 2000 High Availability.
Kimberly has presented lectures and seminars at Microsoft Tech*Ed and other SQL Server-related events since 1996 and is consistently top-rated both on quality of technical content and presentation style. Kimberly regularly consults with customers to help them tackle their availability and performance issues as well as works with Microsoft to provide new and interesting technical resources including the SQL Server 2000 High Availability DVD. The HA DVD was a great experience where Microsoft funded the recording, production and duplication for a DVD with roughly 9.5 hours of content covering SQL Server 2000 High Availability technology such as Log Shipping, Backup/Restore, Clustering and Administration. This DVD is available from your Microsoft contact; the part number is 098-96661.
Currently, Kimberly is working to help create SQL Server 2005 (code-named “Yukon”) content including whitepapers, course materials, and labs. Prior to starting SYSolutions, Inc. in 1995, Kimberly held positions at Microsoft including Subject Matter Expert/Trainer for Microsoft University and Technical Writer for the SQL Server Development Team.
Richard and I talk to Bill Graziano about performance tuning in SQL Server. Bill digs into using SQL Profiler to focus on where the problems lie. The discussion digs into the procedure cache and how you can optimize your queries for caching. He also talks about ClearTrace, a free tool he distributes to help understand trace data. Check it out here.
Bill Graziano specializes in SQL Server performance tuning and server management. Bill has nearly twenty years of database management experience. He started working with Sybase on a Unix platform back before it became Microsoft SQL Server. He’s worked with every version of SQL Server Microsoft has released. Bill has been a Microsoft MVP for SQL Server for four years. He is on the Board of Directors for PASS, the global user group for SQL Server professionals, where he is the Vice President of Marketing. Bill is a regular presenter at the PASS conference and various user groups. Bill formerly worked for accenture and Empower Trainers & Consultants.
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. Check out Kim’s blog here.
Kimberly L. Tripp is an SQL Server MVP and a Microsoft Regional Director and has worked with computers since 1985. Her career with database technologies began with IBM in 1988 and with Microsoft SQL Server in 1990. Since 1995, Kimberly has worked as a speaker, writer, trainer, and consultant for her own company SYSolutions, Inc. (aka SQLskills.com). Kimberly is a writer/editor for SQL Server Magazine; was a founding writer for T-SQL Solutions magazine; was a technical contributor for the SQL Server 2000 Resource Kit; and co-authored the MSPress title SQL Server 2000 High Availability.
Kimberly has presented lectures and seminars at Microsoft Tech*Ed and other SQL Server-related events since 1996 and is consistently top-rated both on quality of technical content and presentation style. Kimberly regularly consults with customers to help them tackle their availability and performance issues as well as works with Microsoft to provide new and interesting technical resources including the SQL Server 2000 High Availability DVD. The HA DVD was a great experience where Microsoft funded the recording, production and duplication for a DVD with roughly 9.5 hours of content covering SQL Server 2000 High Availability technology such as log shipping, backup/restore, clustering, and administration. This DVD is available from your Microsoft contact — the part number is 098-96661.
Currently, Kimberly is working to help create SQL Server 2005 (code-named “Yukon”) content including whitepapers, course materials, and labs. Prior to starting SYSolutions, Inc. in 1995, Kimberly held positions at Microsoft including subject matter expert/trainer for Microsoft University and technical writer for the SQL Server Development Team.
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 share about these features: He joined Microsoft 7 1/2 years ago in the role of Senior Program Manager for Microsoft SQL Server and is currently working as a Principal Architect on defining the next generation SQL Server management platform infrastructure. Michiel’s blog is here.
RunAs Radio is a weekly Internet-audio talk show for IT Professionals presented in a high-quality podcast format. Since April 2007 RunAs Radio has brought experts in the field of IT to its 10,000+ listeners, to inform and entertain. Professionally produced interviews are about 30 minutes in length and pack a substantial amount of information for maximum benefit. More information about RunAs Radio can be found here. RunAs Radio is available on iTunes and the Zune Marketplace, as well as directly from the RunAs Radio Web site.
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 wife Kimberly L. Tripp. Paul started in the industry in 1994 working for DEC on the VMS file system and its check/repair tools (the equivalent of chkdsk for NTFS. In 1999 he moved to Microsoft to work on SQL Server, specifically on DBCC. For SQL Server 2000, he concentrated on index fragmentation — well, removing it! — writing both DBCC INDEXDEFRAG and DBCC SHOWCONTIG, plus various algorithms in DBCC CHECKDB to support it being able to run online. Paul then spent the first 3 years of SQL Server 2005 development rewriting the DBCC CHECKDB and repair code-base, gaining extensive insight into disaster recovery scenarios and problems through close partnership with the SQL Server PSS (Product Support) group.
Paul spent the remaining two years of SQL Server 2005 development leading/managing a 9-person development team in the Core Storage Engine. His team was responsible for data access and storage (DBCC, space allocation, indexes & heaps, pages & records, text/LOB storage, snapshot isolation, bulk load etc). For SQL Server 2008, Paul decided to put his customer passion to better use and switch to a Program Management role within the Storage Engine team — first with responsibility for the entire Storage Engine for a year, and then with a narrower, more hands-on focus on the Core Storage Engine. This involved both feature set definition plus customer and partner engagements. It was during this phase of Paul’s career that he first started public speaking, with his first session being on DBCC Internals at TechEd US 2006. This was also where he met Kimberly, and they were subsequently married July 29th 2007.
In 2007, after 8.5 years on the SQL Server team, Paul left Microsoft to join Kimberly running SQLskills.com and pursuing his new-found passion for presenting and consulting. Paul regularly presents at conferences and user groups around the world on high-availability, disaster recovery, database maintenance, and Storage Engine internals.
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 of Dan Jones, Group Program Manager of the Managability Team, Sung Hsueh, a Tester for the SQL Server Security Test Team and Il-Sung Lee, the Program Manager for the SQL Server Security Team.
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, he has been consulting, training, developing content, speaking at events (including a recent series on both SQL Server high availability and consolidation for Microsoft), and authoring books, white papers, and articles. His most recent major publications include the book Pro SQL Server 2005 High Availability (Apress, 2007) and various articles for SQL Server Magazine. Before striking out on his own in 2007, he most recently worked for both Microsoft and Avanade, and still continues to work closely with Microsoft on various projects. He can be reached via his Web site.