SQL Scripts Manager
We have Down Tools Week multiple times per year at Red Gate. This allows various employees to spend a week...
2014-03-26
4,177 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
The Endless Upgrade Cycle
Steve Jones notes that security can be a reason to upgrade your systems, but it can also result in an endless cycle.
2014-03-26
125 reads
Inspiring Change
Day 2 at the PASS Summit provides some inspiration for Steve Jones at the Women in Technology luncheon.
2014-03-25 (first published: 2009-11-05)
149 reads
Is Unit Testing Important?
Testing our applications is important, but at what level do we need to test? Steve Jones talks about unit testing today, and wonders if this is prevalent for SQL Server developers.
2014-03-24 (first published: 2009-11-10)
525 reads
Privacy and Data
Much of the data collected by companies is being sold for profit. This data isn't treated well and while not much may change, perhaps we should be aware of how we handle data as professionals.
2014-03-20
108 reads
Virtual Lab – New Domain User
This is part of my series on building a virtual lab for use with SQL Server and Windows. You can...
2014-03-20
1,080 reads
Speaking About Unstructured Data at SQL Saturday #287 – Madison
I haven’t been to Wisconsin in a long time. Not since I was a little kid, going to visit family....
2014-03-18
818 reads
Getting Started with Azure
Many people have been unsure of cloud computing and what it means for your particular application. Steve Jones notes there's a great new demo that can help you get started exploring the Azure offerings.
2014-03-17
172 reads
How Many Passwords?
How many passwords do you have? Steve Jones has a lot and while he notes there are some new ways for us to authorize ourselves for servers, they aren't necessarily making things more secure or less complex.
2014-03-17
142 reads
Squeezing the DBA
What do you do as a DBA if you get asked to cook the books? With the economy doing poorly, some executives will be tempted to mis-report earnings and they might ask the technical people to help. Steve Jones has a few thoughts.
2014-03-14 (first published: 2009-09-03)
344 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