Use Connections Properly in an SSIS Script Task
There are lots of scenarios in SSIS where you'd want to use a connection within a Script Task. Unfortunately, the closest help documentation - the comments inside the Script...
2011-05-31
2,653 reads
Blog Posts
Use Connections Properly in an SSIS Script Task
There are lots of scenarios in SSIS where you'd want to use a connection within a Script Task. Unfortunately, the closest help documentation - the comments inside the Script...
2011-05-31
8 reads
Using “NOT IN” in a query can provide mixed results
The topic came up at work awhile back with using various includes/excludes such as IN, NOT IN, and EXISTS. A...
2011-05-31
1,372 reads
What Encryption Algorithms Are You Using?
Security is an important consideration when designing a database application. Who can get access to what data? How much damage...
2011-05-31
2,112 reads
Better Writing from Hemingway
These are five rules for writing from Ernest Hemingway, which I like and recommend for use in your communications. Definitely...
2011-05-30
1,737 reads
Big Data I: 16 Papers and original articles
What are the most influential papers in the world of Big Data? Let me suggest: http://bit.ly/BigData1 We face a data management problem: IDC 2010 Digital Unverse Study http://bit.ly/BigData2...
2011-05-30
17 reads
Big Data I: 16 Papers and original articles
What are the most influential papers in the world of Big Data? Let me suggest:...
2011-05-30
9 reads
How to become an expert in your field
I have been compiling a list of what things a person can do to become an expert, or guru, in...
2011-05-30
5,078 reads
More Bloopers for Memorial Day
It’s Memorial Day, and as usual, I have a blooper reel for the editorial. However I couldn’t fit everything in...
2011-05-30
1,654 reads
Optimizer Timeouts with XQuery
I was looking at performance of a database and I noticed a few of the plans were very large and...
2011-05-30
2,119 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers