In the Interest of Disclosure
Yesterday I attended an internal training course on social networking. The class was targeted toward the 100 level, but like...
2010-09-03
425 reads
Blog Posts
MDX Puzzle #7 - Solution
Puzzle #7 had an interesting twist. You were required to add a column to the result set that dynamically displayed...
2010-09-03
595 reads
Recursive Hiearchies in Reporting Services
I am not a Reporting Services guru and nor do I play one on TV. I am however forced to...
2010-09-03
2,654 reads
Re-learning how to think
Cross-posted from The Goal Keeping DBA:
Re-learning how to think is always a difficult process. My oldest son is starting the...
2010-09-03
1,495 reads
September S3OLV Meeting
Another month has crept up upon us. It is time once again for the Las Vegas User Group /PASS Chapter...
2010-09-03
493 reads
Six Trips
Six trips left to close out this year. Most are very short, so that’s good, but still, it’s a bunch...
2010-09-03
319 reads
Getting Drive Info Part 3, CLR
In the first two parts, (Part 1, Part 2), of the Getting Drive Info series the techniques to gather drive info with methods that will work on SQL Server...
2010-09-02
15 reads
Getting Drive Info Part 3, CLR
In the first two parts, (Part 1, Part 2), of the Getting Drive Info series the techniques to gather drive...
2010-09-02
1,555 reads
I Hate Planes
A few short bloopers, just for a few friends that fly planes.
YouTube Link (in case the embed fails)
2010-09-02
534 reads
Idera SQL Tools – An evaluation
Idera SQL ToolBox
(http://www.idera.com/Products/SQL-toolbox/)
The datasheet for ToolBox – asks the question – Want an Easy way to save money? No manager is going...
2010-09-02
2,213 reads
Blogs
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...
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
Forums
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...
BCA KCP Pasar Minggu Center | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
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