Going to a conference where hardly anybody knows my name
On Friday and Saturday August 11 and 12, I am going to do something I haven’t done […]
Archives du mois : août 2023
[Video] Office Hours: Stump Me On SQL Server
I went through the top-voted questions from https://pollgab.com/room/brento and discussed ’em live on my Twitch channel. Here’s […]
[Video] Office Hours: Extended Answers Edition
Y’all posted so many good questions at https://pollgab.com/room/brento that I went longer than usual this time: Here’s what […]
Meet the Summit 2023 Sponsors
The post Meet the Summit 2023 Sponsors appeared first on SQLServerCentral.
Upserts in Amazon Redshift
Amazon Redshift was first announced in 2012 as a new cloud-based analytical data warehousing service. Since then, it […]
Standard Sponsor Rates End August 30!
The post Standard Sponsor Rates End August 30! appeared first on SQLServerCentral.
A Beginners Guide to MySQL Replication Part 4: Using GTID-based ...
Welcome back to another replication series! As a quick reminder, we explored various methods of using MySQL’s […]
T-SQL Tuesday #165 – My Experience with Database Job Titles
They mean very little. More on that after nothing that this is part of T-SQL Tuesday, and […]
I/O optimizations for tempdb in SQL Server and Azure SQL
I have found almost every day of my career at Microsoft, I learn something new about Microsoft SQL. […]
Analyzing Prices of SQL Server Books, New & Used
While on a road trip, Richie stopped by a used bookstore (or would that be used book store?) […]
The Curious Case of… recovering from a ransomware attack
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post […]
Azure Data Studio 1.45 Release and Hotfix
We released Azure Data Studio 1.45 over a week ago, and today we’re announcing a hotfix for it, […]
What Is an Execution Plan and How to Find It ...
In the last blog (When PostgreSQL Parameter Tuning is not the Answer), we compared several execution plans […]
Combine DATE and TIME to DATETIME2 in SQL Server
tl;dr In the following code, « DateValue » and « TimeValue » can be replaced by either variables or columns of the […]
Using Power Query to Combine Data from Multiple Sheets in ...
The post Using Power Query to Combine Data from Multiple Sheets in Excel appeared first on SQLServerCentral.
7 Essential Factors for a Successful Cloud Migration: A Non-Technical ...
The post 7 Essential Factors for a Successful Cloud Migration: A Non-Technical Guide appeared first on SQLServerCentral.
Building REST APIs in Go with Mux and GORM
In modern software development, Application Programming Interfaces (APIs) are essential for building scalable and flexible systems. APIs […]
How to List First or Last n% Records Using NTILE() ...
The post How to List First or Last n% Records Using NTILE() in SQL Server appeared first on […]
AutomatedLab – A Quickstart for Deploying SQL Server Labs on ...
Developers require convenient and separate spaces for testing and development. They can utilize various tools, such as PowerShell, […]
ODBC Driver 18.3 for SQL Server Released
Version 18.3 of the Microsoft ODBC Driver 18 for SQL Server has been released. Version 18.3 brings some improvements […]
JDBC Driver 12.4 for SQL Server Released
Version 12.4 of the Microsoft JDBC Driver for SQL Server has been released. Version 12.4.0 brings several added […]
[Video] Office Hours While the Pool Refills
I step away from the backyard long enough to take y’all’s questions from https://pollgab.com/room/brento. Here’s what we covered […]
Managing Query Store Hints
I wrote about query store hints before when they were first released in Azure SQL databases. However, […]
[Video] Office Hours: Stump Me With Your Data Questions
There are only a couple weeks left in this summer’s marathon of Office Hours sessions, which means there’s […]
Create Your First Pipeline in Microsoft Fabric
Introduction Microsoft Fabric is an end-to-end analytics solution that includes data lakes, data integration, data engineering, data science, […]
Who’s Hiring in the Microsoft Data Platform Community? August 2023 ...
Is your company hiring for a database position as of August 2023? Do you wanna work with the […]