Enforcing T-SQL quality with SSDT Analysis Extensions
What? Simply put, it is possible to include checks in the SSDT (Sql Server Data Tools) build process - you come...
2014-12-30
219 reads
Ed Elliott's Sql Developer Blog
Enforcing T-SQL quality with SSDT Analysis Extensions
What? Simply put, it is possible to include checks in the SSDT (Sql Server Data Tools) build process - you come...
2014-12-30
221 reads
Enforcing T-SQL quality with SSDT Analysis Extensions
What? Simply put, it is possible to include checks in the SSDT (Sql Server Data Tools) build process - you come up with a set of rules or start...
2014-12-30
17 reads
DacFX Links
I thought it would be a good idea to gather together a list of links for DacFx, blogs code or...
2014-12-07
94 reads
DacFX Links
I thought it would be a good idea to gather together a list of links for DacFx, blogs code or...
2014-12-07
47 reads
DacFX Links
I thought it would be a good idea to gather together a list of links for DacFx, blogs code or articles - if you have anything that you think...
2014-12-07
7 reads
Make Visual Studio Setup Slightly Faster
If you get the Visual Studio 2012 or 2013 web installer then it uses the BITS service to download the...
2014-12-07
55 reads
Make Visual Studio Setup Slightly Faster
If you get the Visual Studio 2012 or 2013 web installer then it uses the BITS service to download the...
2014-12-07
64 reads
Make Visual Studio Setup Slightly Faster
If you get the Visual Studio 2012 or 2013 web installer then it uses the BITS service to download the setup files.
The BITS service is used to download files...
2014-12-07
17 reads
Running tSQLt tests from C/VB.Net/Java/Whatever
When you already have a test framework setup such as MSTest or NUnit and possibly a CI build in place...
2014-11-20
64 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