Writing SQL Server code with AI using GitHub Copilot
Introduction In this article, we will see how to work with GitHub Copilot. GitHub copilot is an interesting plug-in that generates code using AI. The technology is from Microsoft and OpenAI. We will show how to install Copilot, and how to generate SQL …
Planning a Database Testing Strategy for Flyway
The post Planning a Database Testing Strategy for Flyway appeared first on SQLServerCentral.
Automating BCP with PowerShell
I was talking with a good friend that has an environment with terabytes of information and to create a homolog or dev environment to him is a pain. He comes to me with a solution : A PowerShell script that gets only the first 1000 lines of each table, …
[Video] Office Hours: Lumberjack Edition
On a chilly January day, I went through your top-voted questions from https://pollgab.com/room/brento. Yes, it actually gets cold in Vegas! It’s sub-freezing overnight before the sun comes out each day. Here’s what we covered: 00:00 Start 0 …
Fun with Powershell
The post Fun with Powershell appeared first on SQLServerCentral.
Use a Table Variable for Logging Entries that Need to Survive Rollbacks.
Introduction Table variables are special types of local variables that can be used to store data temporarily, similar in many ways to temporary tables in SQL Server but they are intended for a different purpose. Temporary tables are physical tables sto …
LangChain Prompt Templates with OpenAI LLMs
The post LangChain Prompt Templates with OpenAI LLMs appeared first on SQLServerCentral.
Query Exercise: Improving Cardinality Estimation
Your challenge for this week is to tune a query. Say Stack Overflow has a dashboard that shows the top-ranking users in their most popular location. It’s even got an index to support it:CREATE INDEX Location ON dbo.Users(Location); GO CREATE OR A …
Database Changes to Find Tagged Questions Faster: Answers and Discussion
In the last Query Exercise discussion, we hit a performance wall when we were trying to quickly find questions with a specific tag. We threw up our hands and said it’s time to make database changes, but we had a few restrictions: We have a lot of …
Dimensional Modeling Case Study Part 2 – Days Dimension
Introduction In our second case study on dimensional modelling, we delve into the intricacies of managing time-related dimensions, focusing specifically on the « days » dimension. Unlike the date dimension, where each row signifies a specific point in ti …
#TSQL2sday Invitation: Describe the Most Recent Issue You Closed.
T-SQL Tuesday is a monthly blogothon where we get together and write about a different topic. I’m hosting this month’s episode. Your readers wonder what kinds of jobs are out there in the database world, what exactly it is that you do, and …
Resolving the MERGE statement attempted to UPDATE or DELETE the same row more than once error
The post Resolving the MERGE statement attempted to UPDATE or DELETE the same row more than once error appeared first on SQLServerCentral.
Announcing the first Microsoft Fabric Community Conference!
We are excited to welcome attendees to the 1st Microsoft Fabric Community Conference (previously known as the Data & AI Conference). This event will bring together community experts, Microsoft leaders, and engineers and it’s happening soon! Worksho …
Fixing the Synapse Error « Available workspace capacity exceeded error (Livy session) »
If you are working with Notebooks in Azure Synapse Analytics and multiple people are using the same Spark cluster at the same time then chances are high that you have seen any of these below errors: « Livy Session has failed. Session state: error code: …
Deploying Azure SQL Database Using an ARM Template
Provisioning infrastructure in a timely and reliable manner is essential for agile development. One well-liked method that lets you use code to automate resource management and provisioning is infrastructure as code (IaC). Azure Resource Manager templa …