Sites anglophones


Getting started with SQL Server stored procedures

Publié le 20 août 2020 sur sqlservercentral.com
 

The post Getting started with SQL Server stored procedures appeared first on SQLServerCentral.

Introducing SQL Change Automation 4.3

Publié le 20 août 2020 sur sqlservercentral.com
 

The post Introducing SQL Change Automation 4.3 appeared first on SQLServerCentral.

sp_Blitz Pro Tips for Managing Multiple Servers Centrally

Publié le 19 août 2020 sur brentozar.com
 

sp_Blitz is a free health check script that gives you a prioritized list of things to fix on your SQL Server. Here’s what the output looks like: Most of the time, you’ll want to work through the warnings in the order that they show up in th …

SQL SERVER – Live Query Statistics – SQL in Sixty Seconds #104

Publié le 19 août 2020 sur journey to sqlauthority
 

It is very easy to know what is the queries past and future with the help of the execution plan as well as Dynamic Management Views. However, the biggest challenge is to know the details about the queries current execution status. In this SQL in Sixty …

Redgate Streamed Returns

Publié le 19 août 2020 sur sqlservercentral.com
 

The post Redgate Streamed Returns appeared first on SQLServerCentral.

Heaps in SQL Server: Part 3 Nonclustered Indexes

Publié le 18 août 2020 sur simple-talk.com
 

The series so far: Heaps in SQL Server: Part 1 The Basics Heaps in SQL Server: Part 2 Optimizing Reads Heaps in SQL Server: Part 3 Nonclustered Indexes The previous article Heaps in SQL Server: Part 2 Optimizing Reads described how performance could be …

sp_BlitzIndex Pro Tips for Consultants & Contractors

Publié le 18 août 2020 sur brentozar.com
 

sp_BlitzIndex analyzes the design & health of your clustered & nonclustered rowstore indexes and gives you suggestions on how to get higher performance without changing your queries. If you run it with no parameters, you get advice on the index …

SQL SERVER – Offline, Detach and Drop – Differences – SQL in Sixty Seconds #103

Publié le 18 août 2020 sur journey to sqlauthority
 

During the recent consulting engagement of Comprehensive Database Performance Health Check, I was asked by my client, if I can help them understand the difference between database status like Offline, Detach and Drop. It was very important to differenc …

Maximize View of SQL Server Query Plans with Full Screen Option

Publié le 18 août 2020 sur sqlservercentral.com
 

The post Maximize View of SQL Server Query Plans with Full Screen Option appeared first on SQLServerCentral.

Recover database encrypted modules code with dbatools

Publié le 18 août 2020 sur sqlservercentral.com
 

SQL Server offers an option to encrypt the code of your modules when using the ‘WITH ENCRYPTION’ syntax. This allows to hide/obfuscate the modules’ code and thus keep away from prying eyes. It’s often used to protect business rules since it allows you …

Explaining SQL Server Statistics with Playing Cards

Publié le 17 août 2020 sur brentozar.com
 

When you run a query, how does SQL Server estimate the number of rows? I’ll explain in this half-hour video demo using playing cards, then showing the same issues in SQL Server Management Studio: Here’s the demo script I use in the video. T …

Are Not Equal to Operators Equal to Not In? – SQL in Sixty Seconds #102

Publié le 17 août 2020 sur journey to sqlauthority
 

What I love most about my job Comprehensive Database Performance Health Check, is that I get to work with different people and answer questions. Today we will see a very interesting question – Are Not Equal (<> or !=! to Operators Equal to …

Create Azure Data Factory inventory using Databricks

Publié le 17 août 2020 sur sqlservercentral.com
 

The post Create Azure Data Factory inventory using Databricks appeared first on SQLServerCentral.

The Two Ways Containers Will Revolutionize Database DevOps

Publié le 17 août 2020 sur simple-talk.com
 

Table of Contents Revolution 1 – Database Provisioning as a Service Why didn’t this happen earlier with SAN automation and virtualization? Why do containers change this? They aren’t inherently stateful Steve Jones shows what the futur …

How to override Date Filters in Power BI

Publié le 17 août 2020 sur sqlservercentral.com
 

Problem A few weeks back, I got a request from a client of mine who had a very special requirement. They wanted to display values for a specific period in the past based on the selected dates in the Power BI report. Let us assume that if we select …


Pages :