How to Automate Cross-Platform Database Development
The post How to Automate Cross-Platform Database Development appeared first on SQLServerCentral.
Archives du mois : avril 2023
Using the New Open Source SQLCMD to Create Containers
In my previous article, I looked at the basics of the new, open-source SQLCMD, which is a new […]
Updated First Responder Kit and Consultant Toolkit for April 2023
This month’s big changes are performance tuning in sp_BlitzFirst & sp_BlitzLock. Part of the benefits of using the […]
Capitalize on your investments with the new centrally managed Azure ...
Introducing the new centrally managed Azure Hybrid Benefit for SQL Server. Today, Microsoft is pleased to announce the […]
How to Go Live on SQL Server 2022
You’re planning to migrate to SQL Server 2022, and you want your databases to be faster after the […]
PASS Data Community Summit registration is open!
The post PASS Data Community Summit registration is open! appeared first on SQLServerCentral.
Revolutionizing Real-Time Data Management with SQL Server, Kafka, and Informatica
The field of data engineering involves handling vast amounts of data through processing, transformation, and storage to enable […]
[Video] Office Hours: Live Q&A
This one’s broken up into two parts because I took a bio break mid-stream: 00:00 Start 03:04 Clippy: […]
PostgreSQL Basics: Getting started with psql
PostgreSQL has a separate command-line tool that’s been available for decades and is included with any installation […]
Using Ledger in Azure SQL Database
Transactions have to be protected and you need to know when something is altered or prevent altering […]
Creating a Standalone Executable Python Application
The post Creating a Standalone Executable Python Application appeared first on SQLServerCentral.
A Brief Introduction to PowerShellAI, an Intelligent Command-line
The rising popularity of ChatGPT has led to the development of a PowerShell module called PowerShellAI, which allows […]
Automatically Tracking and Deploying Static Data in Flyway Enterprise
The post Automatically Tracking and Deploying Static Data in Flyway Enterprise appeared first on SQLServerCentral.
What is causing the Always On AG issue? Is it ...
Do any of these questions sound familiar? – My AG fails to failover – Why did my […]
Experimenting with Go-SQLCMD
At a few different conferences in early 2023, I’ve heard Microsoft employees talking about the version of sqlcmd, […]
SQL Prompt Safety Net Features for SSMS: Tab Coloring
The post SQL Prompt Safety Net Features for SSMS: Tab Coloring appeared first on SQLServerCentral.
Extract SharePoint List Data and save to SharePoint Folder as ...
The post Extract SharePoint List Data and save to SharePoint Folder as CSV using Power Automate appeared first […]
One use case for NOT using schema prefixes
I’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server. […]
What Does Setting the SQL Server Compatibility Level Do?
If you right-click on a database in SQL Server Management Studio, you get an option to set Compatibility […]