Who’s Hiring in the Microsoft Data Platform Community? May/June 2023 ...
Is your company hiring for a database position as of May/June 2023? Do you wanna work with the […]
Sites anglophones
Microsoft Fabric: Enabling your Free Trial
After the great announcement of Microsoft Fabric this week, it’s time to get a trial and start […]
Microsoft Fabric: Data Warehouse Ingestion using T-SQL and more
.In this blog I will illustrate how we can ingest data from a blog storage to a […]
Data Intelligence on light speed: Microsoft Fabric
This article is based on exciting information just released at Microsoft’s Build conference on May 23, 2023. […]
Using Azure Data Studio to Deploy a SQL Server VM ...
Introduction Sometimes we need to deploy many SQL Servers on Azure in the enterprise environment. Wwe can do […]
Self Review: Practical Graph Structures in SQL Server and Azure ...
I just finished writing this book a few weeks ago, and as I read it, I thought […]
Microsoft Build 2023 Keynote Live Blog: Introducing Fabric
Goooood morning, party people! Today is the opening day of the annual Microsoft Build conference, an event focused […]
[Video] Office Hours: Azure & SQL Server Q&A
Y’all post questions at https://pollgab.com/room/brento, and I go through the top-voted ones on my Twitch channel streams. […]
Optimizing MySQL: Adding Data to Tables
Welcome back to the MySQL optimization series! In case you haven’t been following this series, in the […]
How to Generate Images with AI and Store them in ...
Introduction In this article, we will learn how to generate images with AI. This time we will work […]
PostgreSQL 101: The 10 key differences between SQL Server & ...
The post PostgreSQL 101: The 10 key differences between SQL Server & PostgreSQL appeared first on SQLServerCentral.
Cache SQL Server Data in a .NET Web Application
The post Cache SQL Server Data in a .NET Web Application appeared first on SQLServerCentral.
Common Table Expression Basics
Introduction Firstly, we need to understand what is a common table expression. Common table expressions, also abbreviated as […]
The Journey to Team-based Development with Flyway
The post The Journey to Team-based Development with Flyway appeared first on SQLServerCentral.
REPLACE versus TRANSLATE for SQL Server Text Data Manipulation
The post REPLACE versus TRANSLATE for SQL Server Text Data Manipulation appeared first on SQLServerCentral.
PostgreSQL Basics: A Template for Managing Database Privileges
In the first two articles of this series about PostgreSQL privileges, we reviewed how to create roles, […]
[Video] Office Hours: Professional Development & Training Questions
A lot of today’s questions from https://pollgab.com/room/brento have a common theme, but it’s just a coincidence: Here’s what […]
[Video] Office Hours: 45 Minutes of SQL Server Q&A
It’s a long one, folks! I went through almost 30 of your questions from https://pollgab.com/room/brento to get your […]
Demystifying Best Practices and Enhancing RDS security with Amazon GuardDuty
Introduction In today’s rapidly evolving digital landscape, organizations increasingly rely on cloud platforms like Amazon Web Services (AWS) […]
It’s Been 6 Months. SQL Server 2022 Still Isn’t Ready ...
Six months ago today, Microsoft announced that SQL Server 2022 was ready. Except it wasn’t. And it still […]
Changing log growth strategy in SQL Server 2022
When I first saw a bullet item stating SQL Server 2022 would support instant file initialization for […]
7 ways businesses can improve the quality and speed of ...
The post 7 ways businesses can improve the quality and speed of database releases appeared first on SQLServerCentral.
How to Improve Database Design to Speed Up SQL Queries
Mistakes in database design can spell long-term issues that jeopardize efficiency and effectiveness. For online transaction processing (OLTP), […]
Star Schema vs Snowflake Schema Considerations
The post Star Schema vs Snowflake Schema Considerations appeared first on SQLServerCentral.
Understanding how to Successfully Sell the Cloud
The post Understanding how to Successfully Sell the Cloud appeared first on SQLServerCentral.
How to Find the SQL Server Instance Startup Time
This article explains the different methods to find the startup time of an SQL Server. We can use […]
Uncovering the mysteries of PostgreSQL (auto) vacuum
Welcome to the second blog of the “magic of parameters” series. In the first entry, I covered […]
Database Branching and Merging without the Tears
The post Database Branching and Merging without the Tears appeared first on SQLServerCentral.
How to Configure Ola Hallengren’s Database Maintenance Scripts for Backups
Someone told you that you should be using Ola Hallengren’s Maintenance Scripts. You’ve downloaded his Maintenance Solution.sql, you […]
[Video] Office Hours: Testing the First Responder Kit
I tested the April release of the FRK, then answered your questions from https://pollgab.com/room/brento. Here’s what we […]
How to Create a SQL Database on a New Drive ...
This article explains different methods to move a SQL database into a new directory of Ubuntu Linux. This […]
Free Webcast Next Week! What’s New (and Actually Good) in ...
It’s May 2023, and believe it or not, some of the flagship features in Microsoft’s latest version still […]
Add a Second NIC for an Availability Group to Separate ...
Introduction Sometimes we face the scenario in an enterprise environment that the database in SQL Server Always On […]
Redgate opens the doors to cross-database DevOps Test Data Management
The post Redgate opens the doors to cross-database DevOps Test Data Management appeared first on SQLServerCentral.
Benefits and Limitations of SCHEMABINDING Views in SQL Server
The post Benefits and Limitations of SCHEMABINDING Views in SQL Server appeared first on SQLServerCentral.
Finding External References in Database Deployments
The post Finding External References in Database Deployments appeared first on SQLServerCentral.
Cheat Sheet for SQL Server DBA Daily Operations
The post Cheat Sheet for SQL Server DBA Daily Operations appeared first on SQLServerCentral.
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 […]