SQLSaturday#59 Update! - 3 weeks to go.....the after PASS East Coast Special!
SQLSaturday#59 Update!
Well, the event is now less than 3 weeks away (better finish my presentation 🙂 and there are 450+ attendees...
2010-11-01
567 reads
Android Adventures–Part 1
I’ve used a Blackberry for the better part of 10 years, loyalty built because as a phone and an emailing...
2010-11-01
389 reads
Finding Your Dream Job
My pre-conference session for the SQL Rally conference in the spring is called “Finding Your Dream Job”. Chris Shaw ( LinkedIn...
2010-11-01
658 reads
November Question: What steps do you include in your database maintenance?
Database maintenance is a critical task for every DBA. For this month’s question, list the typical steps that you use...
2010-11-01
1,438 reads
Rescheduled: SQL Lunch #42 - Auditing Database Permissions in SQL Server
Last Wednesday I woke up feeling under the weather with a hoarse voice. I wasn't up to doing the presentation...
2010-11-01
709 reads
Leaving (for) Las Vegas
Tomorrow I’m off to Las Vegas for SQL Connections. Since tomorrow is also T-SQL Tuesday #012, I’m writing a pre-trip...
2010-11-01
429 reads
“Wear Your SQL Saturday Shirt Day”
Over the past year there have been a number of SQL Saturday events. These events have occurred across the country...
2010-11-01
878 reads
Vote for Our SQL Rally PreCon
VOTE VOTE VOTE VOTE VOTE VOTE VOTE!!!!!!!!!!
Vote here: http://www.zoomerang.com/Survey/WEB22BD59JCQBT
Honestly, I want each of reading my blog to vote for our...
2010-11-01
491 reads
SQLServerCentral.com Track at SQL Server Connections This Week
If you are attending SQL Server Connections this week in Las Vegas, be sure to attend some of the sessions...
2010-11-01
630 reads
Database Security Best Practices for the Vigilant Database Administrator and Developer (Unabridged Edit)
Below is a longer version of the equivalent Technet Article under Security TechCenter > Learn > Security Columns > MVP Articles > Database Security Best PracticesThe security of...
2010-10-31
5,327 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
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
The Range of Customers
Comments posted to this topic are about the item The Range of Customers
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