Reblog: June 14 to June 20
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-06-21
852 reads
StrateSQL
Last Weeks Top “Reading” Links #37
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-06-17
619 reads
Reblog: June 7 to June 13
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-06-14
875 reads
The Side Effect of NOLOCK (video)
A while back I put together a blog post on the side effect of NOLOCK. Today I thought I’d push...
2013-06-13
543 reads
Security Questions: Migrate Logins Between Servers
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-06-13
583 reads
Security Questions: SQL Agent Permissions
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-06-12
625 reads
T-SQL Tuesday – Evil Plan Operators – #TSQL2sDay
This month, Rob Farley (Blog | @Rob_Farley) is running T-SQL Tuesday on plan operators. T-SQL Tuesday is a monthly blogging event where a number...
2013-06-11
715 reads
June 2013 – Monthly SQL Server Checklist
Today is the second Monday of June and guess what I didn’t publish last week? That’s right, there wasn’t an...
2013-06-10
545 reads
Looking to SQL Server 2014 High Availability In Standard Edition
During the keynote for TechEd North America 2013, Microsoft announced the planned release of SQL Server 2014. As part of...
2013-06-12 (first published: 2013-06-10)
3,618 reads
Last Weeks Top “Reading” Links #36
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-06-10
522 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...
BCA KCU THAMRIN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
Alamat kontak resmi BCA KCP Tebet Telp:0818751777
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
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