Autonomous Databases?
I was talking to some people today about the concept of Autonomous Databases. The idea is that […]
Archives de l’année : 2023
The Curious Case of… missing 832 errors during memory corruption
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post […]
The Black Friday Sale is Here: Save Big on Training ...
My Annual Black Friday Sale is On! I’m running a giant Black Friday sale on my training courses! […]
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 […]
Getting Started with MongoDB
MongoDB is a scalable database management system that stores data as documents in a collection, rather than […]
It’s Probably Time to Upgrade Your Cloud VMs
The post It’s Probably Time to Upgrade Your Cloud VMs appeared first on SQLServerCentral.
Azure Data Studio – A First Look
Introduction Azure Data Studio is the next iteration in Microsoft’s development of a cross-platform client tool for developing […]
Security in the cloud: Whose responsibility is it?
The post Security in the cloud: Whose responsibility is it? appeared first on SQLServerCentral.
An editor’s biggest headache: Plagiarism
As an editor working with other people’s technical writing for many years, you might guess that either […]
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 […]
Microsoft at PASS Data Community Summit 2023!
t’s gearing up to be an exciting week November 14th – 17th as we prepare for this […]
Is your organization using MongoDB? Help the Redgate Flyway team ...
The post Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points appeared first […]
The PASS Data Community Summit First Timer Guide
Edwin Sarmiento has been producing a first-timer’s guide for the PASS Data Community Summit since 2016. He has […]
Time-Series Data Analysis with Apache Druid
In the era of data-driven decision-making, the ability to efficiently analyze and derive insights from time-series data is […]
[Video] Office Hours: Having a Bad Day Edition
The first day back after a long vacation is always rough, and today’s no exception. I took your […]
The NTILE Function
The SQL NTILE() is a window function that allows you to break a table into a specified […]
Fabric Data Warehouse News you need to know
Microsoft Fabric, including the Data Warehouse, evolves faster than we can analyze and write about it. Here […]
Azure Data Studio 1.47 is now available
Just in time for Microsoft Ignite and the PASS Data Community Summit, version 1.47.0 of Azure Data Studio […]
[Video] Office Hours: Yes, I’m In the Same Shirt
Why yes, I’m wearing the same shirt as the video from “yesterday”. Why do you ask? Stop paying […]
Timescale Launches Dynamic PostgreSQL, the Cost-Effective Alternative to Serverless and ...
NEW YORK – November 6, 2023 – Timescale, the cloud database company, has announced the launch of their […]
Free Webcast: How to Think Like the Engine, Live
You’re comfortable writing queries to get the data you need. But you’re uncomfortable if someone asks you how it […]
Who’s Hiring in the Microsoft Data Platform Community? November 2023 ...
Is your company hiring for a database position as of November 2023? Do you wanna work with the […]
Storm Ciaran Analysis with Microsoft Fabric
Always looking for Open Source data to highlight the capabilities of Microsoft Analytics solutions, I have: In […]
Analyse de la tempête Ciaran avec Microsoft Fabric
Toujours à la recherche de données Open Source afin de mettre en exergue les capacités des solutions […]
Moving SQL Server To The Cloud: Modernizing Stack Overflow for ...
Earlier this year, we migrated the entire Stack Overflow for Teams platform to Azure. This was a […]
SQL Server and Python Tutorial
Introduction In this article, we will see how to connect SQL Server with Python using the pyodbc library. […]
Five database DevOps practices for boosting team productivity
The post Five database DevOps practices for boosting team productivity appeared first on SQLServerCentral.
Creating an Azure PostgreSQL cluster and connecting to it
One of the technologies that my new job brought with it was learning about all the various […]
Deploying availability groups for SQL Server with HPE Serviceguard for ...
It’s time for a new blog on how Ansible can simplify SQL Server deployment, configuration, and availability. If […]
Getting connected to PostgreSQL for the first time
PostgreSQL continues to be all the rage in 2023, whether in “vanilla” form of the fully open-source […]
Efficient Table Migration to a New Schema in T-SQL
Introduction Efficiently migrating tables to a new schema in T-SQL is a common task for database administrators and […]
SQL Server Fragmentation Impact with Modern Hardware
The post SQL Server Fragmentation Impact with Modern Hardware appeared first on SQLServerCentral.
Microsoft at the PASS Data Community Summit 2023
It’s gearing up to be an exciting week November 14th – 17th as we prepare for this year’s […]
Entra Authentication for Replication in Arc-enabled SQL Server 2022 CU ...
As of SQL Server 2022 Cumulative Update (CU) 6, configuring replication using authentication with Microsoft Entra ID (formerly […]
The Black Friday Sale is Live!
You’ve used sp_Blitz and the First Responder Kit to learn a lot about your databases. You read the […]
Why Database Discussions Have Moved From the Backroom to the ...
The post Why Database Discussions Have Moved From the Backroom to the Boardroom appeared first on SQLServerCentral.
SQL Server Central Is Upgrading Our Servers
The Short Story We will be upgrading our systems on Thur, Nov 2, from around 930a GMT to […]
Using Pipeline Return Value in Azure Data Factory and Azure ...
Introduction In this article, we will talk about Azure Data Factory’s newly introduced Pipeline return value features. We […]
SSMSInfoReports : nouvelle release v9
Une nouvelle release de mes rapports custom pour SQL Server Management Studio, la v9 ! Enormément d’améliorations partout […]
SQL Endpoints and Lakehouse UI Differences and Access Secrets
There are some differences and secrets between the UI of a SQL Endpoint and the UI of […]
[Video] Halloween Office Hours in Salem, MA
I visited friends in Salem, Massachusetts, home of the 1692 witch trials, and it turns out Salem is […]
Utiliser les indicateurs de requête, la présentation
Téléchargez la présentation de la conférence Datafrogs « utiliser les indicateurs de requête (Query hints) ». https://blog.datafly.pro/public/Documents/Datafrogs_-_Query_Hints.pdf La vidéo de […]
Mastering a cloud migration: 10 video tips
The post Mastering a cloud migration: 10 video tips appeared first on SQLServerCentral.
Improve Query Performance when SQL Server Ignores Nonclustered Index
The post Improve Query Performance when SQL Server Ignores Nonclustered Index appeared first on SQLServerCentral.
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 […]
Trigger the Execution of an ADF Pipeline from an Email
Introduction The problem statement is to execute a Data Factory Pipeline automatically every time an email is received […]
Power Query Editor in Power BI for Formatting Text Columns
The post Power Query Editor in Power BI for Formatting Text Columns appeared first on SQLServerCentral.
Pike’s Market to Pikes Peak: The PASS Summit is Worth ...
Recently I spoke at SQL Saturday Denver. The day after the conference we went to visit Pikes […]
Packed/Batched Transact-SQL (TSQL) RPC Invocation
The SQL Server TDS protocol provides two main paths for query execution (Language and RPC events.) You can […]
Announcing Buy-Now-Pay-Later, Just in Time for the Black Friday Sale!
It’s almost time for my annual Black Friday sale, and some of you are staring longingly at the […]