Calling all UK Bloggers…
Amazingly It’s been just over 4 months since I started my list of UK based SQL Server bloggers, and I...
2011-05-03
595 reads
Blog Posts
How often do you check email?
If you read the experts, most folks check their emails too many times during the day. Today, while giving a...
2011-05-03
794 reads
Indexing for ORs
All of the indexing strategy posts I’ve written in the past have been concerned with predicates combined with ANDs. That’s...
2011-05-03
1,009 reads
Iterating Over Columns in the SSIS Script Component
Just recently a question was posed in the MSDN SSIS Forums about how to create a "generic" script component that...
2011-05-03
13,269 reads
Iterating Over Columns in the SSIS Script Component
Just recently a question was posed in the MSDN SSIS Forums about how to create a "generic" script component that would read all columns for each row passed through...
2011-05-03
131 reads
Iterating Over Columns in the SSIS Script Component
Just recently a question was posed in the MSDN SSIS Forums about how to create a "generic" script component that would read all columns for each row passed through...
2011-05-03
15 reads
May 2011 S3OLV Meeting
After a whirlwind of last minute changes last month, we expect stability this month with the monthly meeting.
Meeting Time is...
2011-05-03
574 reads
May 2011 S3OLV Meeting
After a whirlwind of last minute changes last month, we expect stability this month with the monthly meeting. Meeting Time is 6:30PM PST Erika Bakse (blog | twitter) has...
2011-05-03
2 reads
My Partitioning And Compression Quest!
So I have a pretty big database (around 1 TB) that’s getting a bit out of
hand. I inherited it...
2011-05-03
652 reads
T-SQL Tuesday #18 Coming Next Week
Other than the week I hosted it, I’ve been caught off guard by T-SQL Tuesday most months. This time I...
2011-05-03
688 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