Certifications are a Bonus, Not A Path to Employment
I’ve never been terribly shy about my beliefs about IT certifications. I sincerely believe they are largely a waste of time. I do recognize that one thing they do...
2019-08-26
185 reads
Blog Posts
Git Command Line Tutorial with SQL Change Automation for SSMS (video)
I’m really excited for Redgate’s new SQL Change Automation plugin for SQL Server Management Studio (SSMS). SQL Change Automation lets DBAs and developers use a migrations-first approach to create...
2019-08-26
22 reads
Jenkins in a Container
One of the things I needed to do recently was get Jenkins running as a demo for a customer. We have some pre-built VMs to do this, but I...
2019-08-26 (first published: 2019-08-14)
497 reads
SQL Server Execution Plan Operators
Watch this week’s Execution Plan Operators episode on YouTube. SQL Server Execution Plan Operators When examining a query’s execution plan, certain operators tend to crop up over and over...
2019-08-26 (first published: 2019-08-13)
1,589 reads
Performance Tuning Steps Query by looking an execution plan and effectiveness of the index Part 2
How to read execution plan to improve poorly...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-08-25
180 reads
Machine Learning – how do I get a good data to learn?
This is the fourth article of the Machine Learning topic. I have introduced you to the Machine Learning, described the process and the tools. My first idea was that...
2019-08-24 (first published: 2019-08-11)
51 reads
Cloud Computing: Myths, Mysteries, Vampires & Vultures - a free seminar to help you learn more about "the cloud".
To be honest you probably think that migrating to the cloud sounds great, and it can be, but… it’s not without risks and many people do not sufficiently understand...
2019-08-23
30 reads
DBCC CHECKDB – Msg 7928, Level 16, State 1, Line 3 The database snapshot for online checks could not be created.
Do you execute DBCC CHECKDB on your Azure SQL Database? From past experience I know some people do, I would suggest not to bother. Why? Well I have mentioned...
2019-08-23
37 reads
Introducing Data Céilí Dublin 2020 – Ireland’s newest Data Platform event
Today we have launched Data Céilí Dublin 2020, Ireland’s free, community led, Microsoft Data Platform event. (It’s pronounced kay-lee btw ?? ) Brought to you by the team behind...
2019-08-23
30 reads
Podcasts on Modern Data Warehouse
I did a couple of recent podcasts that I wanted to mention: The first one was with Kirby Repko from the YouTube channel SQLTalk: Modern Data Warehouse Design with...
2019-08-23 (first published: 2019-08-08)
483 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
BCA KCU MOJOKERTO Hub 0822 2531 3145
WA CS 082225313145 Jl. HOS. Cokro Aminoto No.5, Mergelo, Jagalan, Kec. Magersari, Kota Mojokerto,...
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