2024-10-21
1,237 reads
2024-10-21
1,237 reads
The Azure Data Lake is a massively scalable and secure data storage for high-performance analytics workloads. We can create three storage accounts within a single resource group.
2024-10-21
This article shows how to find missing rows in a table using a outer join.
2024-10-18 (first published: 2013-11-12)
23,777 reads
Unable to travel to Seattle this November? We have options for you to join in from the comfort of your own home or office, with a free livestream and on-demand access available to buy.
2024-10-18
In this article, we look at a SQL Server Dynamic Management View (DMV) that helps find queries that trigger missing index recommendations.
2024-10-18
AWS offers a robust suite of tools designed to manage big data effectively. This article explores focusses on how SQL is leveraged within Amazon Redshift and Amazon Athena. We will delve into the technical features, practical applications, and step-by-step examples for using these services, highlighting how they can transform raw data into actionable insights for your business.
2024-10-16
294 reads
This next article looks at how a Logic App in Azure can start and stop various database services and save money.
2024-10-16
1,414 reads
Learn how to get started with Elasticsearch with data in your SQL Server database.
2024-10-14
1,695 reads
Create an SQL Server backup for an Azure Managed Instance that you can download and restore on another SQL Server instance.
2024-10-14
Freshly minted MCM Wayne Sheffield fills a log shipping crack that could otherwise cause you to re-initialize your log shipping.
2024-10-11 (first published: 2013-06-06)
5,550 reads
Want to build a data analytics foundation that transforms raw data into valuable business...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
By Tim Mitchell
Earlier this month, I hosted the monthly T-SQL Tuesday invitation in which I asked,...
I'm not sure that I'm posting this in the right section, so please mods...
Hi all I've written a script to keep track of how long backups...
I have this view [dbo].[Asset Metrics - Client(Rama -Client-Test)], which makes use of multiple...
In the current (Sep 2024) Data Migration Assistant, what are the possible sources for on-premises SQL Server instances?
See possible answers