Welcome to Azure Synapse at SQL Saturday Tampa 2020
SQL Saturday Tampa is coming up again in a couple of weeks on February 29th and I’m excited to announce that I’ll be there and presenting my session Welcome...
2020-02-12
18 reads
Blog Posts
#PowershellBasics: Get input using Read-Host
Conditions are the life blood of programming. This condition is met so now I need to do this task. That ... Continue reading
2020-02-11 (first published: 2020-02-05)
549 reads
Azure SQL Database and Error Handling
For some reason I have friends / colleagues telling me that when scaling (up and down for this example) that no downtime occurs. Well, not only does Microsoft documentation...
2020-02-11
265 reads
Lessons from Iowa’s Caucus Debacle
Earlier this week, the state of Iowa held its caucuses to choose each political party’s nominee for November’s presidential election. Being the first state in each election cycle to...
2020-02-11 (first published: 2020-02-06)
786 reads
T-SQL Tuesday #123: Lifehacks to Make Your Day Easier
This month, Jess Pomfret (blog | twitter) is trying to beat the winter motivation slump by exploring, and asking us to share, our lifehacks that make daily life a...
2020-02-11
3 reads
Allow users to start/stop Azure VMs
Today I wanted to cover how you can grant the least privilege required to stop, start or restart an Azure VM. This is also a fun great example of...
2020-02-10 (first published: 2020-02-04)
3,019 reads
The State of Database DevOps 2020
I’ve been an advocate for database DevOps since before DevOps was a thing. When I first switched from being a developer full-time to being a DBA full-time, the first...
2020-02-10 (first published: 2020-02-04)
335 reads
Speaking at PowerShell Summit 2020!
I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2020 the conference runs from April 27th through April 30. This is an incredible event packed...
2020-02-08
5 reads
Speaking at PowerShell Summit 2020!
I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2020 the conference runs from April 27th through April 30. This is an incredible event packed...
2020-02-08
3 reads
Speaking at SQLBits 2020
I’m proud to announce that I will be speaking at SQLBits! I had the absolute pleasure of speaking at SQLBits last year for the first time and saw first hand...
2020-02-08
2 reads
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers