Speaking at SQLSaturday #446, Oregon 2015
I have spoken a number of times at different SQLSaturdays around the world, including some rather rare editions, such as...
2015-09-21
433 reads
Blog Posts
Step by Step SSIS - Conditional Split Transformation TIP #117
In the series of Zero to Hero in SSIS this is our next post. In this post we will see...
2015-09-21
3,273 reads
Where is my data stored?
Tables within SQL Server can contain a maximum of 8060 bytes per row. However even though columns are limited to...
2015-09-21
645 reads
Where is my data stored?
Tables within SQL Server can contain a maximum of 8060 bytes per row. However even though columns are limited to...
2015-09-21
366 reads
Why I hate Pie Charts
The pie chart should be avoided at all costs. Why?
you can only display a limited number of slices (although that...
2015-09-21
540 reads
XML Attribute VS Element Assignment when working with SQL
XML handling with aliases
I find it interesting the difference in behavior with querying XML between column assignment, and quoted alias...
2015-09-21
303 reads
XML Attribute VS Element Assignment when working with SQL
XML handling with aliases
I find it interesting the difference in behavior with querying XML between column assignment, and quoted alias...
2015-09-21
193 reads
Yes, Foreign Keys Help Performance
I created this example several years ago that illustrates how foreign key constraints can help performance. It’s a contrived example....
2015-09-21 (first published: 2015-09-09)
2,682 reads
Zombie AD Groups
I spent something like 2 hours today trying to figure out how a particular user had access to one of...
2015-09-21
628 reads
Clustered Index and related Interview Questions
Since the day I wrote my first blog. My friends are eagerly waiting for just one topic. The Indexing. I...
2015-09-20
356 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