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 Replication
Welcome back to another replication series! As a quick reminder, we explored various methods of using MySQL’s replication capabilities in our previous discussions. Initially, we employed the traditional binary-log-based replication approach to se …
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 you can read the original invitation by clicking on the T-SQL Tuesday 165 invitation or the following images. I almost always forget that this is coming and …
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?) and made an amusing observation about the relative value of different SQL Server books. I just had to go look at Amazon for some research. I’m listing pr …
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 instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some t …
What Is an Execution Plan and How to Find It in PostgreSQL
In the last blog (When PostgreSQL Parameter Tuning is not the Answer), we compared several execution plans for a SQL statement as we made changes to parameters and indexes. Still, there was no mention of what an execution plan is, how one can obtain an …
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 DATE and TIME datatypes, respectively. Also note that the CONVERT functionality can be replaced with CAST, if that’s your preference. Correc …
Using Power Query to Combine Data from Multiple Sheets in Excel
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 Guide
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 enable applications to communicate and exchange data, amongst other actions. Representational State Transfer (REST) …
How to List First or Last n% Records Using NTILE() in SQL Server
The post How to List First or Last n% Records Using NTILE() in SQL Server appeared first on SQLServerCentral.
AutomatedLab – A Quickstart for Deploying SQL Server Labs on Windows
Developers require convenient and separate spaces for testing and development. They can utilize various tools, such as PowerShell, to create and manage virtual machines, network settings, and software setups. This simplifies the setup of labs or test a …
[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 in this episode: 00:00 Start 02:23 Stockburn: Hi Brent, we are using distributed always on AGs, with a no …
Managing Query Store Hints
I wrote about query store hints before when they were first released in Azure SQL databases. However, there are some tricks related to managing query store hints we will explore on this blog post. Applying Query Store Hint When we apply a query store h …
[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 limited time left to ask your toughest database problems (not trivia questions) at https://pollgab.com/room/brento. Here’s what …