SQLBits 2020 – SQL Server Performance Tuning Real-World Scenarios – at ExCel London
I am pretty excited that I will be presenting a day-long training at SQLBits on 31 March 2020 at ExCel London on the topic SQL Server Performance Tuning Real-World Scenarios. I have learned that many of the seats are already booked and now on …
Using Calendars and Dates in Power BI
The series so far: Creating Calculated Columns Using DAX Creating Measures Using DAX Using the DAX Calculate and Values Functions Using the FILTER Function in DAX Cracking DAX – the EARLIER and RANKX Functions Using Calendars and Dates in Po …
Fixing A previous restore operation was interrupted and did not complete processing
I recently was working on a customer system where a myriad of bad things had occurred simultaneously that left them in a scenario where their primary database server had corruption of an important database and their DR Log Shipped Secondary server coul …
SQL SERVER – SQL Azure Managed Instance Restore Error – The Database Was Backed Up on a Server Running Version 15.00.2000
Based on the current trend of moving to the cloud platform, there have been many new learnings for me. One of my clients migrated to SQL Azure Managed Instance and contacted me for an interesting situation. In this blog, I am going to share my findings …
SQL Server Best Practices for Data Quality
The post SQL Server Best Practices for Data Quality appeared first on SQLServerCentral.
Introduction to Gaps and Islands Analysis
One of the most significant challenges we face when analyzing data is pattern recognition. We seek to find ways in which our data deviates from the norm or conforms to a given norm. The goal is to identify tools that can be used to predict future behav …
SQL SERVER – ISNUMERIC Function and Interesting Result
Today’s blog post is based on a very interesting observation sent to my client of the Comprehensive Database Performance Health Check. While I primarily focus on improving the performance of SQL Server, often I receive question-related to T-SQL a …
Using SQL Change Automation in SSMS to Track Static Data Changes
The post Using SQL Change Automation in SSMS to Track Static Data Changes appeared first on SQLServerCentral.
Building a Countdown Timer with PowerShell
The post Building a Countdown Timer with PowerShell appeared first on SQLServerCentral.
Exporting Data with PowerShell
Recently I had the need to help someone download some data from SQL Server as a part of an automated process. In this case, the person wanted to use PowerShell (PoSh), since they were performing a few other actions with PoSh as well. This article is a …
Why the Database Must be Part of DevOps
According to Microsoft, DevOps is “the union of people, process, and products to enable continuous delivery of value to our end users.” The definition doesn’t mention any frameworks or specific tools, and it’s more about communi …
SQL SERVER – Performance and Recompiling Query – Summary
Today is the first day of the year 2020 and I would like to share an interesting conversation that I have been having with many of the readers after reading the latest blog post series on Performance and Recompiling Query.Before continuing this blog po …
My 11 Favorite 2019 Blog Posts
Yesterday, I showed the stuff you read the most, but enough data – now, let’s talk about feelings. These were the 11 posts I remember with the most fondness, in date order. I did indeed like some of the ones from yesterday’s list a lo …
SQL SERVER – Parameter Sniffing and OPTION (RECOMPILE)
Today is the last blog post of the year 2019 and this is also a final blog post in the series of Parameter Sniffing which I have been writing. I strongly recommend that you read my earlier blog posts on this topic before you consider the option of reco …
SQL Server Create Database Examples
The post SQL Server Create Database Examples appeared first on SQLServerCentral.