How do you solve T-SQL problems?
It's good to have a methodology for solving problems, and T-SQL is no exception to this. Steve Jones notes that all too often we look at solving a problem, but only doing half the job.
2013-05-21
426 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
Connecting to AdventureWorks on Azure
A quick guide for connecting to our free copy of AdventureWorks on the Azure platform.
2013-05-20
12,182 reads
Getting Information from a Database using Dynamic SQL
I ran across someone that was building a restore script to automated their restores. This person wanted their script to...
2013-05-20
955 reads
Morphing Microsoft
Is Microsoft trying to move away from just being a software vendor? It seems they'd like to and that's a goal, but are they moving in the right direction? Steve Jones has a few ideas to help them.
2013-05-20
131 reads
Powershell for DBAs
Powershell is a great tool for helping you work with multiple instances of SQL Server. This week Steve Jones talks about how and why you might want to get started.
2013-05-20
515 reads
Software Design and Schizophrenic Windows 8 Part 2
I know it’s not schizophrenic, but that sounds better. It’s really a split personality.
I wrote recently about Windows 8 and...
2013-05-17
1,164 reads
Honeywords in SQL Server
There's an idea of using false passwords with real accounts, honeywords, that can help us detect security issues with our servers. Is that worth implementing in SQL Server?
2013-05-16
203 reads
Not My Google Reader Replacement
Someone suggested Newsblur to me, and I went to their home page. Like many sites, it asks you to sign...
2013-05-15
819 reads
The Challenger
There is plenty of competition in the database platform space for SQL Server. There's a new NuSQL platform, whose vendor hopes will replace SQL Server as the platform of choice in the cloud. However Steve Jones isn't sure this will be the case.
2013-05-15
191 reads
Webinar: Forgotten Rings and Other Monitoring Stories
In this session, Grant Fritchey, Microsoft MVP, drills down into a few of the more obscure monitoring metrics that can give you very precise information about exactly what's happening within your server. He'll also show you how you can use custom metrics to enable these metrics in Red Gate's SQL Monitor.
2013-05-15
190 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...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
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