Synapse Serverless and Dedicated Pool: The differences no one told you about
The basic differences between Synapse Serverless and the Dedicated pool are obvious: While the serverless doesn’t store data, only access data from storage accounts and scale the MPP environment automatically, the dedicate SQL Pool keeps a static …
Optional Code in T-SQL Scripts using SQLCMD
When you are writing T-SQL scripts to save away, for example one to create a new database, there are often optional bits of code you need to run sometimes, and not others. In the creating a database script, there are quite a few parameters you will wan …
It’s Monday. Get Back to Learning PowerShell.
You’re a production database administrator responsible for the health, security, and uptime of many database servers. You’ve been pointing and clicking your way through SSMS for years, scripting out T-SQL to files, but… when you need …
Snowflake for SQL Server Developers – NULL Functions – Part 2
The post Snowflake for SQL Server Developers – NULL Functions – Part 2 appeared first on SQLServerCentral.
ChatGPT in SQL Server – Practical examples
Introduction ChatGPT in SQL Server In this article, we will learn some basic examples of ChatGPT in SQL Server. In a previous article, we had an interview with ChatGPT an AI chatbot developed by OpenAI. If you do not know how to use it yet, you can go …
Understanding Azure Synapse Analytics Pricing
Introduction Azure Synapse Analytics combines data integration, enterprise data warehousing, and data analytics. It is a cloud-based limitless data integration and analytics platform. It provides a cloud platform to create data pipelines from various s …
How to Improve the Quality of Database Releases using Clones
The post How to Improve the Quality of Database Releases using Clones appeared first on SQLServerCentral.
Creating Animated Line Plots with Python
The post Creating Animated Line Plots with Python appeared first on SQLServerCentral.
Retrieving MySQL data from within Python
Applications of all types commonly access MySQL to retrieve, add, update, or delete data. The applications might be written in Python, Java, C#, or another programming language. Most languages support multiple methods for working with a MySQL database …
I’m Coming to Gothenburg and Oslo This Fall!
Back in 2020 before the wheels came off the world, I’d scheduled visits to Gothenburg and Oslo for their annual SQL Server events. Now that things are back to normal, it’s back on! Data Saturday Gothenburg, Aug 26 & 28, 2023 – Mon …
Learn PowerShell in 30 Minutes a Day, Free, Starting Now.
The clock starts now! You’re a production database administrator responsible for the health, security, and uptime of many database servers. You’ve been pointing and clicking your way through SSMS for years, scripting out T-SQL to files, but …
Testing before coding: shifting farther left
The post Testing before coding: shifting farther left appeared first on SQLServerCentral.
Getting Out of Character
Pre-Unicode Younger programmers have grown up with ASCII and Unicode as the only ways of representing character data in a computer. But in the dark ages, before we invented dirt and entered into the stone age, there were other contenders. The Control D …
Can You Nest Transactions in SQL Server?
To find out, let’s set up a simple status log table:DROP TABLE IF EXISTS dbo.StatusLog; CREATE TABLE dbo.StatusLog (TimeItHappened DATETIME2 PRIMARY KEY CLUSTERED, Step VARCHAR(20)); GO And then let’s try a two-part transaction:BEGIN TRAN I …
Event exceeds the number of allowable bound actions
Did you know that there is a limit to the number of actions you can add to a single event in Extended Events? While I was playing around with Trace Flag 9708 for my previous blog post, one of the things I wanted to try to see was whether it would be ea …