PASS Update #51-Summit Site Selection
In November/December HQ requested that the Board to send in suggestions for possible sites for the 2013 PASS Summit. I...
2011-02-01
1,566 reads
SQL Rally BI Sessions
This week the voting for the SQL Rally BI track went out, and I wanted to send a quick reminder...
2011-02-01
1,196 reads
24 Hours of PASS Sessions Announced
In case you missed it last week, PASS has announced the speaker lineup for the next 24 Hours of PASS. ...
2011-02-01
567 reads
What’s a Passive Server?
Licensing software is often a more complicated process than I think it should be. Licensing database software seems to be...
2011-02-01
5,174 reads
31 Days of SSIS – SSIS Naming Conventions (31/31)
31 Days of SSIS
We’re at the thirty-first, and last, post for the 31 Days of SSIS. The series started with...
2011-02-01
1,449 reads
Your Lack of Documentation is Costing You More Than You Think
You’ve got a mountain of work to get done and not enough time to do it in. There’s simply just not...
2011-02-01
1,514 reads
My Thoughts on the Intel Sandy Bridge Chipset Recall
I awoke this morning to see a number of stories breaking about the Intel Sandy Bridge H67/P67 Chipset Recall. I...
2011-01-31
2,167 reads
SQL Lunch - Introduction to Change Data Capture
Join me tomorrow for a little CDC.
#47-Introduction to Change Data Capture
Speaker: Patrick LeBlanc
Add To Outlook: Add To Calendar
Meeting URL:https://www.livemeeting.com/cc/usergroups/join?id=269DRP&role=attend
Date and...
2011-01-31
1,974 reads
Building an Extremely Power Efficient Intel Sandy Bridge Desktop System
Since I have a 3.15Kw grid-tied Solar PV System on the roof of my house in Parker, I pay pretty...
2011-01-31
2,166 reads
SQL Rally 2011 Voting - Reporting Services Boot Camp
All,
Since SQL Server Reporting Services 2005 came out, I have been working very close within the BIDS environment and every...
2011-01-31
1,543 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