Cheat Sheet for SQL Server DBA Daily Operations
The post Cheat Sheet for SQL Server DBA Daily Operations appeared first on SQLServerCentral.
Sites anglophones
PostgreSQL Table Import/Export from and to CSV File
Overview In this article, we will cover a very important technique of working with a PostgreSQL table. Let […]
Importing data into a MySQL database using LOAD DATA
Database and development teams often load data from plain text files into their MySQL databases. The files […]
[Video] Office Hours: 25 Pretty Good Questions
You post questions at https://pollgab.com/room/brento and upvote the ones you’d like to see, and my job is to […]
Classing Up SSMS is as Easy as 1, 2, 3.
Step 1: go into Tools, Options and set this: Step 2, set this: Step 3, check this box: […]
Create an HTML Report on the Status of SQL Server ...
SQL Server jobs are an integral part of any SQL Server environment. These jobs run a predefined set […]
Happy 21st Anniversary, BrentOzar.com. What’s Coming Next?
It’s pretty cool to look at a blog post and see, “Last updated: 21 years ago.” It’s pretty […]
PostgreSQL Basics: Essential psql Tips and Tricks
Having access to the psql command-line tool is essential for any developers or DBAs that are actively […]
ChatGPT in Visual Studio tutorial
Introduction In this article, we will learn how to work with ChatGPT in Visual Studio. We will install […]
How to Slice Data by Week in a Calendar Table ...
The post How to Slice Data by Week in a Calendar Table using DAX appeared first on SQLServerCentral.
Working with Flyway And Entity Framework Code First: An Overview
The post Working with Flyway And Entity Framework Code First: An Overview appeared first on SQLServerCentral.
How to Automate Cross-Platform Database Development
The post How to Automate Cross-Platform Database Development appeared first on SQLServerCentral.
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 […]
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 […]
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 […]