Eliminating Empty Output Files in SSIS
So you’ve got some packages that regularly extract data to one or more text files, but you know that from...
2009-09-30
13,965 reads
Blog Posts
Heading Down to the Basement
I'm taking the next two days off, heading down into the basement for a four day weekend. Nothing particular going...
2009-09-30
1,476 reads
Idea for PASS Summit 2010 – Share Your Other Passions
I’ve had the glimmer of this idea since I posted about the idea of bringing my chair to the 2009...
2009-09-30
1,386 reads
Minor Celebration
A little cheap thrill for me. I passed 50,000 views on the blog yesterday. Thanks to everyone who has stopped...
2009-09-30
1,385 reads
On vs. Where
Does it matter if you put your criteria in the ON clause or the WHERE clause? Well, as with most...
2009-09-30
1,771 reads
Pre-Compiled Stored Procedures: Fact or Myth
There’s a very common belief among DBA’s: Stored procedures are pre-compiled. I had someone tell me all about it just...
2009-09-30
1,909 reads
Referral Contest for PASS Summit
Hopefully you saw it in the special mailing that went out yesterday, but the marketing team just released a new...
2009-09-30
1,370 reads
SQLSaturday #21 Update
We’re closing in on our October 17th SQLSaturday #21 in Orlando and I thought I’d share a few things about...
2009-09-30
1,406 reads
TechEd Online Interview
Back in August at TechEd Africa I did a TechEd Online interview with Frikkie Bosch. Frikkie’s the marketing manager for...
2009-09-30
1,472 reads
The old INNER JOIN syntax vs. the new INNER JOIN syntax
I was in a presentation last week where the presenter was talking about the ANSI/ISO SQL standards. For the most part the...
2009-09-30
47,043 reads
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers