SQL Server with Mr. Denny:


November 18, 2019  4:00 PM

SQL Server 2019 Big Data and Licensing

Denny Cherry Denny Cherry Profile: Denny Cherry

0 Comments     RSS Feed     Email a friend

November 11, 2019  4:00 PM

How to test for query regressions when upgrading

Denny Cherry Denny Cherry Profile: Denny Cherry

One of the things that you want to test for when doing an upgrade of SQL Server is query regressions. Regressions happen when the new version of SQL Server makes a poor decision when running the same code that you can before.  Testing an application against the new version should always be done,...


November 4, 2019  4:00 PM

When to use SQL DB vs SQL DW

Denny Cherry Denny Cherry Profile: Denny Cherry

There’s a lot of confusion around when to use SQL DB or SQL DW with a lot of people assuming that these are interchangeable; so, I wanted to t 0 Comments     RSS Feed     Email a friend


October 28, 2019  4:00 PM

Is it time for an SSIS checkup?

Denny Cherry Denny Cherry Profile: Denny Cherry

On November 15th, 2019 Meagan Longoria and Kerry Type will present their webcast “Is it time for an SSIS checkup?”.


October 21, 2019  4:00 PM

Heading to the #sqlpass Summit? Have Questions? We Have Answers.

Denny Cherry Denny Cherry Profile: Denny Cherry

Are you planning on heading to the PASS Summit starting on November 5th? Do you have questions about the PASS Summit summit or Seattle in 0 Comments     RSS Feed     Email a friend


October 21, 2019  3:05 PM

What is skip-2? What is means to you? And what is compromised to make this happen?

Denny Cherry Denny Cherry Profile: Denny Cherry

Skip-2 is the name of a software package that lets what appears to be state sponsored hackers attack your SQL Server data and download, change or delete data without the auditing that you have configured being triggered.  I won't go in to the details of how skip-2 works, as the folks at ESET have...


October 14, 2019  4:00 PM

What is Page Life Expectancy?

Denny Cherry Denny Cherry Profile: Denny Cherry

If you’ve been a DBA for a while, you’ve heard people talking about PLE.  PLE stands for Page Life Expectancy; most DBAs (and really anyone that works 0 Comments     RSS Feed     Email a friend


October 7, 2019  4:00 PM

Doing something in a loop in Microsoft flow, and something else if there’s no match

Denny Cherry Denny Cherry Profile: Denny Cherry

Recently I wanted to make a Microsoft flow process to create channels in Microsoft Teams once a project is ready to start.  If the channel was already there then I wanted a message to be posted to the Teams channel saying that the project was ready, but that it didn't need to create the channel. ...


September 30, 2019  4:00 PM

How big can you make a SQL Server transaction log file?

Denny Cherry Denny Cherry Profile: Denny Cherry

While the GUI (SSMS) has UNLIMITED in there, that’s actually not the right answer here. If you set the truncation log file to UNLIMITED and click 0 Comments     RSS Feed     Email a friend


September 28, 2019  4:00 PM

Can I setup replication with an availability group as the subscriber?

Denny Cherry Denny Cherry Profile: Denny Cherry

Yes, absolutely. In order to do this, you need to configure the replication to use the Availability Group listener as the subscriber.  That way, the database 0 Comments     RSS Feed     Email a friend


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: