Sites anglophones


Overview of Azure SQL Database Networking

Publié le 20 décembre 2019 sur sqlservercentral.com
 

The post Overview of Azure SQL Database Networking appeared first on SQLServerCentral.

Voting Open for #SQLBits Sessions, and Here’s My Oddball Idea

Publié le 19 décembre 2019 sur brentozar.com
 

Voting is open now for SQLBits sessions, and I have to warn you that there are a LOT of sessions to choose from. Bits doesn’t just flat out take the top vote-getting sessions – they use votes as part of the session selection factor – …

Wait statistics workshop at SQLBits in London 2020 – finally!

Publié le 19 décembre 2019 sur sqlskills.com - paul randall
 

We’re coming to SQLBits finally! Both Kimberly and I will be there for the first time in London in March/April – at long last the dates work for us – plus Erin will be there again too. The training day schedule for the conference …

SQL SERVER – Parameter Sniffing Simplest Example

Publié le 19 décembre 2019 sur journey to sqlauthority
 

Today we will see a very simple example of the Parameter Sniffing. I was asked by my client if I can explain to them what is the simplest example of the parameter sniffing during a recent consulting engagement of Comprehensive Database Performance Heal …

Redgate acknowledged as a Representative Vendor in Gartner’s 2019 Market Guide for Data Masking

Publié le 19 décembre 2019 sur sqlservercentral.com
 

The post Redgate acknowledged as a Representative Vendor in Gartner’s 2019 Market Guide for Data Masking appeared first on SQLServerCentral.

Memory-Optimized TempDB Metadata in SQL Server 2019

Publié le 19 décembre 2019 sur sqlservercentral.com
 

The post Memory-Optimized TempDB Metadata in SQL Server 2019 appeared first on SQLServerCentral.

Finding Non Current Cumulative Updates

Publié le 19 décembre 2019 sur sqlservercentral.com
 

Recently, I needed to test an older CU and couldn’t find it. At least not easily. Previously I had just searched for the update and usually quickly found it, but some of the changes on the Microsoft sites have made this harder. This is a short article …

Translating a SQL Server Schema into a Cassandra Table: Part I Problem Space and Cassandra Primary Key

Publié le 18 décembre 2019 sur simple-talk.com
 

The series so far: Translating a SQL Server Schema into a Cassandra Table: Part I Problem Space and Cassandra Primary Key A subset of related tables in a relational schema can satisfy any number of queries known and unknown at design time. Refactoring …

The Two Ways to Fix Non-Sargable Queries

Publié le 18 décembre 2019 sur brentozar.com
 

In the database world, when we say something isn’t sargable, what we mean is that SQL Server is having a tough time with your Search ARGuments. What a sargable query looks like In a perfect world, when you search for something, SQL Server can do …

SQL SERVER – SET NOCOUNT – Impact on Stored Procedure Performance

Publié le 18 décembre 2019 sur journey to sqlauthority
 

Sometimes it is critical to get back to basics when working on solving a complex problem at Comprehensive Database Performance Health Check. Recently, I solved a huge performance problem for one of my clients by just adding the SET NOCOUNT inside the s …

A Beginner’s Guide to SQL String Functions

Publié le 18 décembre 2019 sur sqlservercentral.com
 

The post A Beginner’s Guide to SQL String Functions appeared first on SQLServerCentral.

SQL SERVER – Copy Database Without Statistics Query Store

Publié le 17 décembre 2019 sur journey to sqlauthority
 

I love the follow-up questions as they demonstrate that my blog posts are read and help everything think of their own environment. Here is the follow-up question I have received to my earlier blog post about Clone Database Using DBCC CLONEDATABASE. Thi …

Test data provisioning for development – free whitepaper

Publié le 17 décembre 2019 sur sqlservercentral.com
 

The post Test data provisioning for development – free whitepaper appeared first on SQLServerCentral.

Update only Year, Month or Day in a SQL Server Date

Publié le 17 décembre 2019 sur sqlservercentral.com
 

The post Update only Year, Month or Day in a SQL Server Date appeared first on SQLServerCentral.

Monitor Current Analysis Services Activity

Publié le 17 décembre 2019 sur sqlservercentral.com
 

Although not every business has SSAS (SQL Server Analysis Services) installed nor use it extensively, the ones who do also care about their database responsiveness. If it is slow, what else is running that may be causing the slowness? Are there any loc …


Pages :