Azure SQL Best Practices?
A way to enforce good practice and standards is by Azure Policy. As stated by Microsoft “Azure Policy is a service in Azure that you use to create, assign,...
2019-11-12
60 reads
Blog Posts
First Time Speaking at PASS Summit
Watch this week's video on YouTube
This week, I filmed my experience as a first time speaker at PASS Summit in Seattle. No blog post, just a video to relive...
2019-11-12
8 reads
First Time Speaking at PASS Summit
Watch this week's video on YouTube
This week, I filmed my experience as a first time speaker at PASS Summit in Seattle. No blog post, just a video to relive...
2019-11-12
6 reads
First Time Speaking at PASS Summit
This week, I filmed my experience as a first time speaker at PASS Summit in Seattle. No blog post, just a video to relive the experience.
2019-11-12
20 reads
PowerShell Notebooks are Available in Azure Data Studio
PowerShell Notebooks are now available in the November release of Azure Data Studio. Back in March I requested this feature be added to Azure Data Studio and it has...
2019-11-12 (first published: 2019-11-05)
1,255 reads
TDE in Standard Edition on SQL 2019
Recently Microsoft quietly let us know that TDE (Transparent Data Encryption) will be available in the Standard Edition of SQL Server 2019. If you don’t follow SQL topics on...
2019-11-12 (first published: 2019-11-05)
7,138 reads
AG without WSFC SQL 2017 and more…
Starting Sql Server 2017 Microsoft can allow you to enable the configuration manager for “Always ON” feature for standalone system without WSFC and linux without Pacemaker . it has...
2019-11-11
49 reads
Availability Groups: What to do without MultiSubNetFailover = True
I received an email from a client who is having issues with third-party applications connecting to their three-subnet SQL Server Availability Group. After an exchange with Microsoft Support, they...
2019-11-11 (first published: 2019-10-31)
1,249 reads
Build a SQL Cluster Lab Part 3
You are going to create a multi-subnet Availability Group in Part 3 of our series on how to build a SQL Cluster Lab. First you give the Cluster Name...
2019-11-11
26 reads
Build a SQL Cluster Lab Part 3
You are going to create a multi-subnet Availability Group in Part 3 of our series on how to build a SQL Cluster Lab. First you […]
The post Build a...
2019-11-11
19 reads
Blogs
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers