Why don’t lookup columns appear in no match output?
I often get asked when we are discussing loading dimension tables in SSIS, why the key columns from the table...
2010-02-20
357 reads
Blog Posts
Bikes for Almost Grownups
Ran across this in Make Magazine, http://www.bigkidbike.com/, these are totally custom bikes, with names like Bigger Wheel, Lizard, and Kitten....
2010-02-19
552 reads
Feedback from Connect : Allow Snapshot Backups
I posted a note to allow snapshots to be backed up in SQL Server. The inability to do so, and...
2010-02-19
1,482 reads
On Ethics
I was having a conversation recently with a friend and former co-worker of mine. He's bounced around here and there,...
2010-02-19
801 reads
Playing With SQL Azure Data Synch
Microsoft has provided a free tool that allows you to easily create a SQL Azure database, and then synchronize the...
2010-02-19
1,580 reads
Reporting Services Switch Function
Recently a client requested to create a Reporting Services expression that emulated the CASE WHEN statement from T-SQL. The expression...
2010-02-19
4,292 reads
So You Want to Write a Book?
What the heck is wrong with you?
Still interested? Fine. I’ll tell you my take on this whole business. I’m only...
2010-02-19
706 reads
Speaking at the PASS DBA Virtual Chapter
Next week, I’ll be “in the cloud” as I give a presentation for the PASS DBA Virtual Chapter. The topic...
2010-02-19
350 reads
SQL Azure Database Service Update 1 Released on February 17
Microsoft’s David Robinson has announced on the SQL Azure Team Blog that they have released Service Update 1 for SQL...
2010-02-19
525 reads
SQL Server 2005/2008, Service Packs - announcement
This is a good news from the Microsoft about SQL Server Release Services for both versions SQL Server 2008 & 2005.
SQL...
2010-02-19
660 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers