SQL Saturday NYC
I excited to say that PASS SQL Saturday NYC is back on the schedule and will be May 30, 2015...
2014-11-25
1,004 reads
NJSSUG SSIS Performance Tuning
On November 18, 2014 I had presented to the New Jersey SQL Server User Group (NJSSUG) on SSIS Performance Tuning. ...
2014-11-21
394 reads
Dating Tips Part 1
This is the first in a series of dating tips, so if you need you’ve come to the right place.
...
2014-02-01
252 reads
SQL 2012 SSIS Catalog Permissions
With the introduction of the SQL 2012 SSIS Catalog there has been the question of what permissions are available and...
2013-07-20
810 reads
Use Lookups the right Way
SSIS Lookup tasks are all too easy to abuse as they are easy to setup and not really think about...
2013-05-27
303 reads
Blogs
A New Word: Ghough
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
T-SQL Tuesday: Encryption and Data Protection
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Parameterize your Databricks notebooks with widgets
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
Forums
ASCII value of certain column is null
When ASCII(Column) is null, what does it represent? Is this some kind of special/control...
Need to output table data into multiple CSV files
Hello, I created the below script to output 999 rows from SQL Server table...
Changing Database page Verify on a Database in an AG
I have a database on SQL 2019 in an Availability Group (AG) and I...
Ask SSC