What Color Were You On Today?
The school my daughter attends gives each student a workbook type thing at the beginning of each year, and it...
2011-06-09
603 reads
BIDSHelper 1.5 for SSAS, SSIS, SSRS released
BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server...
2011-06-09
777 reads
Speaker Lessons!! Un-SQL Friday #004 Roundup
We had a cozy (read: small) UnSQL Friday this time around, and I’m good with that. Every entry we got...
2011-06-09
846 reads
Get Certified… with Insurance
Have you been thinking about getting certified? Are you close on finishing your studying but aren’t quite sure if you...
2011-06-09
708 reads
SQL Server Default Backup Directory
Someone asked me in a webinar how to change the default backup directory. I knew, but realized that I didn’t...
2011-06-09
24,093 reads
NetApp Dynamic Backup Script
For those of you who’ve worked with NetApp and SnapManager for SQL Server, you will know can generate a scheduled...
2011-06-09
1,220 reads
SSRS Error: Report Preview displays Access to the path ‘…\bin\Debug\Report.rdl’ is denied
While working on Reporting Services at a client site I came across this error when trying to preview a report...
2011-06-08
3,330 reads
Materials from SQL Server, Storage and You Part III
Thanks again to everyone who attended. Technical problems aside I had a great time and there were some great questions!
If...
2011-06-08
578 reads
Notes from Solid State for SQL Server with Wes Brown from Today’s Idera Broadcast – SSD Best Practices for Database Servers
The following is a combination of notes from Wes Brown’s presentation today, with edited details from his http://sqlserverio.com/ post on...
2011-06-08
3,888 reads
Top 10 virtualization benefits for the developer
Virtualization is becoming a hot topic lately, and there is no doubt it provides a ton of benefits. But you...
2011-06-08
1,119 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
Alamat Kantor BCA KCU Subang Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa...
Alamat Kantor BCA KCU Purwakarta Telp:08218154374
Hub Via Wa:628218154374 Alamat Bank Bca Kcu Purwakarta, Jl. Jendral Sudirman No.85, Nagri Tengah,...
Alamat BCA KCU Soekarno Hatta Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Soekarno-Hatta No.240, Kb. Lega, Kec. Bojongloa Kidul, Kota Bandung,...
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