Complex Production Database Deployments and Flyway
The post Complex Production Database Deployments and Flyway appeared first on SQLServerCentral.
Archives de l’année : 2023
AWS Lambdas with C#
The post AWS Lambdas with C# appeared first on SQLServerCentral.
Why a monitoring tool is an essential tool for growing ...
When I was a DBA involved with the management of a large number of database servers, I […]
Microsoft Drivers 5.11 for PHP for SQL Server Released
We have released Microsoft Drivers for PHP for SQL Server, version 5.11.0. This production release of the SQLSRV […]
I’m Coming to Boston for SQLSaturday!
I’m coming back to Boston for SQLSaturday this October 14th! On Friday the 13th (muhaha), before the event, […]
Synapse Serverless and Dedicated Pool: The differences no one told ...
The basic differences between Synapse Serverless and the Dedicated pool are obvious: While the serverless doesn’t store […]
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, […]
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 […]
ChatGPT in SQL Server – Practical examples
Introduction ChatGPT in SQL Server In this article, we will learn some basic examples of ChatGPT in SQL […]
Snowflake for SQL Server Developers – NULL Functions – Part ...
The post Snowflake for SQL Server Developers – NULL Functions – Part 2 appeared first on SQLServerCentral.
Understanding Azure Synapse Analytics Pricing
Introduction Azure Synapse Analytics combines data integration, enterprise data warehousing, and data analytics. It is a cloud-based limitless […]
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 […]
Les index filtrés
Depuis SQL Server 2008, il est possible de créer des index filtrés : des index nonclustered avec un […]
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 […]
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 […]
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 […]
Getting Started with Azure SQL Bindings: Part 1
Expanding on the excellent post by Drew Skwiers-Koballa; Developing with Azure SQL bindings and Azure SQL trigger for […]
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 […]
Top 25 SQL Server Engine Errors Based on support case ...
About 6 months ago we decided to look at what SQL Server engine error messages are most commonly […]
SQL Server 2022 : Database Ledger
Database ledger : découvrez cette nouvelle fonctionnalité de sécurité de SQL Server 2022. Basée sur la technologie de […]