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
Additional Articles
Automating Migrations for Multiple Databases using Flyway
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
Exploring Four Simple Time Series Forecasting Methods with R Examples
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
Considerations for Running SQL Server on Kubernetes
In this article we discuss deploying SQL Server containers / images using Azure Kubernetes Cluster.
2021-04-01
Using Flyway Output in PowerShell
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
What is interpolation?
In this article, Joe Celko explains interpolation and covers a bit about the history and what we all did before computers.
2021-03-31
Building reusable table build scripts using SQL Prompt
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
Using Kerberos Configuration Manager for SPNs Validation
Learn how to manage and troubleshoot Kerberos authentication for SQL Server using the Kerberos Configuration Manager.
2021-03-30
Combine Multiple SQL Server Query Results with Registered Servers
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
Customizations in SQL Prompt
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
Blogs
The Diverse Data Platform–Dativerse.io
By Steve Jones
The other day I got a note from Ben Weissman the other day that...
Extended Events and Azure SQL Database
Knowledge of how your system behaves is vital to better control, maintain, and grow...
Daily Coping 19 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Buy oxycontin 80m,xanax,Oxycodone,Ritalin,Diazepam etc WhatsApp:+1(312) 379-9621
We are most reliable and efficient suppliers/distributor of all kinds of commonly used pain...
upgrade path to SQL 2019
I read the upgrade path for standard edition to SQL server 2019, the oldest...
Ask SSC