Presentation Slides For Hardware 201 at SQLSaturday #66 in Colorado Springs
I will be giving my Hardware 201: Selecting and Sizing Hardware for OLTP Performance presentation at SQLSaturday #66 at 1:30PM...
2011-02-12
860 reads
Glenn Berry
Windows Instant File Initialization and SQL Server
One Windows setting that I think is extremely important for SQL Server usage is the “Perform volume maintenance tasks” right,...
2011-02-11
1,785 reads
Service Pack 1 for Windows Server 2008 R2 and Windows 7
Microsoft’s Brandon LeBlanc announced the upcoming availability of Service Pack 1 for Windows Server 2008 R2 and Windows 7 on...
2011-02-09
1,647 reads
Promoted to MSDB Rockstar Blogger
I just found out this morning that I was promoted from TempDB to MSDB on Thomas LaRock’s (blog|Twitter) Rockstar blogger...
2011-02-07
492 reads
Five DMV Queries That Will Make You a Superhero in 2011!
Way back in January, 2008, I wrote a blog post called “Five DMV Queries That Will Make You A Superhero!”...
2011-02-04
2,814 reads
February 2011 Version of SQL Server 2005 and 2008 Diagnostic Information Queries
Wow, it is already February 2011, so here are the February 2011 versions of the SQL Server 2005 Diagnostic Information...
2011-02-02
1,931 reads
Building an Extremely Power Efficient Intel Sandy Bridge Desktop System
Since I have a 3.15Kw grid-tied Solar PV System on the roof of my house in Parker, I pay pretty...
2011-01-31
2,163 reads
Microsoft Support Policies for Windows Server and SQL Server
Microsoft provides ten years of support (five years Mainstream Support and five years Extended Support) at the supported service pack...
2011-01-31
4,844 reads
My Thoughts on the Intel Sandy Bridge Chipset Recall
I awoke this morning to see a number of stories breaking about the Intel Sandy Bridge H67/P67 Chipset Recall. I...
2011-01-31
2,166 reads
Speaking at the Rocky Mountain Tech Trifecta on March 5
I just got the notification that I will be one of the speakers at the Rocky Mountain Tech Trifecta on...
2011-01-28
687 reads
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