SQLintersection Spring 2020 coming up fast!

As we head towards our SQLintersection Spring 2020 in April (our 15th show!), I’m excited to say that it’s once again our most diverse, complete, and information-packed show yet!

One of the pieces of feedback we hear over and over is that attendees love SQLintersection because it’s a smaller, laid-back show, where you get to actually spend time talking with the presenters 1-1. I have to say that’s one of the reasons why we love the show so much; *we* get to spend time talking to attendees, rather than being mobbed by hundreds of people after a session ends. And we only pick presenters who we know personally, and who we know to be humble, approachable, and eager to help someone out.

We have 2 pre-con days at the show and with our post-con day, there are 9 full-day workshops from which to choose. We have 46 technology-focused (NOT marketing) sessions from which to choose, plus two SQL Server keynotes, multiple industry-wide keynotes by Microsoft executives, and the ever-lively closing Q&A that we record as a RunAs Radio podcast (you can listen to the recording from our Fall 2019 show here.)

You’ll learn proven problem-solving techniques and technologies you can implement immediately. Our focus is around performance monitoring, troubleshooting, designing for scale and performance, cloud, as well as new features in Azure and SQL Server 2016, 2017, and 2019. It’s time to determine your 2008 / 2008 R2 migration strategy – should you upgrade to 2016/2017/2019 directly? Should you move to Azure? This is the place to figure that out!

If you’re interested in how we got here – check out some of Kimberly’s past posts:

  1. SQLintersection: a new year, a new conference
  2. SQLintersection’s Fall Conference – It’s all about ROI!
  3. Fall SQLintersection is coming up soon and we can’t wait!
  4. SQLintersection Conference and SQLafterDark Evening Event – what a fantastic week in Vegas

SQLafterDark

With minimal to no marketing filler, we’ve largely kept our conference focus on ROI and technical content (performance / troubleshooting / tales-from-the-trenches with best practices on how to fix them ) but we’ve also added even more social events so that you really get time to intersect with the conference attendees and speakers. The addition of the SQL-specific, pub-quiz-style evening event SQLafterDark was wildly popular from our past shows and that’s returning for Spring!

SQLintersection: Great Speakers!

Once again, I think a great show starts with great speakers and current / useful content. All of these speakers are industry-experts that have worked in data / SQL for years (some can even boast decades) but all are still focused on consulting and working in the trenches. And, they’re excellent presenters! Not only will you hear useful content but you’ll do so in a way that’s digestible and applicable. Every speaker is either an MCM (Master), a past/present SQL Server MVP, or a past/present Microsoft employee (or a combination of all three!) But, regardless of their official credentials, ALL are focused on providing the most ROI that’s possible in their session(s) and/or their workshops, and ALL have spoken for SQLintersection multiple times.

Check out this phenomenal list of speakers:

  • Anna Thomas – SQL Server team at Microsoft
  • Anthony E. Nocentino – Consultant, MVP
  • Ben Miller – Consultant, past Microsoft, MCM, MVP,
  • Bob Ward – SQL Server team at Microsoft
  • David Pless – Microsoft field, MCM
  • Erin Stellato – SQLskills, MVP
  • Gareth Swanepoel – SQL Server team at Microsoft, past MVP
  • Grant Fritchey – RedGate, MVP
  • Jonathan Kehayias – SQLskills, MCM, MCM Instructor, past MVP
  • Kimberly L. Tripp – SQLskills, past SQL Server team at Microsoft, MCM Instructor, past MVP
  • Pam Lahoud – SQL Server team at Microsoft, MCM
  • Paul S. Randal – SQLskills, past SQL Server team at Microsoft, MCM Instructor, MVP
  • Pedro Lopes – SQL Server team at Microsoft, MCM
  • Tim Chapman – Microsoft field, MCM
  • Tim Radney – SQLskills, MVP

You can read everyone’s full bio on our speaker page here.

SQLintersection: When is it all happening?

The conference officially runs from Tuesday, April 7 through Thursday, April 9 with pre-conference and post-conference workshops that extend the show over a total of up to 6 full days. For the full conference, you’ll want to be there from Sunday, April 5 through Friday, April 10.

  • Sunday, April 5 – pre-con day. There are three workshops running:
    • Getting Started as a Data Engineer with Tim Chapman
    • A Lap Around SQL Server for Linux Folks with Jonathan Kehayias
    • Leveling up with PowerShell for the DBA with Ben Miller
  • Monday, April 6 – pre-con day. There are three workshops running:
    • The Developer’s Guide to Consistency, Accuracy, Concurrency, and Transactional Control with Kimberly L. Tripp
    • Management, Admin, and Best Practices for the Hybrid DBA (SQL Server 2016-2019, Azure SQL DB, Managed Instance) with Tim Radney and David Pless
    • Performance Troubleshooting using Waits and Latches with Paul S. Randal
  • Tuesday, April 7 through Thursday, April 9 is the main conference. Conference sessions will run all day in multiple tracks:
    • Check out our sessions online here
    • Be sure to check out our cross-conference events and sessions
    • Get your pop-culture trivia and techie-SQL-trivia hat on and join us for SQLafterDark on Tuesday evening, April 7
  • Friday, April 10 is our final day with three post-conference workshops running:
    • Kubernetes Zero to Hero: Installation, Configuration, and Application Deployment with Anthony E. Nocentino
    • Performance Tuning and Optimization for Modern Workloads (SQL Server 2016-19, Azure SQL Database, Managed Instance) with David Pless and Tim Radney
    • Query Tuning Tools in SQL Server with Grant Fritchey

