SQL Saturday #57 – Houston
SQL Saturday #57 was this weekend! Sean and I went, talked, webshow-ed, and then presented a total of SIX sessions!
Travel
Sean and...
2011-01-31
1,646 reads
Powershell to Automate SQL Compare
A question came up on the SQL Server Central Forums, how could you use Red Gate SQL Compare to automate...
2011-01-31
4,290 reads
PASS Update #50-January 2010 Board Meeting
This post is my thoughts on the Board meeting, and my views on related topics. I encourage you to read...
2011-01-31
1,955 reads
Presentations Materials From Last Week
Last week I spoke at the PASSMN meeting here in Minnesota and then via a webcast to the Edmonton PASS...
2011-01-31
1,376 reads
SQLSaturday, Rocky, and a CheeseSteak - Upcoming Event
As you know, the SQLSaturday sensation has exploded all over the nation. So many events scheduled this year, there is...
2011-01-31
2,108 reads
Microsoft Support Policies for Windows Server and SQL Server
Microsoft provides ten years of support (five years Mainstream Support and five years Extended Support) at the supported service pack...
2011-01-31
4,844 reads
31 Days of SSIS – Importing Execution Plans (30/31)
31 Days of SSIS
Almost time to wrap up the 31 Days of SSIS. We are down to just two more...
2011-01-31
2,867 reads
SQL Saturday #57 Slides, Code & Video
This past weekend I spoke at SQL Saturday #57 in Houston, TX.
I want to thank the local PASS chapter HASSUG,...
2011-01-30
1,631 reads
31 Days of SSIS – Exporting Execution Plans (29/31)
31 Days of SSIS
A day late for the twenty-ninth post of the 31 Days of SSIS, but it is still...
2011-01-30
2,378 reads
I've been in Alabama
Let me start of by saying I could have taken this picture in Florida. But I didn’t. I was in...
2011-01-30
1,317 reads
Blogs
T-SQL Tuesday #201 - Temp Tables, Friend or Foe?
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
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...
Forums
ALAMAT BCA KCU TULUNGAGUNG Hub 082225313145
WA CS 082225313145 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
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