You Need to Manage Passwords
I saw a note this week from CNet about a system built to crack passwords (also on ArsTechnica). It reminded...
2012-12-18 (first published: 2012-12-12)
2,735 reads
Blog Posts
Annual Email Pruning
Like most of us, I get a lot of email. I get subscribed to various services from different ads, events,...
2012-12-17
960 reads
Are You a Chessplayer?
I was having a twitter coversation with @dataartisan about chess. He remarked that playing on-line with random folks didn't strike him...
2012-12-17
1,035 reads
CPU Overcommitment and Its Impact on SQL Server Performance on VMware
In the early days of virtualization, the core focus of virtualization was primarily consolidation. You could achieve quite high consolidation...
2012-12-17
1,865 reads
Generating multiple SQL statements from a query
Dynamic SQL is one of my favorite tools in the DBA toolbox. I’m big on automation and dynamic SQL can...
2012-12-17
1,139 reads
Ghost Cleanup process
I’ve been digging deeper into the Ghost Cleanup process recently, and quite naturally my quest lead to Paul Randal’s blog....
2012-12-17
14,009 reads
Introduction to Microsoft’s Master Data Services (MDS) Presentation
I will be presenting the session “Introduction to Microsoft’s Master Data Services (MDS)” at the Data Architecture Virtual Chapter on Thursday, Dec...
2012-12-17
785 reads
Last Weeks Top 10 “Reading” Links #11
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-12-17
631 reads
Let’s Talk About Joins
T-SQL Tuesday #37
This month please join us in the TSQL blog party that happens on the second tuesday of the...
2012-12-17 (first published: 2012-12-11)
2,941 reads
On the Fifth Day…
Today we will have a quick change of pace. This will be less about maintenance and more about internals. Today’s topic is one of particular interest to me as...
2012-12-17
3 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
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,...
Stan Phone Number Australia +61-1800868603 Quick Help Guide
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
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