Sites anglophones


Should you run SSAS/SSIS/SSRS on the SQL Server?

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

When you’re building a new SQL Server, you’re going to see a few intriguing checkboxes during setup. It’s all free, right? Check everything! The services are all free, right? You can just check the boxes for Machine Learning Services, …

How to Apply Non-Standard SQL Formatting Using SQL Prompt

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

Like any good tool, SQL Prompt not only will format your code for you, but will also help you to format the code in an alternative manner, or to apply exceptions to certain parts of a SQL script, where the formatting applies by the current style isn’t …

Why Redgate is Running a Database Development Disasters Contest?

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

Kendra Little explains why Redgate would like to hear your stories of how the database has been left behind.

Frequently Asked Questions for SQL Server Performance Tuning Practical Workshop for EVERYONE

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

Earlier this week I announced my very first online training class open for (US, EU, Asia, and Everywhere) over here: SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019, and so far I have received an amazing respon …

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 …


Pages :