The Database Weekly Update for July 21, 2008
In this update from the past week Steve Jones looks at leaks in encrypted disks and Web 2.0 development.
Pulling Together
When a co-worker is ill, what should the rest of the office do? How do you handle absences that might extend for weeks or months. Steve Jones comments on the responsibilities of the team.
SSAS Database Backup
Longtime SQL Server author Dinesh Asanka brings us a new article on backing up an Analysis Services database.
Things You Didn't Know About Temp Tables and Table Variables
New author Roi Assa brings us a short look at temp tables and table variables and describes a few of the characteristics and behaviors you might not have been aware of.
Soft Skills
A guest Friday poll from Adam Angelini, DBA and member of the band Wakamojo, which was featured on some editorial podcasts. This week Adam wonders about soft skills for DBAs.
Soft Skills
A guest Friday poll from Adam Angelini, DBA and member of the band Wakamojo, which was featured on some editorial podcasts. This week Adam wonders about soft skills for DBAs. (Steve Jones reads)
Soft Skills
A guest Friday poll from Adam Angelini, DBA and member of the band Wakamojo, which was featured on some editorial podcasts. This week Adam wonders about soft skills for DBAs.
SQL Server 2005 Express Edition - Part 26 - Introduction to Service Broker
This article is a brief overview of Service Broker's core features, which are available (in a somewhat limited capacity) in SQL Server 2005 Express Edition. The next installment will describe a sample application illustrating its operations and discuss its management, security, and routing characteristics.
Untouched Data
How much data do you have that's never accessed. Apparently most of it on a network is just stored and never re-examined. Steve Jones comments on a few statistics.
XML Workshop XXI - Generating an ATOM 1.0 Feed with FOR XML EXPLICIT
This long running, and very popular, XML series continues with a look at building an ATOM feed with SQL Server.
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
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...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
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