Query Audit data in Azure SQL Database using Kusto Query Language (KQL)
In this article we look at how you can user the Kusto Query Language (KQL) for querying Azure SQL Database audit data.
2021-04-05
In this article we look at how you can user the Kusto Query Language (KQL) for querying Azure SQL Database audit data.
2021-04-05
During development you need a fast, automated way to build multiple copies of a database on any development or test server, with each database at the right version. This article provides a PowerShell automation script for Flyway that will do the job.
2021-04-02
In this article we explore four simple time series forecasting methods using R: the Mean Method, the Naive Method, the Seasonal Naive method and the Simple Moving Average Method.
2021-04-02
In this article we discuss deploying SQL Server containers / images using Azure Kubernetes Cluster.
2021-04-01
How to send Flyway logging and error output to JSON and consume it in PowerShell to produce ad-hoc database migrations reports, including any errors that occurred, the version of the database, runtimes for each migration script and more.
2021-04-01
In this article, Joe Celko explains interpolation and covers a bit about the history and what we all did before computers.
2021-03-31
You need a fast, general-purpose way to save the results of a query or batch or procedure into any sort of worktable, such as a temporary table or a table variable or table valued parameter. A simple SELECT…INTO isn't versatile enough for these requirements, and the alternative ways to handcraft the list of columns are slow and error prone. Phil Factor shows how to create a 'table-build generator' that will do all this, and save you a lot of time, especially if you use a lot of working tables in your code.
2021-03-30
Learn how to manage and troubleshoot Kerberos authentication for SQL Server using the Kerberos Configuration Manager.
2021-03-30
Learn how to configure and use SQL Server Management Studio to do run the same query against many different SQL Servers and consolidate the results.
2021-03-29
In this brand new course on the Redgate University Grant Fritchey walks you through the many ways in which SQL Prompt can be customized to suit your specific needs.
2021-03-29
By Steve Jones
The other day I got a note from Ben Weissman the other day that...
Knowledge of how your system behaves is vital to better control, maintain, and grow...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
We are most reliable and efficient suppliers/distributor of all kinds of commonly used pain...
I read the upgrade path for standard edition to SQL server 2019, the oldest...