Service Pack 1 - Database Weekly (Apr 13, 2009)
This past week saw the release of Service Pack 1 for SQL Server 2008, and some interesting changes with it. Steve Jones comments.
Service Pack 1 - Database Weekly (Apr 13, 2009)
This past week saw the release of Service Pack 1 for SQL Server 2008, and some interesting changes with it. Steve Jones comments.
The Cloud of Destiny
Is SQL Server going to move to the "cloud?" Steve Jones thinks it is and has a few thoughts as he starts off with "cloud week" here at SQLServerCentral.
The Cloud of Destiny
Is SQL Server going to move to the "cloud?" Steve Jones thinks it is and has a few thoughts as he starts off with "cloud week" here at SQLServerCentral.
The Cloud of Destiny
Is SQL Server going to move to the "cloud?" Steve Jones thinks it is and has a few thoughts as he starts off with "cloud week" here at SQLServerCentral.
An Interview with Brad McGehee - Part 2
Continuing the interview with Brad McGehee, Robert Pearl asks about the new features in 2008 and his books.
Changing a Non-IDENTITY column to IDENTITY and vice versa
This article from new author Thomas Pieries, brings us a few methods for changing a Non-IDENTITY column to IDENTITY and vice versa as well as examining the advantages and disadvantages of each way.
Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 4
How do I go about building a clustered SQL Server 2008 running on Windows Server 2008?
Using Check Constraints to Validate Data in SQL Server
A number of different processes that can be used to make sure your data validates against your business rules. This article discusses how you can use database "check constraints" to validate your data within the SQL Server database engine.
An Interview with Brad McGehee - Part 1
MVP Brad McGehee, director of DBA Education for Red Gate Software, sat down recently with longtime author, Robert Pearl. In this interview, learn a bit about how Brad got started in the SQL Server world.
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