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,806 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
662 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
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers