In this blog post, I’ve implemented two example environments for using SQL Server 2022’s s3 object integration. One for backup and restore to s3 compatible object storage and the...
2022-08-29 (first published: 2022-08-13)
578 reads
Introduction In this post, I will walk you through how to set up MinIO, so you can use it to work with SQL Server 2022’s s3 object integrations. Working...
2022-07-01 (first published: 2022-06-10)
220 reads
Introducing S3 in SQL Server 2022 S3 compatible object storage integration is a new feature introduced in SQL Server 2022. There are two significant areas where SQL Server leverages...
2022-06-22 (first published: 2022-06-06)
225 reads
Background If you’ve been using Availability Groups, you’re familiar with the replica seeding (sometimes called initializing, preparing or data sychronization) process. Seeding is a size of operation-based data, copying...
2022-06-17 (first published: 2022-05-26)
327 reads
My new course “Deploying and Managing Azure Kubernetes Service (AKS) Networking “ is now available on Pluralsight here! If you want to learn about the course, check out the...
2022-05-31
10 reads
My updated course “Maintaining, Monitoring and Troubleshooting Kubernetes” is now available on Pluralsight here! If you want to learn about the course, check out the trailer here, or if...
2022-05-18 (first published: 2022-05-09)
111 reads
My updated course “Configuring and Managing Kubernetes Security” is now available on Pluralsight here! If you want to learn about the course, check out the trailer here, or if...
2022-05-09
12 reads
My updated course “Configuring and Managing Kubernetes Security” is now available on Pluralsight here! If you want to learn about the course, check out the trailer here, or if...
2022-05-09
At work, I get to work with some fantastic tech that pushes the boundaries of performance. I needed to do some performance testing from a Windows server into a...
2022-03-16 (first published: 2022-02-24)
261 reads
I’m super proud to announce that Ben E. Weissman and I have published Azure Arc-Enabled Data Services Revealed - Second Edition available now at Apress and your favorite online...
2022-02-26
16 reads
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
In a containerized app, React and Chakra UI provide a robust and accessible user...
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Hello I need help identifying all records that have consecutive hours (time in order)...
hi, I have a table called Rules Create table Rules ( Id int ,...
I am currently upgrading a very old database running SQL Server 2008 to SQL...
What is returned from this query?
SELECT
( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2011
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2012
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2013; See possible answers