How Do I Configure SSIS to Work With a Named Instance
How Do I Configure SSIS to Work With a Named Instance?
By default, SSIS (SQL Server Integration Services) uses the msdb...
2008-12-11
12,804 reads
Blog Posts
Stupid Coding Tricks
Can anyone here write a SQL statement that generates a Mandelbrot Set? I’m sure a few of you can, and...
2008-12-11
868 reads
Just Do It
I was recently reading Joel Spolsky’s column in Inc. on management and I thought it was an interesting story. In...
2008-12-10
857 reads
SQL Quiz Part 2: Career Challenges
I’ve read a number of responses from Chris Shaw’s first DBA networking quiz. I missed out on the first one,...
2008-12-10
1,276 reads
You're Not Dumb...And Neither am I
One of the things I'm not fond of is self-deprecation. Smacking yourself on the forehead when you screw up a...
2008-12-10
529 reads
Are You Security Minded?
It's fun to just sit and talk with people, never know what you'll learn or be forced to rethink based...
2008-12-09
733 reads
DBAs Still in High Demand
With the world economy on the downside, there is at least one bright light, and that is DBAs are still...
2008-12-09
1,104 reads
Leaving Live
Last week Steve Ballmer had issued a challenge to MVPs to have them try Live Search instead of their regular...
2008-12-09
661 reads
A Custom Trace
I have to admit that when I had a performance problem with some code, I would often fire up Profiler...
2008-12-08
698 reads
Managing By The Numbers Part 2
Managing by the numbers often gets a bad name among employees because it can lead to a lot of gaming...
2008-12-08
655 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