(blobeater) While not specific to SQL Server 2019 (I was using this version to do some testing) I was struggling to find how to change the time period of analysis for the Query Store reports within SSMS.
Tag: sql server
Is That Database in Use?
(Jason Brimhall) Does anybody know who or what is using this database? Better yet, is the database being used by anything at all? Have you ever asked those types of questions of your staff in an environment you have inherited?
Ways to compare and find differences for SQL Server tables and data
(Daniel Calbimonte) Sometimes we need to compare SQL Server tables and/or data to know what was changed. This tip shows you different ways to compare data, datatypes and tables using SQL Server.
Nested window functions in SQL
(Itzik Ben-Gan) The ISO/IEC 9075:2016 standard (SQL:2016) defines a feature called nested window functions.
Top Modern Data Warehouse questions
(James Serra) Below are the top 15 questions I am seeing from customers looking to build a modern data warehouse in the cloud, and the blogs that I have wrote that try to answer each question (I have updated most of these blogs):
SQL SERVER – Add Database to Availability Group Failure – This BACKUP or RESTORE Command is Not Supported on a Database Mirror or Secondary Replica
(Pinal Dave) I always recommend my client to go with the latest and great version of tools like SQL Server Management Studio (SSMS). In this blog, we would learn about a situation where an older version of SSMS was giving an error while adding a new database to existing availability group – This BAC
Learning Powershell with Show-Command
(Kenneth Fisher) Years ago I blogged about how I like to use the SSMS scripting feature to learn how to do things.
sp_execute_external_script and SQL Injection
(Grant Fritchey) In order to take advantage of R and Python (and Java in SQL Server 2019) directly from your SQL Server scripts, you’ll be using the function sp_execute_external_script.
Transfer On-Premises Files to Azure Blob Storage
(Fikrat Azizov) Data integration tasks sometimes require transferring files between on-premises and cloud sources. In this tip I’ll explain how to create an Azure Data Factory pipeline to transfer CSV files between an on-premises machine and Azure Blob Storage.
SQL SERVER – Different Size of COPY_ONLY Full Backup on Primary and Secondary Replica in Always On
(Pinal Dave) While preparing for a disaster recovery demo for my client, I observed an interesting behavior. In this blog, I would show a quick demo where you can learn how the full backup size can be different on the primary and secondary replica for an availability database in Always On availabili