Holidays and Calendar Generation
Create the definition of your holidays and have them available for any year. Create a Calendar including holidays and business/work dates.
2017-12-15 (first published: 2016-02-16)
6,133 reads
Paul Hunter
2016-02-15 (first published: 2016-01-29)
830 reads
BCP Format File Builder
Utility stored procedure to create non-xml format file for BCP/BULK INSERT processes. Very useful for text-qualified CSV files.
2009-08-14 (first published: 2009-08-04)
2,361 reads
Blogs
ANSI_WARNINGS = OFF can break update statements with some SQL features
By Will Assaf
Working on a SQL 2017 database where an external, non-Microsoft application has direct access...
Bring Your Own Key to Azure SQL Database Managed Instance TDE
Last year Azure SQL Database Managed Instance saw the introduction of bring your own...
CRM Data Source Connection Error
This article takes us to the edge with a couple of CRM related errors...
Forums
Two Availability Group Questions
Hello experts, I'm an accidental DBA who recently joined a new group, and I'm...
SSIS Excecute SQL Task not executing simple T-SQL correctly.
Hello, I have an SSIS package with an Execute SQL Task that runs the...
Case when index scan faster then index seek (see example)
Hi, we had case today where query with existing non clustered index provided 100% ...
Ask SSC