Migrating SSIS to Azure – Slidedeck (Techorama 2019)
Techorama 2019 is over and it was a blast, as usual. Neatly organised, great speakers and fantastic content. I delivered a session on Migrating SSIS to Azure (Data Factory)....
2019-05-25
45 reads
Blog Posts
Animating a Magic 8 Ball in SQL Server Management Studio
This post is a response to this month’s T-SQL Tuesday #114 prompt by Matthew McGiffen. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...
2019-05-24 (first published: 2019-05-14)
868 reads
DevOps Is About Communication
I spend a lot of time showing how to use tools to automate database deployments in support of DevOps. However, the one message that I always try to deliver...
2019-05-24 (first published: 2019-05-13)
295 reads
Mini-Rant: Spoofed Phone Numbers and Trust
I’ve seen this more and more over the last year: I receive a phone call with a number that indicates it’s coming from a town or city near me....
2019-05-24
193 reads
Speaking at SQL Saturday Dallas
Speaking at SQLSaturday Dallas!
I’m proud to announce that I will be speaking at SQL Saturday Dallas on May 17th 2018! This one won’t let you down! Check out the amazing schedule!...
2019-05-24
4 reads
Speaking at SQL Saturday Dallas
Speaking at SQLSaturday Dallas! I’m proud to announce that I will be speaking at SQL Saturday Dallas on May 17th 2018! This one won’t let you down! Check out the amazing schedule!...
2019-05-24
35 reads
Always Use Roles–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Which of these is more complex? GRANT SELECT...
2019-05-23 (first published: 2019-05-10)
597 reads
Containers: Working With Volumes
In the previous two posts on containers I showed how use Docker commands to get an image and create a container. This time, we’re going to create a container...
2019-05-23
18 reads
Mass Backup All Sessions
Migrating Extended Event Sessions from one server to another should be a simple task. So simple, one would think there was no need to give it a second thought,...
2019-05-23
4 reads
Mass Backup All Sessions
Migrating Extended Event Sessions from one server to another should be a simple task. So simple, one would think there was no need to give it a second thought,...
2019-05-23
11 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
ALAMAT BCA KCU HR MUHAMMAD TLP/WA 0817839777
Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...
BCA KCU BUKIT DARMO BOULEVARD Tlp:0817839777
Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...
ALAMAT KANTOR BCA KCU SIDOARJO TLP/WA 0817839777
Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
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