Reducing the Frequency of SQL Server Central Newsletters
We are reducing the frequency of SQL Server Central newsletters from 5 a week to 3 starting on May 3. We will send out our regular newsletter on Monday, Wednesday, and Friday to all subscribers. The Database Weekly newsletter will continue to come out …
SQL Server plan cache mining – Plan attributes
The execution plan cache in SQL Server is a treasure trove of information about queries that have recently executed. In addition to query text and execution plan details, a wide variety of statistics, options, and parameters are available to research, …
Creating Database Build Artifacts when Running Flyway Migrations
The post Creating Database Build Artifacts when Running Flyway Migrations appeared first on SQLServerCentral.
An Introduction to Azure Data Explorer
Introduction Big data consists of very large datasets, which can be structured, unstructured, and semi-structured. Data may be coming from various data sources in real-time or in batches. The traditional tools and technologies we have used in the past …
Learn basics of Data Wrangling in SQL Server to handle Invalid Values
The post Learn basics of Data Wrangling in SQL Server to handle Invalid Values appeared first on SQLServerCentral.
Updated First Responder Kit and Consultant Toolkit for April 2021
This month’s release has two gems for SQL Server 2019 users. First, thanks to Greg Dodd, when you’re dealing with parameter sniffing issues, sp_BlitzWho can now show you the cached and live parameters for running queries. This lets you quic …
Dynamically Add a Timestamp To Files in Azure Data Factory
This article will describe how to add your local timestamp at the end of the each file in Azure Data Factory (ADF). In general, ADF gets a UTC timestamp, so we need to convert the timestamp from UTC to EST, since our local time zone is EST. For example …
Common Data Transformations in Power Query
The post Common Data Transformations in Power Query appeared first on SQLServerCentral.
Batch Processing using Flyway
The post Batch Processing using Flyway appeared first on SQLServerCentral.
Who’s Hiring in the Database Community? April 2021 Edition
I’ve gotten a lot of emails from friends lately who are looking for work. It seems that as some companies go back to the office, some people are realizing they want to work remotely forever. And on the flip side, other folks are realizing they de …
Installing Docker Desktop on Mac
Introduction This article will help you install the Docker Desktop for Mac. Before we show that, let us start by understanding what the Docker Desktop software can do for you. To understand Docker, we need to understand what a container is. If you reme …
Recover Deleted TDE Key for Azure SQL Database
The post Recover Deleted TDE Key for Azure SQL Database appeared first on SQLServerCentral.
Free TempDB Training Class Next Monday
You’ve been working with Microsoft SQL Server for a couple of years, and you know a little bit about TempDB. You’ve heard that temp tables and table variables have different performance characteristics than regular user database tables, and …
Navigating Trees With CTE
Introduction This article shows how common table expressions (CTE) in SQL Server are naturally suited for navigating trees, such as finding its longest path, or diameter. Recall that a tree is an undirected graph where unique paths exist between any tw …
Tell us about how you monitor your databases
The post Tell us about how you monitor your databases appeared first on SQLServerCentral.