Leveraging AI Tools for SQL Queries
This article covers the basics of how different AI tools can be used to write SQL.
Use a Table Variable for Logging Entries that Need to Survive Rollbacks.
This article shows how a table variable can be used to capture error information and log it when your code doesn't work as expected.
Fun with Powershell
Have you ever been in a situation that you want to call a cmdlet or a function with a parameter that depends on a conditional criteria that is available as a list? In this article I will show a technique where you can use PowerShell Dynamic Parameters to assist the user with parameter values.
LangChain Prompt Templates with OpenAI LLMs
Learn how to get started with a few sample prompt templates by using the gpt-4 LLM within OpenAI and LangChain in a Databricks notebook.
Dimensional Modeling Case Study Part 2 - Days Dimension
Learn how you can model days in a dimension that might need to be aggregated in different ways for your data warehouse operations.
Ransomware vs. AI
Microsoft is using AI to try and protect against ransomware, which is probably a good use of the technology.
Query Exercise: Find the Best Time for Maintenance
If we’ve gotta take the database down for maintenance – perhaps a version upgrade, perhaps upgrading our own code, maybe scaling up the hardware – when’s the best time to do it?
Announcing the first Microsoft Fabric Community Conference!
Read a message from Bob Ward about the first Microsoft Fabric conference taking place in Las Vegas this March.
Fixing the Synapse Error "Available workspace capacity exceeded error (Livy session)"
This article will help you to resolve the Livy session error in an Azure Synapse notebook.
Serious Software Glitches
A software bug causes a lot of legal issues in the UK. It's something that upsets Steve, partially because the software wasn't well tested.
Blogs
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Counting Groups with Window Functions: #SQLNewBlogger
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
The query processor ran out of internal resources and could not produce a query plan – When You’ve Managed to Confuse SQL With a Crazy IN Clause.
Recently I received a cry for help over Teams. The issue was that an...
Forums
Temporary Table Problem
Hello everyone, I hope you can help me. I have a table with measurement...
A Few Good DBAs
You can't handle the truth!! (about data integrity) A few good database administrators https://www.helpmasterpro.com/blog/a-few-good-database-administrators/...
Python with SQL 2022 Enterprise doesn’t work
I have installed Machine Learning with SQL 2022 Enterprise Edition and installed and configured...
Question of the Day
Incremental Statistics
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers