iOS v Android–A Short Term Update
I ordered my first new new phone this year. I’ve never purchased a new, unreleased model of a cell phone...
2013-08-23 (first published: 2013-08-16)
2,562 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 Costs of Data
Information is free, but data certainly has a cost. Especially as there are real costs to storing and managing large volumes of bits and bytes.
2013-08-22
127 reads
Always Abstract
When developing your code, should you use views? There are reasons why you might choose to do so, or not do so, however Steve Jones thinks you should consider abstracting your systems.
2013-08-21
165 reads
Better Searching on Google
One of the keys to being a successful technologist is being able to search for information. Google has a lot...
2013-08-21
977 reads
The Podcast is in the Windows Store
If you’ve got a Windows Phone, or any of the Windows devices that support podcasts, the Voice of the DBA...
2013-08-21
1,317 reads
Guidance
When you are looking to help someone improve performance on a system, there isn't a single set of steps you provide. The advice and guidance you provide will vary, depending on the situation.
2013-08-20
117 reads
Restoring a TDE Database on a New Instance
You’ve enabled Transparent Data Encryption (TDE) on one of your databases, and the server has failed. How do you get...
2013-08-19
1,082 reads
Disaster Recovery Docs–Offsite
Years ago I worked at an ISO certified organization, where we took our administration and planning seriously. We ensured everything...
2013-08-16 (first published: 2013-08-08)
2,312 reads
Should He Stay or Should He Go?
Read the first page of the linked article and then cast your vote in this Friday's poll.
2013-08-16 (first published: 2008-09-26)
552 reads
Who Wants to Be Rich?
With all the concern over the economy lately, Steve Jones talks about about finances and tries to bring perspective to those of us in the real world.
2013-08-15 (first published: 2008-10-20)
407 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
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...
Forums
Alamat BCA KCU Mojokerto ??/Wa (0817)839777
Kontak Cs: 0817839777 Jl. HOS. Cokro Aminoto No.5, Mergelo, Jagalan, Kec. Magersari, Kota Mojokerto,...
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...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
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