Lazy Developers - Database Weekly (2008/07/28)
Developers tend to be lazy in Steve Jones' view. This week he examines some of the problems that this lack of effort can cause in applications.
Lazy Developers - Database Weekly (2008/07/28)
Developers tend to be lazy in Steve Jones' view. This week he examines some of the problems that this lack of effort can cause in applications.
Monitoring Report Execution Performance with Execution Logs
This article presents an excerpt from the book, Microsoft SQL Server 2005 Reporting Services Step by Step, by Stacia Misner and Hitachi Consulting. Learn how to monitor reporting services by implementing an execution logging database and reviewing reports that query that database.
Virtual Conversions
Virtualization is becoming more and more popular, being implemented in many companies every day to replace the need to add more physical boxes to your data center. Steve Jones comments on some of the handy features of virtualization.
Develop Robust and Scalable Apps with SQL Server Data Services
Here the author introduces SQL Server Data Services, which exposes its functionality over standard Web service interfaces.
Service Accounts
A Friday poll from Steve Jones looks at service accounts and how you deal with passwords.
Service Accounts
A Friday poll from Steve Jones looks at service accounts and how you deal with passwords.
Service Accounts
A Friday poll from Steve Jones looks at service accounts and how you deal with passwords.
Upgrading live applications to SQL Server 2005
Part 4 in this series on upgrading an Active/Active cluster to SQL Server 2005 details how to push live data from one cluster to another using a conversion DB and replication.
Kimball ETL Part 1 – Data Profiling via SSIS Data Flow
A new series sponsored by Actuality Business Intelligence on data warehousing. In part 1, the data flow in SSIS packages are used to profile the source data and determine how it should be handled in the process.
Blogs
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
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...
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