What’s New in SQL Server 2019 CTP 2.1: Faster Functions
A while back, we talked you through a public whitepaper about how Microsoft was working on making user-defined functions go faster. Now that the next preview (CTP2.1) of SQL Server 2019 is out, you can start getting your hands on Froid, the performance …
Simple way to Import XML Data into SQL Server with T-SQL
In this tip we look at a simple way to import a simple XML document into a SQL Server table. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the r …
SQL SERVER – Cluster Resource ‘AGName’ of type ‘SQL Server Availability Group’ in Clustered Role ‘AGName’ Failed
I never leave my customers alone when they are having an issue with something which I helped them. Typically, I help customers in creating POC and deploying AlwaysOn Availability Groups. Just the other day while doing the Comprehensive Database Pe …
Query Store Performance Overhead: What you need to know
“What is the performance overhead of enabling Query Store?”I get asked this question almost every time I present on a topic related to Query Store. What people are really asking is “Does enabling Query Store affect the performan …
Caution about Restoring via SSMS v17
A default value has changed in the SSMS v7 restore wizard, and the consequences can be severe.
SQL Clone V3: New features heighten visibility and manageability of clones and images.
With a brand new dashboard, activity feed and search functionality there is a lot happening in the SQL Clone v3 release. Check out the full breakdown of the update and get onto the latest version.
How Big is Your Transaction Log?
If you are not managing the transaction log space used by a database, the transaction log might grow uncontrollably. With SQL Server 2017 there is a new dynamic management function (DMF) that exposes statistical information about a database transaction …
SQL SERVER – Script level upgrade for database ‘master’ failed because upgrade step msdb110_upgrade.sql encountered error 926, state 1, severity 25
I have helped many clients in upgrade failures via my On-Demand consulting and I am amazed to see various ways which can break SQL Server upgrade. In this blog we would learn about fixing error Script level upgrade for database ‘master’ fai …
Picking #PASSsummit Sessions to Attend
So you’re going to the PASS Summit in Seattle this week, and you’re overwhelmed with the number of session choices. You’re not alone – it overwhelms me too. There are some slots where I wish I could clone myself and attend sever …
Azure and Windows PowerShell: Using VM Extensions
In the third part of his series, Nicolas Prigent describes how to run post-deployment configuration and automation tasks on Azure Virtual Machines. Nicolas explains how to use Azure VM Extensions using the Azure PowerShell module to save time during th …
Import flat files to SQL Server on Linux using Azure Data Studio
Have you ever wonder how to import flat files to SQL Server on Linux? In this article, I will share my experience loading data to a Linux SQL Server instance using the new Azure Data Studio data import extension from macOS.
SQL Prompt as a Layout Tool: A Survival Guide
Phil Factor’s guide to taming SQL Prompt layout options, and getting it to format code just the way you like it.
Getting Started with MariaDB – New Course on Pluralsight
As a database professional, one should know multiple database platforms as in the real world we can’t say no to our clients when they show up a system which is running slow and involves multiple database platforms. During the Comprehensive Databa …
How to Find Size of the Index for Tables? – Interview Question of the Week #198
Question: How to Find Size of the Index for Tables? Answer: Earlier this week, during the Comprehensive Database Performance Health Check, I was asked this question by my client. Let us see the script which will give us details related to Schema, …
SQL Server Diagnostic Information Queries for November 2018
This month, I have just made some more minor improvements to most of the query sets. I have a T-SQL script that you can use to check whether your instance of SQL Server has been patched to mitigate against the Spectre/Meltdown CPU vulnerability. This w …