Schedule Azure SQL DB Processes using Azure Functions
Learn how to schedule processes in Azure SQL Database using an Azure Function in this easy to follow step by step tutorial.
2021-08-30
Additional Articles
Executing a TSQL batch multiple times using GO
Learn how to execute the same batch of SQL Server commands X number of times using the GO command.
2021-08-27
Flyway with SQLite for Those of a Nervous Disposition
Get started with running Flyway migrations on SQLite databases, using PowerShell.
2021-08-27
Azure Data Factory Incremental Pipeline from Azure SQL Database to Databricks
In this tip find out how to use Azure Data factory to build an incremental pipeline from Azure SQL Database to Databricks.
2021-08-25
Getting Started with Flyway Migrations on PostgreSQL
Phil Factor brings us yet another lesson in Flyway and database migrations. Learn how to use PowerShell with Flyway to run SQL migration scripts that will build, fill and modify a PostgreSQL database.
2021-08-23
Issues with SQL Server Permissions to Restore a Database
In this article we look at solving SQL Server database restore issue when backup file does not show up in SSMS restore GUI as well as other permissions issues with backup and restore.
2021-08-23
SQL Compilations/sec is not what you think it is
SQL Server perfmon counters provide a wealth of information about performance. In this article, Fabiano Amorim shows how current wisdom about one counter, SQL Compilations/sec, can sometimes be misleading.
2021-08-20
Testing SQL Server Databases Using SQL Test
During database development, as well as writing SQL, you must also write the tests that prove your SQL code meets all the requirements. The article will help you get started with database testing for your SQL Server databases, by creating and running unit tests against them, as well as static code analysis tests.
2021-08-20
Improving performance with instant file initialization
Instant file initialization can speed up database creation, file growth, and restores. Greg Larsen explains how to configure it and how it works.
2021-08-18
Microsoft at PASS Data Community Summit 2021
We're thrilled to welcome Microsoft as the Premier Sponsor at this year's PASS Data Community Summit. The Microsoft team will be a fundamental part of the conference program and activities through educational sessions, product deep-dives and announcements, Microsoft-focused workshops, keynotes, and more. We're excited to continue this relationship in support of the global data community.
2021-08-18
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Why End-User Testing Is Even More Important with AI
Comments posted to this topic are about the item Why End-User Testing Is Even...
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers