SQL Lunch #51–SQL U Presents Women in Technology
This week I am happy to announce the second SQL University SQL Lunch presentation. What’s makes this exciting is that...
2011-03-17
1,151 reads
DevWeek 2011 – A DBAs view
The title itself would lead you to believe this conference was only for the those looking to master the art...
2011-03-17
825 reads
There’s A New North Central Regional Mentor
What has two thumbs and just signed on to be a PASS Regional Mentor? This guy!
Over the past couple weeks,...
2011-03-17
698 reads
SQL Server Denali CTP1 Diagnostic Information Queries
Here is the first SQL Server Denali–specific version of my Diagnostic Information Queries. There are actually only two queries (which...
2011-03-16
1,016 reads
Balancing Work and Life
Balancing work and home life is nothing new; we’ve had this challenge for a long time. But in recent months when so many companies are streamlining operations and asking...
2011-03-16
9 reads
Balancing Work and Life
Balancing work and home life is nothing new; we’ve had this challenge for a long time. But in recent months...
2011-03-16
1,028 reads
SQL Server Standard Reports Winforms
In SQL Server, there is a good set of preloaded reports to help you monitor the Instance. These reports can be found under the Standard Reports and can be...
2011-03-16
8 reads
SQL Server Standard Reports Winforms
In SQL Server, there is a good set of preloaded reports to help you monitor the Instance. These reports can...
2011-03-16
2,783 reads
Becoming a DBA: How to gain experience
Last week I had an interesting telephone call from a someone who I connected with on linkedin.com. On Linkedin I’m...
2011-03-16
1,689 reads
SQL University Lecture Series: Women in Tech
This week SQL University is on Spring Break but we’ve lined up some activities to help keep students busy (you...
2011-03-16
661 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
Return all intermediate members of a recursive CTE?
I wrote a recursive CTE to determine employee levels... but what if I wanted...
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
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