Sites anglophones

Practical Real World Performance Tuning – Reviews and Feedback

Publié le 7 septembre 2018 sur journey to sqlauthority

I have so far received an amazing response to my online class Practical Real World Performance Tuning. As I am writing this blog post so far we have 37 reviews for this class. In today’s blog post we will go over a few of the reviews and fee …

Going to Summit? Here’s a Calendar Invite for My Session.

Publié le 6 septembre 2018 sur

At Summit, on Wednesday at 1:30PM in room 6C, I’m presenting “Getting Better Query Plans by Improving SQL’s Estimates.” Add to GMail Calendar ICS file for Outlook or other calendar apps Here’s the abstract: Like Books Onli …

It’s Okay If You Don’t Create Statistics.

Publié le 6 septembre 2018 sur

Along with the ability to create indexes (which you most definitely should be doing), SQL Server gives you the ability to create statistics. This helps SQL Server guess how many rows will come back for your searches, which can help it make better decis …

8 practices for business data security

Publié le 6 septembre 2018 sur

Is your data vulnerable to security breaches? Sophie Ross at Security Gladiators provides 8 rules you should be adhering to to ensure the safety of your data.

Creating Subtotals and Totals in Aggregated Queries

Publié le 6 septembre 2018 sur

Grouping Sets are an effective way to add subtotals to aggregated queries. T His article explains how.

Free eBook: SQL Server Execution Plans, Second Edition

Publié le 6 septembre 2018 sur

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slow …

Introduction to Testing Your PowerShell Code with Pester

Publié le 6 septembre 2018 sur

Everyone knows how important code testing is, and to be thorough, you must automate testing. This includes scripts such as those written in PowerShell as well. In this article, Robert Cain introduces Pester, a tool for testing PowerShell code.

SQL SERVER – Automated SQL Server Consolidation and Right Sizing – Save 50% Data Platform Costs

Publié le 6 septembre 2018 sur journey to sqlauthority

The Story Behind Consolidation and Right-Sizing If you have ever needed to implement a large-scale data platform migration or consolidation project, you are definitely familiar with many of the pain points faced during the process. Firstly, manual …

SQLskills is now a Microsoft Gold Data Platform Partner

Publié le 5 septembre 2018 sur - paul randall

We’ve been doing a huge amount of work this year with Microsoft field offices and customers on upgrades and Azure (especially around Azure Managed Instance) and it’s apparent that certain customers can be reluctant to engage with …

Locks Taken During Indexed View Modifications

Publié le 5 septembre 2018 sur

Frankenblog This post has been nagging at me for a while, because I had seen it hinted about in several other places, but never written about beyond passing comments. A long while back, Conor Cunningham wrote: This same condition applies to indexed vie …

Using MERGE in SQL Server to insert, update and delete at the same time

Publié le 5 septembre 2018 sur

In a typical data warehousing application, quite often during the ETL cycle you need to perform INSERT, UPDATE and DELETE operations on a TARGET table by matching the records from the SOURCE table.

SQL SERVER – Generating In-Memory OLTP Migration CheckList

Publié le 5 septembre 2018 sur journey to sqlauthority

During recent Comprehensive Database Performance Health Check, one of my customer asked if I can also help them to check their readiness of In-Memory OLTP Migration as well as the help them build a checklist which can help them with In-M …

Single-Column-Key Missing Index Recommendations are Usually Wrong.

Publié le 4 septembre 2018 sur

When you’re looking at an index recommendation – whether it’s in an execution plan or the missing index DMVs – it helps to understand Clippy’s blind spots. Let’s start with the small StackOverflow2010 database so you …

Modern Data Warehouse Design Pattern – Part I

Publié le 4 septembre 2018 sur

The modern data warehouse design helps in building a hub for all types of data to initiate integrated and transformative solutions. To achieve these goals and to support modern designs, Microsoft has introduced a set of fully managed, cloud-based servi …

Create AT&T Network Hierarchy Diagrams using SQL Server Data

Publié le 4 septembre 2018 sur

Diagrammatic support for large, complex hierarchical data structures in SQL Server.

Pages :