MSDTC Best Practices with an Availability Group
In this article we are going to look at some guidelines and MSDTC best practices with an Availability Group. Please note that some of these recommendations change if you...
2019-10-14
21 reads
MSDTC Best Practices with an Availability Group
In this article we are going to look at some guidelines and MSDTC best practices with an Availability Group. Please note that some of these recommendations change if you...
2019-10-23 (first published: 2019-10-14)
502 reads
Database Fundamentals #24: Filtering Data
If you’ve been reading these Database Fundamentals posts, you’ve already seen the WHERE clause because of your use of it when manipulating data with DELETE and UPDATE statements. It’s...
2019-10-21 (first published: 2019-10-14)
617 reads
#PowershellBasics: The Windows Powershell icon in the task bar also lets you run Powershell ISE.
I don’t know about you, but I like having the tools that I’m likely to use on my taskbar. That ... Continue reading
2019-10-14
95 reads
Launching SQL Compare with Context
Years ago Redgate Software started some work to link our tools together. I remember early efforts, about which I had dubious thoughts as to the value. I hadn’t looked...
2019-10-21 (first published: 2019-10-14)
268 reads
Undercover TV Podcast – Intent Locks
The first of our new series of new look podcasts, David has a look at intent locks in SQL Server and what the purpose of them is.
2019-10-18 (first published: 2019-10-14)
202 reads
Geneology with SQL Graph – I
I have been working a lot of SQL Graph related queries and applications of the graph data concept to the extent possible within SQL Server’s graph capabilities. Genealogy, or...
2019-10-17 (first published: 2019-10-14)
1,198 reads
Preparing for PASS Summit - Networking and Events
This is my second post in a series which I hope will help you (and me!) prepare for the upcoming PASS Summit November 4-8, 2019 in Seattle, Washington.
Networking, Networking!...
2019-10-14
9 reads
SQL in the City Back in London
It’s just a couple weeks until the SQL in the City Summit comes back to London. This is our second Summit this year in London, and I’m honored to...
2019-10-17 (first published: 2019-10-11)
218 reads
Azure Fundamentals 12th December
Certified Microsoft Azure Fundamentals - AZ-900 1 day Web based Course - 12th December 2019
Its been a big few of weeks here at gethynellis.com. We've been accepted onto the UK...
2019-10-11
5 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
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...
Forums
Alamat Kantor BCA KCU Bekasi Telp:08217555651
Hub Via Wa:628217555651 Alamat Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel.,...
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
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