Attaching an SQL Server database without Transaction Log Files through ...
Introduction In SQL Server, the transaction log file is essential for keeping your database reliable and durable. It […]
SQL Server
How to Explain What We Do
One of my favorite uses for AI is to ask it to explain a concept using wildly unusual […]
Announcing the Holiday Sale
Our annual Black Friday sale is over, but we’ve got a simple sale for folks who couldn’t get […]
3 Legit Signs It’s Time for Enterprise Edition
Your app is happily humming along on SQL Server Standard Edition. Things are quiet – too quiet. You’re […]
Reading and Writing Parquet Files in SQL Server
When analytic data is stored directly in SQL Server, a clustered columnstore index is an ideal place […]
How to Develop Custom T-SQL Code Snippets in Azure Data ...
To get started, follow these steps to find and use the default snippets in Azure Data Studio. In […]
Office Hours at the PASS Summit in Seattle
I’m in Seattle this week for the PASS Data Community Summit. Before the pre-conference sessions started, I sat […]
SQL Server Performances – CHAPITRE 3 – Estimateur de Cardinalité, ...
Voici une série d’article comportant 10 chapitres destinés à tout ceux qui veulent obtenir de meilleurs performances avec […]
Enhancing SQL Server Searches with Elasticsearch and Python
As a seasoned SQL developer and tech enthusiast, I often encounter scenarios where traditional SQL Server searches struggle […]
The 2024 Black Friday Sale is Coming Next Month.
Your accounting office Every year during November, we run a big sale all month long. And every year, […]
SQL Server Performances – CHAPITRE 2 – Faut-il paramétrer, régler, ...
Voici une série d’article comportant 10 chapitres destinés à tout ceux qui veulent obtenir de meilleurs performances avec […]
Effective Strategies for Storing and Parsing JSON in SQL Server
Like XML, JSON is an open standard storage format for data, metadata, parameters, or other unstructured or […]
Days of the Week, Bitwise Edition
I recently had to help support synchronization and distribution of workloads between multiple servers. Some of this […]
Thoughts About Stack Overflow’s Annual Developer Survey
Every year, Stack Overflow runs a developer survey about technology, work, community, and more. This year’s results include […]
Index cleanup : Harder than it looks
I’m not the first person to write about cleaning up unused or redundant indexes. You can read […]
Auditing SQL Server – Part 2 – Hardware Audit
This is the second part of my series on auditing SQL Server. In the first part, I […]
SQL Server, gestion de la performance… et la VM dans ...
Voici une série d’article comportant 10 chapitres destinés à tout ceux qui veulent obtenir de meilleurs performances avec […]
Haute disponibilité – SQL Server vs PostGreSQL
La haute disponibilité des données est un facteur fondamental dans l’élaboration d’une architecture de bases de données, notamment […]
It’s a recovery strategy, not a backup strategy
I’ve talked about it before; you shouldn’t have a backup strategy, you should have a recovery strategy. […]
Set up a Windows Server Fail-over Clusters (As a Precursor ...
In this walkthrough, we will be setting up WSFC (Windows Server Failover Cluster) in Windows Server. An WSFC […]
XML Performance Tuning and Added Options
SQL Server provides a variety of ways to tune XML so that it provides consistent performance, consumes […]
Auditing SQL Server – Part 1 – Discovery and Documentation
Inheriting a server, whether as an inexperienced user or an experienced DBA, has many challenges. It’s very […]
Snake draft sorting in SQL Server, part 4
In the previous posts in this series (part 1, part 2, part 3), I described how I […]
Détecter les blocages dans MS SQL Server
Un blocage est un phénomène normal dans tous SGBD Relationnels pour éviter les conflits d’accès en écriture qui, […]
Snake draft sorting in SQL Server, part 3
In part 2 of this series, I showed an example implementation of distributing a long-running workload in […]
Snake draft sorting in SQL Server, part 2
In my previous post, I showed how to borrow a snake draft concept from fantasy football, or […]
Snake draft sorting in SQL Server, part 1
I recently had a restore job where I needed to split the work up into multiple parallel […]
Giving Feedback on Microsoft Data Platform Tools
As a data professional, there is a set of tools that you use on pretty much a […]
Check Azure SQL DB Space Used
A couple of days ago I was doing some cleaning on some Azure SQL DBs and shrinking some […]
SQL Server to PostgreSQL Database Schema Conversion
The post SQL Server to PostgreSQL Database Schema Conversion appeared first on SQLServerCentral.
Friendly Deletes in SQL Server
One of the first things you learn when working with SQL Server, and other transactional based SQL […]
SQL ConstantCare® Population Report: Winter 2023
The short story: SQL Server 2019 continues its utter domination of the Microsoft data platform landscape this quarter. […]
Machine learning K-Means applied to SQL Server data
Introduction In this article, we will use K-Means applied to SQL Server using Python. We will learn what […]
SQL Window Functions Series: NTILE()
Continuing our journey through SQL’s handy window functions, we now tackle the NTILE() function. After exploring LAG(), LEAD(), […]
Creating a Hyperscale Database in Azure Using the Azure Portal
Data is the lifeblood of contemporary enterprises in the digital age. Managing and growing databases to fulfill these […]
SQL Window Functions Series: LAG() and LEAD()
In the realm of data analysis, being able to understand the relationships between sequential data points is paramount. […]
SQL Server: Optimize for Ad Hoc Workloads – use or ...
I used to believe this option was something almost absolute: it should be enabled as best practice. […]
Ensuring a Single Row Table
Single row tables in data modeling Single row tables are a fact of our life as as a […]
The Real Problem with SQL Server’s Licensing Costs
At least once a month, a client has The Postgres Conversation™ with me. It happens at the end […]
Office Hours: “Read This” Edition
Sometimes when people post questions at https://pollgab.com/room/brento, the answer is just a link, nothing more, nothing less. It […]
SQL Server and Python Tutorial
Introduction In this article, we will see how to connect SQL Server with Python using the pyodbc library. […]
Batch Execution Mode on a Rowstore in SQL Server 2022
Batch execution mode is a new optimization feature in SQL Server. In this article, we’ll explore how batch […]
Profiler and Server Side Traces
The post Profiler and Server Side Traces appeared first on SQLServerCentral.
12 Office Hours Questions I Don’t Have Answers For
Hey, you! You look smart. Here are highly-upvoted questions that fellow readers submitted at https://pollgab.com/room/brento that I don’t […]
SQL Server Execution Plan Issues when using TOP Clause and ...
The post SQL Server Execution Plan Issues when using TOP Clause and Various Parameters appeared first on SQLServerCentral.
Generate Test Data Sets for Testing SQL Server Database Applications
The post Generate Test Data Sets for Testing SQL Server Database Applications appeared first on SQLServerCentral.
How to export data to SQL Server using Bard (Google ...
The article will explain how to export data to SQL Server with Bard can be challenging. Previously, we […]
Different Ways to Format Currency Output in SQL
The post Different Ways to Format Currency Output in SQL appeared first on SQLServerCentral.
Working with SQL Server Stored Procedures and .NET
The post Working with SQL Server Stored Procedures and .NET appeared first on SQLServerCentral.