SQL Q and A at SQLIntersection Spring 2016

About Show #474

Time for another SQL Q and A! Richard moderates an hour long discussion at SQLintersection in Orlando with panelists Paul Randal, Kim Tripp and Brent Ozar as they tackle the questions and concerns of the attendees. A number of other SQL luminaries (including Microsoft SQL team members) chime in about topics ranging from data types to data recovery, noSQL vs RDBMS, query performance strategies, and more! Why should you upgrade to SQL 2016? How long does CheckDB take to run on SQL 2005? What is the longest answer to a question that Kim Tripp can give? All this and more in this show full of great answers and debates!
 

Paul Randal is the CEO of SQLskills.com, which he runs with his wife Kimberly L. Tripp. Both Paul and Kimberly are very widely known and respected experts in the SQL Server world, with both being SQL Server MVPs, and Microsoft Regional Directors. Paul is a Contributing Editor for TechNet Magazine, where he writes the bi-monthly SQL Q&A column and feature articles.

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), then on a kernel mode file system for Windows NT.

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, and code in other parts of the Storage Engine.

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) so Paul has a very deep understanding of the Storage Engine. Paul also holds a patent on consistency-checking technologies from his work with Microsoft.

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 almost 9 years on the SQL Server team, Paul left Microsoft to join Kimberly running SQLskills.com and pursuing his new-found passion for writing, teaching, and consulting. Paul is a regular, top-rated presenter of workshops and sessions at conferences and user groups around the world on high-availability, disaster recovery, database maintenance, Storage Engine internals, and performance. Paul teaches all of Microsoft’s internal classes on Database Maintenance/Operations, Storage Internals, Disaster Recovery, High-Availability and on these same topics at public and private events around the world. Paul is also a course author/instructor for Microsoft’s most advanced Microsoft Certified Master – SQL Server qualification, teaching the deep internals in the first week. He’s been involved with this qualification since it’s inception as the Microsoft-internal ‘Ranger’ class, teaching every rotation except one.

Paul is one of the most active people in the SQL Server community, from user groups to online forums to helping out on Twitter (@PaulRandal - checkout the #sqlhelp tag). His very popular and widely-referenced blog is at http://www.sqlskills.com/blogs/paul/ and he can be reached at paul@SQLskills.com. Together with Kimberly, Paul Co-Chairs the bi-annual SQLintersection conference.


Kimberly Tripp is a SQL Server MVP and a Microsoft Regional Director, and has worked with SQL Server since 1990. Kimberly worked for Microsoft – on the SQL Server team – and left in 1995 to start SQLskills where she writes, consults, speaks, and teaches classes on SQL Server. Her primary focus is architecture, design, and performance tuning with her primary goal of helping customers design the RIGHT solutions to their problems.

Brent Ozar is a Microsoft Certified Master, and a Microsoft SQL Server MVP. He offers consulting and training through BrentOzar.com. Brent has a decade of broad IT experience, including management of multi-terabyte data warehouses, storage area networks and virtualization. He speaks at technology conferences around the world and co-authored the book, "Professional SQL Server 2008 Internals and Troubleshooting."
 

Show Links

SQLintersection 
 

Show Comments

blog comments powered by Disqus