SSIS 2019 has arrived!
It is not a joke: SSIS is available for Visual Studio 2019 as a preview. Whoa, hold on. SQL Server 2019 hasn’t been released yet? But there’s already an...
2019-04-25
3,769 reads
Blog Posts
Where should I clean my data?
As a follow-up to my blogs What product to use to transform my data? and Should I load structured data into my data lake?, I wanted to talk about where you...
2019-04-25
2,191 reads
Window Functions vs GROUP BYs
There are many options available for improving the performance of a query: indexes, statistics, configuration settings, etc… However, not all environments allow you to use those features (eg. vendor...
2019-04-25 (first published: 2019-04-16)
1,257 reads
Can SQL Ids be used on an instance with Windows Authentication only?
tl;dr; Yes, but. It’s generally considered more secure to have your SQL Server instance set to Windows Authentication and not ... Continue reading
2019-04-24 (first published: 2019-04-11)
457 reads
Interview with Andre Melancia
This is my second interview! This time with Andre who is a cat lover and great speaker! Here you can find the interview!
2019-04-24
46 reads
Join me for a PASS Summit Pre-Con
I am very excited to announce I will be delivering a pre-conference session on SQL Server Performance Tuning on November 5th at PASS Summit 2019. If you have ever...
2019-04-24
91 reads
Testing as another user–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is one of those things I do...
2019-04-24 (first published: 2019-04-10)
356 reads
What’s the Mashup Engine?
I was testing something the other day and ran sp_who2 on a test instance. I saw this in the program listing: I had never seen the Mashup Engine listed...
2019-04-24
25,924 reads
Yes, pulling just the data you need is really important.
I was asked the other day why a customer was having performance issues on a table. A simple SELECT that ... Continue reading
2019-04-24
326 reads
CISA Accredited Trainer!
My certification came in! I’m now accredited to provide training for the Certified Information Systems Auditor (CISA) certification. It’s not the Microsoft Certified Trainer (MCT) accreditation I once had...
2019-04-23
38 reads
Blogs
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
Question of the Day
The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers