Shadow IT
There are often Shadow IT groups in many companies. Steve Jones talks about the potential problems of these groups, and how he has dealt with them in the past.
Export images from a SQL Server Table to a Folder with SSIS
Can I export images from SQL Server to a file in Windows? What SQL Server options are available to do so? Check out this tip to learn more.
SQL Saturday #167 - Columbus, GA
A free day of training in Columbus, GA. Come meet the local SQL professionals and spend a day talking SQL Server.
Outsourcing Jobs
This week Steve Jones looks at some of the jobs being outsourced and how that might affect data professionals.
Ten Million Lines of Code
Intuit manages ten million lines of code in a single codebase and does a great job of it. Read a little about what they do.
Practical PowerShell for SQL Server Developers and DBAs – Part 1
There is a lot of confusion amongst DBAs about using PowerShell due to existence the deprecated SQLPS mini-shell of SSMS and the newer SQLPS module. In a two-part article and wallchart, Michael Sorens explains how to install it, what it is, and some of the excellent things it has to offer.
Fix v. Create
This Friday Steve Jones wants to know how you spend your time. Do you get to do a lot of new development or do you end up fixing, tuning, and improving old code. Let us know.
Solving the SQL Server Multiple Cascade Path Issue with a Trigger
This tip will look at how you can use triggers to replace the functionality you get from the ON DELETE CASCADE option of a foreign key constraint.
SQL in Boston -- Red Gate Style
Adam Machanic is speaking at SQL in the City - Boston on Oct 8, 2012.
Being Exceptional
It's time to vote for the Exceptional DBA awards, and Steve Jones is asking for your opinion. Take a moment and recognize one of your peers as the best DBA in 2012.
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