SQL Quiz Part 2
I was recently tagged by Tim Mitchell to give a response to Chris Shaw’s SQL Quiz Part 2 so here...
2008-12-15
815 reads
Blog Posts
SQL Server 2005 SP3
… has arrived: http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en
It’s obviously hot off the presses because the “What’s New document” is 404.
2008-12-15
678 reads
SSIS - Fast Parse
I had another chance last week to answer an email follow up question from the session Brian and I gave...
2008-12-15
8,507 reads
St. Louis Day of .Net
Yesterday I spoke on 2008 T-SQL and Data Types at the St. Louis Day of .Net event. This was an...
2008-12-14
419 reads
FriendFeed Review
I’ve been trying the social networking thing, with accounts on Twitter, Facebook, and LinkedIn. I guess I have one on...
2008-12-12
775 reads
SQL Quiz #2 - Toughest Challenges in my Career
I finally got tagged for the SQL Quiz, which I've been following. Michelle Ufford, aka SQLFool, tagged me following her...
2008-12-12
1,329 reads
Calories Burned During Sex
Ah, if you're reading this aren't you the curious one! I ran across the link below a while back and...
2008-12-11
641 reads
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,798 reads
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
866 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
854 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Cross-DB Ownership Chaining problem
We want to setup a gateway db to host stored procedures which use tables...
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers