Sites anglophones


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.

What is database continuous integration?

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

Continuous Integration (CI) is an essential step of application development for DevOps organisations. Whenever a developer commits code, a build is kicked off. The code must compile and pass automated testing before it is merged into the main branch. D …

Poor Man’s Resource Governor: Database-Scoped Configurations

Publié le 6 octobre 2020 sur brentozar.com
 

Let’s say you had report queries that were going wildly parallel, and you wanted to put a stop to it, but you couldn’t afford SQL Server Enterprise Edition. You could do is create databases with different MAXDOP settings:CREATE DATABASE [MA …

Storage 101: Monitoring storage metrics

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

The series so far: Storage 101: Welcome to the Wonderful World of Storage Storage 101: The Language of Storage Storage 101: Understanding the Hard-Disk Drive  Storage 101: Understanding the NAND Flash Solid State Drive Storage 101: Data Cente …

Experimenting with PostgreSQL in a Container

Publié le 6 octobre 2020 sur sqlservercentral.com
 

PostgreSQL is a popular Open Source relational database platform. It is available at https://www.postgresql.org, and it was designed as a better Ingres database. Across the last 30 years, it has improved and grown quite a bit. This was the first open s …

SQL Server High CPU Query Use Monitoring with PowerShell

Publié le 6 octobre 2020 sur sqlservercentral.com
 

The post SQL Server High CPU Query Use Monitoring with PowerShell appeared first on SQLServerCentral.

Free Webcast on Wednesday: The New Robot DBAs in SQL Server 2017, 2019, and Azure

Publié le 5 octobre 2020 sur brentozar.com
 

The robots are really just people wearing metallic masks. You’ve been hearing about all these robots that are coming to take your job. They’re going to automate all the performance tuning and make your life way easier, right? Or harder, I g …


Pages :