PowerShell editors and environments part 2
In this article, Greg Moore demonstrates two additional PowerShell editors: Azure Data Studio Notebooks and Visual Studio Code.
2021-04-07
Additional Articles
3 steps to get started with Database DevOps
Once you’ve committed to changing your culture in order to automate your database deployments, what’s next? You’ve already done the hard part, making the decision to shift the culture. In this blogpost, Grant Fritchey explores three steps you can take next to begin your Database DevOps journey.
2021-04-06
Where I See Databases Going in the Next 10 Years
This month, to mark the 20th anniversary of BrentOzar.com, Brent steps back and looks at the big picture.
2021-04-06
Cherry-picking Migrations using Flyway
Describing the two main use cases for occasional "cherry picking" of Flyway database migration scripts: back-filling emergency production hotfixes to version control and managing parallel development streams.
2021-04-05
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
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
Blogs
Accelerating AI with Confidence: Why Microsoft Purview is Key to Responsible Innovation
By Chris Yates
Artificial intelligence is no longer a distant concept. It is here, embedded in the...
The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5
Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...
A Prompt AI Experiment
By Steve Jones
Prompt AI released recently and I decided to try a few things with the...
Forums
statistics callection intervel in query store ?
Statistics Collection Interval: Defines the level of granularity for the collected runtime statistic, expressed...
Rounding Off issue in SQL Server
I am using Microsoft SQL Server 2022 (RTM-CU17) (KB5048038) - 16.0.4175.1 (X64) Microsoft Corporation...
how to get notification that my database has corssed 8gb
i have sqlexpress on rds, is there any way i can get notifacation that...
Question of the Day
SQL Server, Heaps and Fragmentation
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers