Sites anglophones


[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 …

Power BI Dashboard vs Report vs Workbook

Publié le 24 mars 2020 sur sqlservercentral.com
 

The post Power BI Dashboard vs Report vs Workbook appeared first on SQLServerCentral.

Avoid using constants in an ORDER BY clause

Publié le 24 mars 2020 sur sqlservercentral.com
 

The post Avoid using constants in an ORDER BY clause appeared first on SQLServerCentral.

How was a plan forced?

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

If you use Automatic Plan Correction, and thus also Query Store, you may wonder how was a plan forced: manually or automatically with APC?  The type of forced plan is tracked in sys.query_store_plan, and you can use this simple query to determine …

SQL SERVER – Error 9002: The Transaction Log for Database ‘SQLAuthority’ is Full Due to ‘REPLICATION’

Publié le 23 mars 2020 sur journey to sqlauthority
 

Recently one of my clients contacted me to provide them assistance in finding and fixing the cause of a huge transaction log file. There are many caused to get error 9002 in SQL Server ERRORLOG. In this blog, I would explain the cause and fix of error: …


Pages :