Jacksonville Code Camp 2012
Hello one, hello all. It has been quite a while since I have blogged. I am looking forward to starting...
2012-10-04
1,163 reads
Brian K. McDonald
Dataset with Text or Stored Procedure
As most of you already know, Reporting Services reports make use of Datasets to get data. These Datasets can get...
2011-10-02
1,211 reads
SQL Saturday 85 Follow Up
Last weekend I travelled down to SQL Saturday 85 in Orlando, FL. Like all of the other events that I’ve...
2011-10-02
968 reads
SQL Saturday 85 – Orlando
Grab your computer and get registered for SQL Saturday 85 in Orlando. If you’re new to the SQL world and...
2011-09-19
1,028 reads
Task Factory: Advanced Email and SMS Task
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,569 reads
Task Factory: Compression Task
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,334 reads
Task Factory: Data Cleansing Transform
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,207 reads
Task Factory: Data Validation Transform
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,654 reads
Task Factory: Email Source and Delete Email Task
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,345 reads
Task Factory: File Properties Task
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,991 reads
Blogs
Parameter Sensitive Plan Optimization in SQL Server 2022. What is it and is it any good?
Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that...
Azure chaos STUDIO
By Arun Sirpal
Chaos engineering is fun but especially important when building solutions in the cloud. It...
Announcing a New Book on SQL from 3Cloud Authors
By DataOnWheels
I am proud to announce the launch of a new book, centered around the...
Forums
Azure DW default schema in a query / proc equal to "Search_Path" in AWS
I know you can't do this in MSSQL, but hoping DW has progressed more....
Call SQL Agent job using different account to one executing powershell
Hi Folks trying the below but having zero luck and was wondering if anybody...
Encrypt Varchar(max) column in SQL Server
I have a varchar(max) column which has sensitive data and want to encrypt it....
Ask SSC