Sites anglophones


Updated First Responder Kit and Consultant Toolkit for October 2020

Publié le 15 octobre 2020 sur brentozar.com
 

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

Publié le 15 octobre 2020 sur sqlservercentral.com
 

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

Publié le 15 octobre 2020 sur sqlservercentral.com
 

The post Bringing Data Catalog into your CI/CD pipeline appeared first on SQLServerCentral.

Top 5 SSMS Time Saving Tips

Publié le 15 octobre 2020 sur sqlservercentral.com
 

The post Top 5 SSMS Time Saving Tips appeared first on SQLServerCentral.

Free Webcast on Thursday: Avoiding Deadlocks with Query Tuning

Publié le 14 octobre 2020 sur brentozar.com
 

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

Publié le 13 octobre 2020 sur brentozar.com
 

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

Publié le 12 octobre 2020 sur brentozar.com
 

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

Publié le 10 octobre 2020 sur sqlservercentral.com
 

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.

Publié le 10 octobre 2020 sur brentozar.com
 

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

Publié le 8 octobre 2020 sur SQLSkills.com - Erin Stellato
 

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?

Publié le 8 octobre 2020 sur brentozar.com
 

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

Publié le 8 octobre 2020 sur simple-talk.com
 

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

Publié le 8 octobre 2020 sur sqlservercentral.com
 

The post How We Ended up with Git appeared first on SQLServerCentral.

PowerShell Day by Day: Filtering Objects

Publié le 8 octobre 2020 sur sqlservercentral.com
 

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

Publié le 7 octobre 2020 sur sqlservercentral.com
 

The post Improve Power BI Performance with Horizontal Filtering appeared first on SQLServerCentral.


Pages :