ACM Lecture at SELU
Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at the Southeastern La. University ACM group. Big thanks to the bright student organizers for inviting...
2020-02-27 (first published: 2020-02-21)
136 reads
Blog Posts
Midlands PASS: SQL Server Security Basics
Midlands PASS (Columbia, SC) will be meeting on March 3, 2020, for our monthly user meeting. We’ve been on hiatus since the holidays but we should be meeting regularly...
2020-02-27
43 reads
Removing ad hoc plans from Query Store
This is not a post about the “optimize for ad hoc workloads” setting on your favorite SQL Server instance, but that is a good place to start. Lots of...
2020-02-27 (first published: 2020-02-20)
436 reads
DBA, a job, a vital job
DBA, a job, a vital job. T-SQL a language that is fun. Select, a query to get some data. From, ... Continue reading
2020-02-26
24 reads
Join me at SQLBits 2020
The SQLBits conference is taking place in London again this year, between March 31st and April 4th, and I’ll be there. I will not be presenting this year, but...
2020-02-26
9 reads
Power BI Monthly Digest – February 2020
In this month’s Power BI Digest Manuel I will again guide you through some of the latest and greatest Power BI updates this month. In
2020-02-26 (first published: 2020-02-18)
420 reads
Quickly Create Github Release via Cli
TEST Intro
I've been trying to improve modularization with Terraform.
Using Terraform Cloud, you get a private module repository.
The modules are linked to tags in git.
I've wanted additionally to specifically create...
2020-02-26
12 reads
SOS_SCHEDULER_YIELD – What is it really telling us?
I decided to write this off the back of a conversation I was having the other day around the SOS_SCHEDULER_YIELD wait type. The conversation went something along the lines...
2020-02-26
133 reads
#PowershellBasics: Run a file and pass it a parameter.
I realized in my last #PowershellBasics post that I was talking about running a file and passing in an optional ... Continue reading
2020-02-25 (first published: 2020-02-17)
552 reads
Does dbatools Have a Function for That?
dbatools has a lot of functions. A lot. Over 550. There is a great command index on the website, and the documentation gets updated every time a new version...
2020-02-25
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