Be aware of the risk that you are taking when using AWS EC2 I3 instance type
The AWS I3 storage optimized instance family has a potential problem if you choose to use it for storing your data.
2021-09-14
8,850 reads
Steve Rezhener
- Website: https://www.datasteve.com
Identify Profiles Actually In-use to Make Database Mail Migration Efficient
Introduction According to Microsoft, Database Mail is an enterprise solution for sending e-mail messages from the SQL Server Database Engine. Using Database Mail, your database applications can send e-mail messages to users. The messages can contain query results and can also include files from any resource on your network. This article is going to discuss […]
2021-04-27
1,199 reads
Hacking the DTSX (SSIS XML file) to Change Defaults
Introduction According to Microsoft, DTSX is an XML-based file format that stores the instructions for the processing of a data flow from its points of origin to its points of destination, including transformations and optional processing steps between the origin and destination points. In a nutshell, when you are creating your SSIS package, the SQL […]
2021-03-25
4,583 reads
Syncing your SQL Server database backups to an AWS S3 bucket
Introduction "Sometimes" just having all the database backups in one place is not enough. In fact, most of the time, putting all the eggs in one basket is a bad idea. You want to have some piece of mind that during the time of crisis, all your database backups are restorable. This is probably why […]
2021-02-11
6,543 reads
The case for SQL Server Agent 2.0
SQL Server Agent is heavily used by many organizations, but it hasn't changed much in years. This article speculates on some new features that might improve the scheduler.
2020-12-21
3,357 reads
Boost performance of your SQL Server tables with a TURBO button
Introduction Performance, performance, performance. While performance in SQL Server can be achieved with code improvement and proper infrastructure maintenance, both tasks require an effort. Code reviews and deep index analysis would take time, but sometimes the obvious is right in front of you. Let's talk about HEAP tables, aka tables with no clustered indexes that […]
2020-12-08
7,227 reads
Getting Informative SQL Agent Notifications from Failed SSIS Packages
Getting informative error messages when something goes wrong with an SSIS package is critical, especially if you are not in front of your computer.
2020-11-25
7,132 reads
Ensure that SSRS is Working while Using Availability Groups
This article explains how to get around one of the issues when the SSRS databases are part of an Availability Group.
2020-11-17
5,537 reads
Block user objects from being created in a master database
Introduction The Master database. Just in case that you are not familiar with this database, the Master database is used in SQL Server to store all the system information, instance-level settings, logon information, database file locations, etc. SQL Server can't run without access to a fully functional master database. It's highly recommended not to use […]
2020-11-10
4,060 reads
2020-10-22
9,342 reads
Blogs
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Flyway Tips: Multiple Projects
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
Forums
Can an Azure App Service Managed Identity be used for SQL Login?
I'm fairly certain I know the answer to this from digging into it yesterday,...
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Question of the Day
Fun with JSON I
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT *
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t; See possible answers