Hooks
Building hooks from your software into enterprise monitoring systems is prudent, and might save you from a few late night phone calls.
2014-08-29
184 reads
Building hooks from your software into enterprise monitoring systems is prudent, and might save you from a few late night phone calls.
2014-08-29
184 reads
2014-08-29
1,540 reads
Preparing a disaster recovery plan means more than just trying to prevent a few specific disasters. It means turning around the way you view the world.
2014-08-28
200 reads
I’ve been working on some skills, trying to grow some of my T-SQL, and started to mess with the PIVOT...
2014-08-26 (first published: 2014-08-18)
8,200 reads
One of the things that can make a big difference in how well your software performs is testing.
2014-08-25
138 reads
What is the impact of flash storage on databases? There are quite a few, but this week Steve Jones asks if SQL Server should do more to take advantage of them.
2014-08-25
187 reads
2014-08-25
1,706 reads
A few friends challenged me yesterday, including Grant Fritchey and Aaron Bertrand. Last night, when I got to the Denver...
2014-08-22
1,312 reads
2014-08-22
1,697 reads
I was looking to write a new test with the tsqlt framework recently. I wanted to isolate a stored procedure’s...
2014-08-20
1,235 reads
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
I have an issue where I have a Bill of Material list of items...
Comments posted to this topic are about the item Follow Your Hunch
Comments posted to this topic are about the item What Happens When You Ask...
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