SQLintersection: Why is it for you?

If you want practical information delivered by speakers that not-only know the technologies but are competent and consistently highly-rated presenters – this is the show for you. You will understand the RIGHT features to troubleshoot and solve your performance and availability problems now!

Check us out: www.SQLintersection.com.

We hope to see you there!

PS – Use the discount code ‘SQLskills’ when you register and receive $50 off registration!

The Curious Case of… transactions rolling back during DBCC CHECKDB

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.)

 

Continuing the database snapshot theme from the previous Curious Case post, I had another question from someone who was concerned about transactions rolling back during DBCC CHECKDB. They’d just noticed the messages in the error log saying that when DBCC CHECKDB was executed, it was causing transactions to roll back in the database – and how could that possibly be allowed to happen? They said they panicked and stopped all DBCC CHECKDB executions.

 

There’s no need to panic. The problem is actually a bug in the database snapshot code that’s been there since SQL Server 2005, where it reports the wrong database name.

Let’s try this on SQL Server 2019. First I’ll create a simple database, cycle the error log, and start a transaction:

USE [master];
GO

IF DATABASEPROPERTYEX (N'Company_Snapshot', N'Version') > 0
BEGIN
	DROP DATABASE [Company_Snapshot];
END
GO
IF DATABASEPROPERTYEX (N'Company', N'Version') > 0
BEGIN
	ALTER DATABASE [Company] SET SINGLE_USER
		WITH ROLLBACK IMMEDIATE;
	DROP DATABASE [Company];
END
GO

-- Create a database
CREATE DATABASE [Company];
GO

USE [Company];
GO

CREATE TABLE [t1] ([c1] int);
GO

EXEC sp_cycle_errorlog;
GO

BEGIN TRAN
INSERT INTO [t1] VALUES (1);
GO

Now in a separate window, I’ll create a database snapshot an examine the error log:

CREATE DATABASE [Company_Snapshot]
ON (
	NAME = N'Company',
	FILENAME = N'C:\SQLskills\CompanyData.mdfss')
AS SNAPSHOT OF [Company];
GO
EXEC xp_readerrorlog;
GO

And the pertinent lines from the error log are:

2020-01-15 13:29:30.740 spid58       1 transactions rolled back in database 'Company_Snapshot' (17:0). This is an informational message only. No user action is required.
2020-01-15 13:29:30.740 spid58       Recovery is writing a checkpoint in database 'Company_Snapshot' (17). This is an informational message only. No user action is required.

This is correct; the transaction is being rolled back in the context of the database snapshot, to make it transactionally consistent.

Now let’s try a DBCC CHECKDB:

DBCC CHECKDB (N'Company');
GO
EXEC xp_readerrorlog;
GO

And the pertinent lines from the error log are:

2020-01-15 13:31:52.710 spid58       1 transactions rolled back in database 'Company' (21:0). This is an informational message only. No user action is required.
2020-01-15 13:31:52.900 spid58       DBCC CHECKDB (Company) executed by CRINAN\Paul found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 0 seconds.  Internal database snapshot has split point LSN = 00000024:00000087:0001 and first LSN = 00000024:0000003c:0001.

And this is incorrect, and the cause of the concern.

The ‘bug’ is that the name for the internal database snapshot is chosen (by the Database Manager) to be the same as for the real database, and DBCC CHECKDB has no control over that, so it looks like the rollbacks are happening in the real database. But if you look at the database ID in the message, you’ll see that it’s not the same as for the real Company database (which is 5 in this case). So, if you’re ever concerned by a message like this, just look up the database ID of the database you’re running DBCC CHECKDB against and you’ll see that things are fine.

New class: Immersion Event on Using and Administering SSRS and Power BI

By popular demand, we’ve added Tim’s reporting class to our Spring line-up in Chicago!

It’s a two-day class called IEReporting: Immersion Event on Using and Administering SSRS and Power BI and includes Power BI Report Server as well.

Note: there’s a US$100 discount for registering before 1/25/20!

The modules are as follows:

  • Module 1: Administration and Infrastructure
    • Reporting ecosystem overview
    • Reporting architecture
    • How do you get started? (installation and configuration)
    • Administration (PBI RS)
    • Report scheduling and delivery
    • Scale-out / HADR
    • Office integration
    • Security
    • Performance monitoring
  • Module 2: Upgrade, Migration, and Licensing
    • Reporting Services
    • Power BI Report Server
    • Power BI
    • Best Practices
    • Preparing for the reporting certifications and continued training
  • Module 3: Power BI Report Visualizations
    • How do you visualize?
    • Data sources and data sets
    • Analysis Services 101
    • Power BI Desktop walkthrough
    • Mobile Report Publisher
    • Power BI Report Server
  • Module 4: Putting it all together: Building a report and using embedded reports

You can read a more detailed curriculum here and all the class registration and logistical details are here.

We hope to see you there!