Scale-out SSRS (a brain dump)
So, I just got finished with a SQL Server Reporting Services (SSRS) scale-out deployment, based largely on this step-by-step guide. Things mostly went...
2018-02-06
420 reads
SQL Awesomesauce
Absolute computer fundamentals: the command line!
So I’ve spoken to more than one DBA who is not familiar with using the command prompt (aka command line)...
2018-01-02
399 reads
RegEx in SSMS: A gift for quick code
I had yet another example of how beautiful Regular Expressions can be in SQL coding today, and so I thought...
2017-12-28
719 reads
PowerShell for fun (and profit?)
Let's have a liltle fun with PowerShell. Along with, I suppose, a couple of useful things and links.
The post PowerShell...
2017-11-15
387 reads
Session: T-SQL’s Hidden Support Feature
Today I presented one of my favorite sessions - T-SQL's Hidden Support Feature - for the DBA Fundamentals group! They'll put up...
2017-11-14
354 reads
Five reasons to be a technology speaker
I don’t think everyone should be a technical speaker. But I wouldn’t object if everyone spent a season trying. Why be a...
2017-11-08
363 reads
Attend “T-SQL’s Hidden Support Feature” online September 11!
I’m presenting T-SQL’s Hidden Support Feature for the DBA Fundamentals virtual chapter on Monday, Sep 11 at 9:30 PM CDT! Session description: The most effective...
2017-09-06
389 reads
Tech news: Your phone screen is a dirty rotten spy
Great. Now you can't even trust your phone's screen, of all things, to not steal your data… https://t.co/KUyGjwsih2 — Adam Machanic...
2017-08-29
394 reads
That thing you want to do? Do the thing.
You're thinking of starting a blog, or teaching, or training videos. Will it pay off? Will it be worth it?...
2017-07-29
690 reads
Celebrate! Second Anniversay Giveaway (is now over)
Two years ago, we officially became MinionWare and launched the absolutely masterful SQL Server management solution, Minion Enterprise. For a...
2017-07-18
332 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