Sites anglophones


Using the Wait Statistics Report in Azure Data Studio

Publié le 13 février 2019 sur sqlskills.com - paul randall
 

Azure Data Studio, which used to be called SQL Operations Studio, has a bunch of extensions available, including one called Server Reports from Microsoft. Last year they took my wait stats query (from here) and made it into a report as part of Ser …

How fast can a $21,468/mo Azure SQL DB load data?

Publié le 13 février 2019 sur brentozar.com
 

In my last post, I explored how fast a $5,436/mo Azure SQL DB Hyperscale could load data. I’d had a client who was curious about spinning up their dev environment up there to see how query plans might look different. Well, as long as I was runnin …

Stairway to Server Management Objects (SMO) Level 1: Concepts and Basics

Publié le 13 février 2019 sur sqlservercentral.com
 

Learn how to get started working with SMO and PowerShell.

Provisioning Multiple Masked Databases

Publié le 13 février 2019 sur sqlservercentral.com
 

Addressing common challenges, Redgate’s Chris Unwin explains how to create multiple masked copies of a database, delivered as a group with SQL Provision.

SQL SERVER – New Parallel Operation Cannot be Started Due to Too Many Parallel Operations Executing at this Time

Publié le 13 février 2019 sur journey to sqlauthority
 

One of my clients contacted me via my On Demand (50 Minutes) offering and they were seeing below error message in ERRORLOG – New parallel operation cannot be started due to too many parallel operations executing at this time. Here is the complete …

How fast can a $5,436/mo Azure SQL DB Hyperscale load data?

Publié le 12 février 2019 sur brentozar.com
 

A client asked, “How quickly could we spin up a full copy of our database in the new Azure SQL DB Hyperscale?” Their database size wasn’t too far off from the 340GB Stack Overflow database, so I decided to migrate that to Hy …

Infrastructure Planning for a SQL Server Data Warehouse

Publié le 12 février 2019 sur sqlservercentral.com
 

In this tip we look at some things you should think about when planning for a SQL Server data warehouse.

Using Computed Columns

Publié le 12 février 2019 sur sqlservercentral.com
 

Although computed columns are from the beginning of SQL Server, not everyone knows how to use them. This article will help you better understand how it works.

The Whys and Wherefores of Untrusted or Disabled Constraints

Publié le 12 février 2019 sur sqlservercentral.com
 

Phil Factor explains what causes this issue, the problems it will cause and how to avoid the problem

First Online Open for All Class: SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019

Publié le 12 février 2019 sur journey to sqlauthority
 

I have been delivering SQL Server Performance Tuning Practical Workshop for various organizations and it has been an extremely popular class so far. I get lots of requesting that I should deliver it for individuals. The only reason, I never schedu …

The Performance of Window Aggregates Revisited with SQL Server 2019

Publié le 11 février 2019 sur simple-talk.com
 

In 2005 and 2012, Microsoft introduced a number of windowing functions in SQL Server, like my favourite function LAG. These functions perform well, but, in my opinion, the main benefit is making complicated queries easier to write. I’ve been fasc …

Create, Protect and manage non-production databases with SQL Provision

Publié le 11 février 2019 sur sqlservercentral.com
 

SQL Provision allows teams to create a secure, scalable and repeatable process for managing data as it moves through your SQL Server estate, without causing administrative burdens. Tony Davis explains how SQL Provision can work alongside your existing …

SQL SERVER – Cannot Drop the Assembly ‘ISSERVER’, Because it Does not Exist or You do not Have Permission

Publié le 11 février 2019 sur journey to sqlauthority
 

As they say – There are more ways than one to skin a cat. In this blog we will find another method to fix an error which you might see during SQL upgrades – Cannot drop the assembly ‘ISSERVER’, because it does not exist or you d …

What Microsoft's Open Source PostgreSQL Acquisition Portends for SQL Server

Publié le 10 février 2019 sur sqlmag.com
 

Microsoft’s acquisition of Citus Data expands on the Azure commitment to open source and may provide horizontal scaling for SQL Server.

What is Consolidation of Index? – Interview Question of the Week #212

Publié le 10 février 2019 sur journey to sqlauthority
 

Question: What is Consolidation of Index? Answer: In the recent SQL Server Performance Tuning Practical Workshop, I was asked this question and the answer to this question is really not as straight forward as want to have. Here is an example of wh …


Pages :