
Free Webcast Tomorrow: Fundamentals of Query Tuning
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free […]
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free […]
The second I wrote down the idea for a blog posts on Distractions, I knew there had […]
Because it’s important to know when adversaries are scanning the network searching for vulnerabilities, misconfigurations, unpatched systems or […]
There comes a time when the built-in ORM just isn’t enough. You might have complex queries or performance-critical […]
The post Data Streaming Databricks in Azure appeared first on SQLServerCentral.
As we approach the first public releases of SQL Server 2025, it’s fun to start spelunking through things […]
You’ve attended some of my free online streams, read my blog posts, and you use the First Responder […]
Overview Amazon RDS allows users to create multiple databases within a single database instance. And connections to each […]
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free […]
Deploying a DACPAC to an Azure SQL Database is a critical step in ensuring your database changes are […]
The post INFO.VIEW DAX Functions Usage and Examples appeared first on SQLServerCentral.
The post The State of the Database Landscape in 2025: Insights and trends appeared first on SQLServerCentral.
if you’re going to work with databases, you probably ought to know something about data. In particular, […]
Introduction AdventureWorks is a sample database from Microsoft that simulates a company called Adventure Works Cycles. It is […]
I’m in Iceland this week, land of fire and ice, a place I keep coming back to over […]
The holidays truly are over, and it is time to hit the road again here at Simple […]
I wrote about lakehouse maintenance before, about multiple lakehouse maintenances, published videos about this subject and provided […]
Starting next Tuesday, I’m doing absolutely free 90-minute live training webcasts to help y’all get your learn on: […]
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Introduction In SQL Server 2022, developers often need to implement conditional logic within their queries. Whether it’s selecting […]
The post The Power of Generate_series appeared first on SQLServerCentral.
As a data engineer who’s spent the last few years implementing enterprise-scale security in Snowflake, I’ve witnessed […]
Is your company hiring for a database position as of March 2025? Do you wanna work with the […]
Geographic information systems (GIS) play a critical role in emergency response planning and risk assessment. One of the […]
Introduction AdventureWorks is a sample database from Microsoft that simulates a company called Adventure Works Cycles. It is […]
The post SQL Server Backup or Restore using Network Share with SSMS appeared first on SQLServerCentral.
This is part of a series of posts from Chisom Kanu about using MySQL Shell in the […]
When you think ‘beach chair’, this probably isn’t what you think. I’m at a black sand beach on […]
Over the last several years, Microsoft has been putting less and less effort into Cumulative Update documentation. We […]
Did you know that Edgar F. Codd is considered the father of the relational model that is used […]
The post Engineering a Lakehouse with Azure Databricks with Spark Dataframes appeared first on SQLServerCentral.
You’re looking at a wide table with 100-200 columns. Years ago, it started as a “normal” table with […]
The digital landscape is rapidly evolving, and the question has progressed from whether to adopt cloud technology […]
The other day, my lovable coworker and frequent Simple Talk writer: Grant Fritchey, sent this post on […]
Introduction Sometimes, we need to test our apps in Azure and we do not have time to connect […]
The post Upgrade and Migrate SSIS Catalog and SSISDB to a New Server appeared first on SQLServerCentral.
In this article, we are going to configure a maintenance place on the SQL Server 2017 instance installed […]
Meet my latest toy, a 1991 Honda Beat! I introduce it, then take your top-voted questions from https://pollgab.com/room/brento. […]
Fabric Database was a great announcement during Ignite Conference. The announcement spread all around, a great new […]
I certainly don’t discuss it often, and it’s been a few years since I wrote about my pansexuality. […]
The post Index Rebuilds Make Even Less Sense with ADR & RCSI appeared first on SQLServerCentral.
Introduction In this article, we will learn how to restore a database which is stuck in the Recovery […]
Starting next month, I’m doing absolutely free 90-minute live training webcasts to help y’all get your learn on: […]
One of the cornerstones of AI is a concept called embeddings. Virtually every AI model, whether for […]
I’ve been working in the Azure space for the last few years and less with full server […]
Introduction SQL Server 2022 introduces powerful bit manipulation functions that allow for efficient handling of binary data. These […]
The post Find Text in Stored Procedure, Function, View, or Trigger appeared first on SQLServerCentral.
The post Fun with PowerShell Asynchronous appeared first on SQLServerCentral.
Overview Searching for relevant information in vast repositories of unstructured text can be a challenge. This article demonstrates […]
Most anyone who works with indexes should be familiar with B-tree indexes. These are the most commonly […]