Collections: Computed gaps for continuous numbers
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
The post Streamline and Acclerate SQL Server Data Warehousing appeared first on SQLServerCentral.
Making SQL Server Function Changes Backwards Compatible
The post Making SQL Server Function Changes Backwards Compatible appeared first on SQLServerCentral.
Tagging SQL Server Changes in SQL Monitor
The post Tagging SQL Server Changes in SQL Monitor appeared first on SQLServerCentral.
[Video] What Percent Complete Is That Index Build?
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
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
The post Evaluating SQL Data Catalog using Docker Containers appeared first on SQLServerCentral.
The post Virtual Reality appeared first on SQLServerCentral.
Updated First Responder Kit and Consultant Toolkit for March 2020
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
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
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
The post Using SQL Monitor Groups in PowerShell appeared first on SQLServerCentral.
The First Time I Had to Restore a Database
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
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
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 …