Book Review: T-SQL Window Functions by Itzik Ben-Gan
A couple of years back Itzik Ben-Gan (the T-SQL guru) wrote the book Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions. It’s has been one of my most...
2019-12-19
29 reads
Blog Posts
Cloudbrew 2019 – Slides
Cloudbrew 2019 is over and it was a great event. Great speakers and a big audience. Even in my session there were a lot of attendees, which I found...
2019-12-19
4 reads
Cloudbrew 2019 – Slides
Cloudbrew 2019 is over and it was a great event. Great speakers and a big audience. Even in my session there were a lot of attendees, which I found...
2019-12-19
17 reads
New Power BI Report Design Pre-Con in 2020
I’m excited to announce that I will be offering a full-day pre-con about Power BI report design in the coming year called Bookmarks, brain pixels, and bar charts: creating...
2019-12-19 (first published: 2019-12-05)
496 reads
One-Click Package Restart in SSIS
This quick tip is likely to be the most brief of the entire collection, but is also one of the most practical. When testing SSIS packages during development in...
2019-12-19
13 reads
SQL Server Christmas Script
Nothing much to say but I hope you all have a nice break. Thanks for the support and reading my blog. Enjoy the script! (Might not format correctly here...
2019-12-19
55 reads
Why You Should Take the 2020 State of Database DevOps Survey today (video)
In this six minute video, I explain why you should take the 2020 State of Database DevOps Survey. The survey is open for a few more days — we’ve...
2019-12-19
7 reads
Compression in SQL Server: COMPRESS and DECOMPRESS
On Twitter recently, I asked: Does anyone I know use the COMPRESS and DECOMPRESS features in T-SQL? To those who replied in the affirmative, I asked: What made you...
2019-12-18
141 reads
Database Reliability Engineering (22 minute video)
I was fascinated yesterday to come across the term, “Database Reliability Engineering,” which I hadn’t seen before. In this 22 minute whiteboarding session, I talk about why we need...
2019-12-18
5 reads
Distributing Jupyter Notebooks
If you’re working with the Microsoft Data Platform, you should be, at the least, exploring Azure Data Studio as a new tool in your toolbox. One of the big...
2019-12-18 (first published: 2019-12-09)
334 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