70-457 Reviewer #09, Auditing SQL Server 2012
This review topic is still covered under the Optimize and Troubleshoot SQL Server lesson which covers 14% of the exam....
2013-08-13
584 reads
Blog Posts
Baton Rouge Startup Weekend
I'm spreading the word out about an event this weekend called Startup Weekend.
It's an event for developers, designers, and entrepreneurs...
2013-08-13
626 reads
Dear recruiter: I will not help you do your job for free
I literally get 10-15 calls and emails a week from recruiters asking if I can help them to find a...
2013-08-13
1,103 reads
How Much Unallocated Space do I Have in My Database Files
In a previous post, I wrote about when and how to shrink your database files. The bottom line was that...
2013-08-13
2,349 reads
Linchpin People Partner
In April 0f 2012 I was fortunate enough to be asked to become Linchpin People LLC’s first ever TeamMate. (blog)....
2013-08-13
838 reads
OPASS Meeting W/ Luis Figueroa & Jen Underwood–August 22, 2013
Luis Figueroa will be presenting Getting started with Master Data Services 2012 and then Jen Underwood will be presenting Practical...
2013-08-13
646 reads
Renaming all references inside stored procedures and functions can be migraine worthy without a little help…
If you run across migrating or copying a database structure for some purpose, yet need to change the database references...
2013-08-13
1,934 reads
SSRS: Report Actions, URL Actions and SharePoint
I recently encountered a scenario involving a SSRS report that contains a report action to launch a sub-report. The child...
2013-08-13 (first published: 2013-08-07)
4,711 reads
Sys.dm_os_performance_counters Demystified
The dmv sys.dm_os_performance_counters is awesome, if you can understand it. This is how I make it easy to read and...
2013-08-13
2,612 reads
T-SQL Tuesday #45 – Who’s Auditing My SSIS Packages?
It’s time once again for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday #45 is...
2013-08-13
868 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