31 Days of SSIS – 10 Things About Expressions (16/31)
31 Days of SSIS
Sixteen days in and we are past the half way point for the 31 Days of SSIS...
2011-01-16
1,000 reads
Check that what you expected is actually what you got - DB's and SQLCMD
I feel that it is wise move for a script to actually check itself that the database connection that is...
2011-01-16
1,398 reads
SSMSDeploy will be available, with source, for donation
After much um-ing and ah-ing I have decided to release my addin, with source code, under the GNU GPL.
I've also...
2011-01-15
570 reads
31 Days of SSIS – Every Which Way Outputs (15/31)
31 Days of SSIS
Saturday morning and you can watch your favorite cartoon, or jump into some fun with SSIS. Today...
2011-01-15
587 reads
SQL Saturday #62
I presented a one hour session at SQL Saturday #62 in Tampa on SQL Server PowerShell Extensions (SQLPSX): “In this...
2011-01-15
422 reads
SSMSDeploy Demo #2 - new features
I've made some changes to the addin, adding some new features:
Comments: You can now add a comment to your request....
2011-01-15
608 reads
PASSMN January Meeting Announced
The details are up and we have the meeting planned for January for the Minnesota SQL Server User Group (PASSMN). ...
2011-01-15
618 reads
SQLServerCentral.com Track at SQL Server Connections 2011 in Orlando in March
SQLServerCentral.com will be offering a track at SQL Server Connections, to be held March 27-31, 2011, at the JW Marriott...
2011-01-14
920 reads
Multi-tenant Architecture
When you design a database, or at least when I do, I think it’s important to build a database schema...
2011-01-14
4,475 reads
Failed Blog Posts
Over the last week I’ve started and trashed two blog posts. Let me tell you, that’s painful. You get some...
2011-01-14
732 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
BCA KCU MOJOKERTO Hub 0822 2531 3145
WA CS 082225313145 Jl. HOS. Cokro Aminoto No.5, Mergelo, Jagalan, Kec. Magersari, Kota Mojokerto,...
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