Sites anglophones


Collections: Computed gaps for continuous numbers

Publié le 30 mars 2020 sur sqlservercentral.com
 

Problem Finding the hole for continuous sequences of numbers could be a discouraging task even for advanced programmers. This article presents a new solution based on usage of geometry data type and on a unknown function (if not, maybe less used functi …

Streamline and Acclerate SQL Server Data Warehousing

Publié le 30 mars 2020 sur sqlservercentral.com
 

The post Streamline and Acclerate SQL Server Data Warehousing appeared first on SQLServerCentral.

Making SQL Server Function Changes Backwards Compatible

Publié le 27 mars 2020 sur sqlservercentral.com
 

The post Making SQL Server Function Changes Backwards Compatible appeared first on SQLServerCentral.

Tagging SQL Server Changes in SQL Monitor

Publié le 27 mars 2020 sur sqlservercentral.com
 

The post Tagging SQL Server Changes in SQL Monitor appeared first on SQLServerCentral.

[Video] What Percent Complete Is That Index Build?

Publié le 26 mars 2020 sur brentozar.com
 

SQL Server 2017 & newer have a new DMV, sys.index_resumable_operations, that show you the percent_completion for index creations and rebuilds. It works, but…only if the data isn’t changing. But of course your data is changing …

DAX For SQL Folks: Part I- Intro to DAX, Power BI and Data Viz

Publié le 26 mars 2020 sur sqlservercentral.com
 

 Introduction In response to my approach in the popular MDX Guide for SQL Folks series, I am going to try and repeat the same style of learning for the Data Analysis Expression(DAX) language. I am going to use SQL as a good frame of reference for …

Evaluating SQL Data Catalog using Docker Containers

Publié le 26 mars 2020 sur sqlservercentral.com
 

The post Evaluating SQL Data Catalog using Docker Containers appeared first on SQLServerCentral.

Virtual Reality

Publié le 26 mars 2020 sur sqlservercentral.com
 

The post Virtual Reality appeared first on SQLServerCentral.

Updated First Responder Kit and Consultant Toolkit for March 2020

Publié le 25 mars 2020 sur brentozar.com
 

In the immortal words of “Orange” Julius Caesar as written by Shake’s peer, “Beware the bugs of March.” It took us 2,064 years, but we’ve finally fixed those bugs, plus added a couple of new features. To get the new …

Reduce CPU of Large Analytic Queries Without Changing Code

Publié le 25 mars 2020 sur simple-talk.com
 

When Microsoft came out with columnstore in SQL Server 2012, they introduced a new way to process data called Batch Mode. Batch mode processes a group of rows together as a batch, instead of processing the data row by row. By processing data in batches …

Using relog: Creating a smaller file

Publié le 25 mars 2020 sur SQLSkills.com - Erin Stellato
 

 Today I had to remember the steps for using relog. If you’ve never heard of relog, stay with me. It’s a tool for merging PerfMon files, and also for extracting smaller data sets from Perfmon. I still love PerfMon friends, I admit it. …

Using SQL Monitor Groups in PowerShell

Publié le 25 mars 2020 sur sqlservercentral.com
 

The post Using SQL Monitor Groups in PowerShell appeared first on SQLServerCentral.

The First Time I Had to Restore a Database

Publié le 24 mars 2020 sur brentozar.com
 

Not the exact same time frame, but not that far off. I remember it really clearly. In the mid 1990s, long, long before I went into IT as a career, I was working at a photo studio in Muskegon, Michigan. They specialized in high school class photos, and …

Work from Home Contest – Download Spotlight And Win USD 100

Publié le 24 mars 2020 sur journey to sqlauthority
 

Many of us are working from home nowadays due to Covid-10 (Novel Coronavirus) and during this time, it is very important that we keep watching our health. Many of the readers are of this blog are Database Administrators and Database Developers and it i …

Creating SQL containers on Azure Data Studio Notebooks with Python

Publié le 24 mars 2020 sur sqlservercentral.com
 

Background history The SQL Server tools team at Microsoft introduced Notebooks to Azure Data Studio (ADS) around March 2019. Since then, data professionals from the SQL Server community have been posting and sharing knowledge on how to make the most of …


Pages :