Handling Escape Sequences in SSIS Expression String Literals
The SSIS expression language is a powerful tool for a developer that gives you one method of making a package...
2010-01-27
995 reads
Devin Knight
Handling Escape Sequences in SSIS Expression String Literals
The SSIS expression language is a powerful tool for a developer that gives you one method of making a package...
2010-01-27
8,472 reads
SSIS Checkpoints with Tasks Running in Parallel
Several months ago I blogged about why Checkpoints are a great feature in SSIS to use. It seems with every...
2010-01-22
3,484 reads
SQL Lunch #8 recording
If you weren't able to attend tuesday for SQL Lunch you can watch the recording now mosted on the website. ...
2010-01-15
605 reads
SQL Lunch #8 recording
If you weren't able to attend tuesday for SQL Lunch you can watch the recording now mosted on the website. ...
2010-01-15
591 reads
Configure Report Manager to open Report Builder 2.0
Recently while at a client I was discussing the differences between Report Builder 1.0 and Report Builder 2.0. The discussion...
2010-01-08
900 reads
Configure Report Manager to open Report Builder 2.0
Recently while at a client I was discussing the differences between Report Builder 1.0 and Report Builder 2.0. The discussion...
2010-01-08
1,753 reads
Analysis Services Performance Optimization Tips
Over the last few weeks I have focused most of my blog energy into writing a couple articles. So I...
2009-12-29
1,874 reads
Anaylsis Services Partitions and Aggregations PASS Session
For a little more than a year now I've been a part of the PASS BI SIG and have tried...
2009-12-18
432 reads
Using a SSRS Report to run SQL Agent Jobs part 2
In part one of this post I showed how you can use a report to run SQL Server Agent Jobs by...
2009-12-11
1,883 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers