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
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers