AWS SSM PowerShell Script Automation
SSM Overview
I’ve found that working with a large number of environments in AWS can provide some interesting challenges for performing various tasks, in a way that scale.
When you begin...
2019-07-04
3,335 reads
Interview with Grant Fritchey
This is the fourth interview we have done. This time our guest is Grant Fritchey! Probably you do not know that but Grant has started his career in …...
2019-07-19 (first published: 2019-07-04)
566 reads
Azure Databricks – create new workspace and cluster
In this post, I will quickly show you how to create a new Databricks in Azure portal, create our first cluster and how to start work with it. This...
2019-07-04
97 reads
Better SQL Server CPU defaults in 2019
SQL Server 2019 is still in preview as I write this, but I wanted to point out a new feature that Microsoft has added to SQL Server Setup, on...
2019-07-03
178 reads
Microsoft Most Valuable Professional – Data Platform for 2019-2020
Today, I’m proud to announce that I have been renewed as an Microsoft MVP – Data Platform for the 2019-2020 award year, my third MVP award. This is an truly an honor and...
2019-07-03
6 reads
Microsoft Most Valuable Professional – Data Platform for 2019-2020
Today, I’m proud to announce that I have been renewed as an Microsoft MVP – Data Platform for the 2019-2020 award year, my third MVP award. This is an truly an honor and...
2019-07-03
13 reads
Microsoft Most Valuable Professional – Data Platform for 2019-2020
Today, I’m proud to announce that I have been renewed as an Microsoft MVP – Data Platform for the 2019-2020 award year, my third MVP award. This is an truly an honor and...
2019-07-03
35 reads
Powershell script to get list of databases on a server
At one of my clients I received an email from one of the IT Project Managers asking a simple question:"Can you please let us know which databases reside on...
2019-07-18 (first published: 2019-07-03)
14,050 reads
sp_drivespace – See How Much Space You Have On Your Disks, Including Mount Points
We love xp_fixeddrives here, it’s a quick and simple way to see how much space you’ve got available on your drives. But there are just a couple of things...
2019-07-17 (first published: 2019-07-03)
832 reads
Come See the Future of Database DevOps at SQL Sat Austin
I’ll be coming to SQL Saturday #890 – Austin in just over a week. Austin is a great technology town, and this should be one of the larger SQL...
2019-07-03
42 reads
Blogs
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
Question of the Day
The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers