Planning for Failure
Today Steve Jones reminds us that the small disasters are likely to occur, and that you need to be sure that you're planning for them, and practicing for the recovery that will be needed.
2010-09-30
150 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
Common SQL Server Mistakes – Indexing Every Column
If one index helps speed up queries, than more indexes should help more, right? They do, but they also come...
2010-09-29
4,790 reads
Grabbing SWAG
It’s getting close to the time for the SQLServerCentral party events this fall, and time to start gathering up SWAG...
2010-09-29
1,821 reads
Hot Skills
What are the hot skills for 2011? Steve Jones talks about one that you might not have thought about.
2010-09-28
700 reads
SQL Saturday#52 – Colorado Recap
This past weekend was the first SQL Saturday in Colorado, and it went very well. I think everyone enjoyed it,...
2010-09-28
2,016 reads
Can Wives Shorten Work Hours?
This editorial was originally published on Jun 23, 2005. It is being reprinted today as Steve is on vacation. It talks about the impact of long hours on families.
2010-09-27
263 reads
People are talking about you
I was listening to a friend give a presentation on getting a job recently. In the presentation, Chris Shaw, the...
2010-09-27
968 reads
A day of rest
Not quite a day of rest, likely some chores in advance of another busy weekend at the ranch.
I’m taking today...
2010-09-24
718 reads
Food Drive
Don’t forget the food drive tomorrow for SQL Saturday #52 in Colorado. Please bring food, or even clothing/blankets, that can...
2010-09-24
631 reads
Common SQL Server Mistakes – Multi Row DML Triggers
How often have you seen someone write a DML trigger like this:
createtrigger mytrigger on Mytable forinsertas
declare @id int
select @id = id...
2010-09-23
15,415 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