Updated First Responder Kit and Consultant Toolkit for October 2020
In preparation for this month’s new Fundamentals of Columnstore class, sp_BlitzIndex has a few cool new tricks! I’ll show you how to use ’em for free in the upcoming How I Use the First Responder Kit class, too. Columnstore indexes ar …
Getting Started with Gremlin
Apache TinkerPop is an open source graph computing framework. A graph computing network is a set of vertices and edges in the network. If we compare a graph database to traditional relational databases, we can assume that every row in a table of a rela …
Bringing Data Catalog into your CI/CD pipeline
The post Bringing Data Catalog into your CI/CD pipeline appeared first on SQLServerCentral.
Top 5 SSMS Time Saving Tips
The post Top 5 SSMS Time Saving Tips appeared first on SQLServerCentral.
Free Webcast on Thursday: Avoiding Deadlocks with Query Tuning
To fix blocking & deadlocks, you have 3 tools: Have enough indexes to make your queries fast, but not so many that they slow down delete/update/insert operations. (I cover that in the Mastering Index Tuning class.) Use the right isolation level for …
Databases Are Like Walk-In Coolers. #tsql2sday
In the back of a restaurant, there’s a walk-in cooler (or a few of ’em.) When a chef needs to make something, she goes into the walk-in cooler, gathers the necessary ingredients, and then comes out to the kitchen to do the cooking. She does …
Free Live Fundamentals Classes, Registration Open Now
Well, this quarantine just isn’t letting up, so it’s time for another round of free training. I’m running 3 free live classes on October 26-28: October 26: Fundamentals of Index Tuning – 9AM-5 Eastern – …
Automate MSBI deployments Using PowerShell
Microsoft BI tools are widely used in Business Intelligence (BI) projects nowadays due to their end to end BI capabilities and lower licensing costs. We work in an agile world where the application teams are making use of various tools, like Jenkins, t …
Woohoo! We Hit 25,000 YouTube Subscribers.
As I finished this weekend’s live stream, I noticed that we crossed a big number. The Brent Ozar Unlimited YouTube channel now has over 25,000 subscribers. Well, that’s kinda awesome. I’ve had a great time doing all kinds of free live …
ALTER Procedures When Using Query Store
When I talk about Plan Forcing I always discuss how users should ALTER procedures when using Query Store, and not use DROP and CREATE. This is valid beyond Plan Forcing cases; it’s a best practice I recommend however you are using Query Store. Ev …
What Is the SQL Server CEIP Service?
The CEIP Service is the Customer Experience Improvement Program that sends telemetry data back to Microsoft. When you install Microsoft SQL Server, the CEIP Service is installed too. You can’t disable it during installation: it shows up in your s …
DBA in training: Security
The series so far: DBA in training: So, you want to be a DBA… DBA in training: Preparing for interviews DBA in training: Know your environment(s) DBA in training: Security By this time, we have discussed the importance of understanding your environme …
How We Ended up with Git
The post How We Ended up with Git appeared first on SQLServerCentral.
PowerShell Day by Day: Filtering Objects
In my last article, The Basics of PowerShell Day By Day, I covered some basics of getting started. These articles aren’t intended to replace some of the getting started information in things like the Stairway to PowerShell. Instead, I am covering some …
Improve Power BI Performance with Horizontal Filtering
The post Improve Power BI Performance with Horizontal Filtering appeared first on SQLServerCentral.