Resetting an Azure SQL Database Admin Password
This is likely something that most people know, but it was a bit confusing for me. This post is really here to remind me and help cement this in...
2019-12-18 (first published: 2019-12-05)
2,972 reads
Blog Posts
SSIS Layout Formatting Options
Most folks I know go to one extreme or the other when it comes to the visual layout of SQL Server Integration Services packages: either they don’t care a...
2019-12-18
823 reads
Trace Flags That Are Now Defaulted Behaviors in SQL Server
If you have ever attended one of my performance tuning sessions, you know I tend to talk about trace flags. Trace Flags can help fix performance issues and some...
2019-12-18
344 reads
Using a PoSh variable in a string- #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is something I haven’t quite understood or...
2019-12-18
98 reads
Viewing Azure SQL DB security with sp_AzSQLDBPermissions
A few months back I put the Azure SQL DB version of my permissions script into beta. I’m not sure ... Continue reading
2019-12-18
54 reads
Configuration Manager is Corrupt
So you come along one day to validate some service configurations for the SQL Server services and instead of the SQL Server Configuration Manager opening as expected, you are...
2019-12-17
176 reads
Configuration Manager is Corrupt
So you come along one day to validate some service configurations for the SQL Server services and instead of the SQL Server Configuration Manager opening as expected, you are...
2019-12-17
3 reads
Power Platform Quick Tips – Episode 03: Documenting Power Automate Flow Logic
Welcome back to my series on Power Platform quick tips! In this episode you will learn how to document your flow logic with comments.
2019-12-17 (first published: 2019-12-06)
517 reads
Right-Click File Options in SSMS and SSDT
Ordinarily I wouldn’t blog solely about a set of right-click options in an application, but in this Eleven Days of Festivus series I’m sharing some quick tips that have...
2019-12-17
221 reads
SQL Homework – December 2019 – The default trace and the system health session.
I know this is the holiday season for many of us (which ones depend on your religion and nationality of ... Continue reading
2019-12-17 (first published: 2019-12-02)
443 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
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...
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers