[Video] Free DBA Training Month: Checking For Corruption
For the last couple of months, I’ve been giving away all kinds of free online training to help y’all stay busy and raise your skills during the quarantines. March and April were all about performance tuning, so let’s change things up …
Postgresql JDBC Tutorial on Linux
PosgtreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language. Though originally designed to run on UNIX platforms, Postgres is able to run on various platforms, such as macOS, Solaris, Wi …
SQL Change Automation enables a new flexible approach to DevOps
The post SQL Change Automation enables a new flexible approach to DevOps appeared first on SQLServerCentral.
Making a Difference in Uncertain Times
The post Making a Difference in Uncertain Times appeared first on SQLServerCentral.
Free Upcoming Live Classes
So, we’re still under lockdown, huh? I see. Well, I guess I’ve got no choice but to keep y’all busy. Let’s get together for some free live classes: May 9 (Sat) 9AM Eastern: How to Think Like the SQL Server Engine: All Demo Editi …
Capturing DBCC CHECKDB Output
If you haven’t experienced database corruption in your SQL Server career and had to pore over DBCC CHECKDB output, you’re a lucky soul. If you encounter corruption, the most important thing you can have is the output, because this hel …
Set Statistics Time Examples for Tuning SQL Server Queries
The post Set Statistics Time Examples for Tuning SQL Server Queries appeared first on SQLServerCentral.
The Curious Case of… extent scan fragmentation
(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 …
[Video] Updated First Responder Kit and Consultant Toolkit for May 2020
We have quarantined all of the bugs. Many of the bugs. Okay, 7 of the bugs. Hey, we actually added more improvements than we fixed bugs this month! My favorite new things are that sp_BlitzIndex @Mode = 2 now makes it even easier to do disconnected inde …
No, You Can’t Calculate the Tipping Point with Simple Percentages.
This morning, Greg Gonzalez (who I respect) posted about visualizing the tipping point with Plan Explorer (a product I respect), and he wrote: The tipping point is the threshold at which a query plan will “tip” from seeking a non-covering n …
Dynamic SQL Going Haywire
Those who work on various databases, or even those who do not, must have come across the term, Dynamic SQL. Dynamic SQL is basically a programming technique that enables you to build SQL statements dynamically at run time. It allows you to create more …
How to Attach a SQL Server Database without a Transaction Log and with Open Transactions
The post How to Attach a SQL Server Database without a Transaction Log and with Open Transactions appeared first on SQLServerCentral.
Your Views Aren’t The Problem. Your Code Is.
“I hate views,” the DBA said. “They kill performance. And nested views are even worse.” Wrong. I’ll prove it. I’m going to use the 50GB StackOverflow2013 database, and I’ll start by creating a couple of indexes …
Announcing Two New Parameter Sniffing Classes
During the quarantine downtime, I’m working on a couple of new classes that I think you’re gonna like. Both of them are 100% demos, no slides (other than introductions at the start of the day), complete with hands-on lab assignment challeng …
How to Resolve a Duplicate Key Error in SSAS
Problem Often while working with SQL Server Analysis Services, developers come across many errors that restrict them from deploying or processing the cube. In this article, I’m going to explain the reason that causes the Duplicate Key error in SSAS. Th …