Coding Standards Gone Bad in SQL Server
Knowing your data is very important when it comes to writing code. Now I’ll admit that I am very far from being a developer, however as a DBA, I...
2020-05-01 (first published: 2020-04-21)
1,046 reads
DAX and Power BI Stairway Live
As part of the Redgate Community Circle, I’m going to be running a live class on DAX and Power BI, every Thursday, from 12MDT for about 30-45 minutes. We’ll...
2020-04-21
161 reads
New Article: Understanding SQL Server Ownership Chaining
Back in January I gave a presentation to a small group of folks on foundational SQL Server security items. The last thing I covered was the concept of ownership...
2020-04-21
48 reads
Daily Coping 21 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-21
19 reads
T-SQL Tuesday Live 21 Apr 2020
I’ll be hosting T-SQL Tuesday live again today, at 1:00pm MDT/3:00pmEDT/8:00pmGMT If you’re interested in taking a break, chatting, touching base with others, bring your comments, questions, thoughts, and...
2020-04-21
18 reads
Remote Work Resources
We’re at least five weeks into this thing here in New York and while there are some encouraging signs, it’s more likely than not that “non-essential” workers aren’t at...
2020-04-21
8 reads
Audit Logons with Extended Events
This article shows how to audit the logon events for SQL Server 2012 and beyond through the use of XEvents.
Related Posts:
Life Support 2008 - Audit Logons July 17, 2019...
2020-04-20
8 reads
Audit Logons with Extended Events
This article shows how to audit the logon events for SQL Server 2012 and beyond through the use of XEvents.
Related Posts:
Life Support 2008 - Audit Logons July 17, 2019...
2020-04-20
6 reads
Audit Logons with Extended Events
This article shows how to audit the logon events for SQL Server 2012 and beyond through the use of XEvents.
Related Posts:
Life Support 2008 - Audit Logons July 17, 2019...
2020-04-20
7 reads
Audit Logons with Extended Events
This article shows how to audit the logon events for SQL Server 2012 and beyond through the use of XEvents.
Related Posts:
Life Support 2008 - Audit Logons July 17, 2019...
2020-04-20
13 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