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 […]
Sites anglophones
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 […]
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.
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 […]
[Video] Office Hours Speed Round: 21 Answers in 15 Minutes
HONK HONK! It’s time for a fast round of answers to concise questions y’all posted and upvoted at […]
Office Hours Speed Round, Easy Text Answers Edition
Some of the questions y’all post at https://pollgab.com/room/brento have easy one-line answers. Let’s knock ’em out: George: Hi […]
SQL Prompt Safety Net Features for SSMS: SQL History
The post SQL Prompt Safety Net Features for SSMS: SQL History appeared first on SQLServerCentral.
Create an Empty Database Using SQL Server Integration Services
Recently, we were working on a small project. The requirement was to create an empty copy of an […]
Use DDL Triggers to Automatically Keep SQL Server Views in ...
The post Use DDL Triggers to Automatically Keep SQL Server Views in Sync appeared first on SQLServerCentral.
Finding and Tuning Expensive Stored Procedures using SQL Monitor
The post Finding and Tuning Expensive Stored Procedures using SQL Monitor appeared first on SQLServerCentral.
Data Oriented Cloud Security Mechanisms
Introduction Cloud Computing escalates the security risks of an organization. This happens because of the extended trust boundary […]
Three Use Case Examples for SQL Subqueries
The post Three Use Case Examples for SQL Subqueries appeared first on SQLServerCentral.
[Video] Office Hours: Ask Me Anything About Azure SQL DB ...
Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me answer. Here’s what we […]
SQL ConstantCare® Population Report: Spring 2023
Ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for […]
How to secure legacy ASP.NET MVC against Cross-Site(CSRF) Attacks
Cross-Site Request Forgery (CSRF) attacks are widespread, and even some BigTech companies suffer from them. Netflix suffered […]
PASS Data Community Summit registrations are open!
The post PASS Data Community Summit registrations are open! appeared first on SQLServerCentral.
WIT Engagement Survey For Female Speakers
The post WIT Engagement Survey For Female Speakers appeared first on SQLServerCentral.
Announcing Live Office Hours on Wednesdays & Thursdays
It’s time for summer school! I’m doing live streaming on my Twitch channel on Wednesdays & Thursdays this […]
PostgreSQL Schema: Learning PostgreSQL with Grant
An important aspect of building and managing a database is organizing the objects within your database. You […]
A Beginners Guide To MySQL Replication Part 2: Configuring Source ...
A Beginners Guide To MySQL Replication Part 2: Configuring Source and Replica Servers In the first part […]
Enhancing SSIS ETL Tools with SolarWinds Task Factory
The post Enhancing SSIS ETL Tools with SolarWinds Task Factory appeared first on SQLServerCentral.
How to work with ChatGPT in Visual Studio Code
ChatGPT in Visual Studio Code In this article, we will play with a ChatGPT extension for Visual Studio […]
Democratizing Self Service Cloud Analytics and ELT Supporting Modern Cloud ...
The post Democratizing Self Service Cloud Analytics and ELT Supporting Modern Cloud Data Management Approaches appeared first on […]
Performance Tuning with SQLFacts Tools
The need for performance tuning your SQL Server workloads has never been more critical. As workloads are moved […]
What SQL Server People Should Know About Amazon Aurora Serverless
You, dear reader, are most likely a Microsoft SQL Server user – either a DBA or developer. Set […]
[Video] Office Hours: Ask Me Anything at Sea
It was a dark and stormy morning, on the last day of my Panama Canal cruise. Before I […]
The ten habits for highly successful compliant database DevOps
The post The ten habits for highly successful compliant database DevOps appeared first on SQLServerCentral.
PASS Data Community Summit 2023 registrations are open!
The post PASS Data Community Summit 2023 registrations are open! appeared first on SQLServerCentral.
Who’s Hiring in the Microsoft Data Platform Community? April 2023 ...
Is your company hiring for a database position as of April 2023? Do you wanna work with the […]
Modifying MySQL data from within Python
In the previous article in this series, I introduced you to how to access MySQL data from […]
Improving SQL Server Performance and Availability with Accelerated Database Recovery
For many businesses, database performance and availability are crucial elements. A database crash or a lengthy transaction can […]
DAX CASE Statement Functionality with IF, SWITCH and SWITCH True
The post DAX CASE Statement Functionality with IF, SWITCH and SWITCH True appeared first on SQLServerCentral.
Improving the Quality of your Database Monitoring
The post Improving the Quality of your Database Monitoring appeared first on SQLServerCentral.
Snowflake Temporary Tables vs. Transient Tables
The post Snowflake Temporary Tables vs. Transient Tables appeared first on SQLServerCentral.
Shrink Database Log Files One by One
I have about 25-30 client databases on my computer for testing purposes when I support or do new […]
GENERATE_SERIES: My new go-to to build sets
I have come across a lot of use cases for manufacturing rows on the fly, aside from […]
A Beginners Guide to MySQL Replication Part 1
MySQL Replication is a process where data from one MySQL database known as the source (formerly called […]
[Video] Office Hours: Ask Me Anything About SQL Server in ...
Off the coast of Costa Rica, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: […]
Piping, Filtering and Using Flyway Output in PowerShell
The post Piping, Filtering and Using Flyway Output in PowerShell appeared first on SQLServerCentral.
The role of forethought for a computer engineer
If you have ever played a game of chess against someone good, or perhaps against a computer, […]