Protected: SQLSaturday #86 in Tampa–Tomorrow!
This post is password protected. To view it please enter your password below:
Password:
2011-11-04
391 reads
Blog Posts
SQL Tribal Knowledge
Ever felt like trying your hand at writing? November is National Novel Writing Month (or NaNoWriMo for our savvy readers). ...
2011-11-04
530 reads
SQLSaturday #86 in Tampa–Tomorrow!
With a little bit of luck I’ll be arriving in Orlando today around 9 am as I return from SQLConnections...
2011-11-04
532 reads
SQLSaturday #96 in DC - 11/5/2011
Coming to the Capitol, tomorrow Saturday, November 5, 2011 is SQLSaturday#96 in Washington, D.C.! This great event down in DC,...
2011-11-04
885 reads
Things I Favorited on Twitter (a weekly wrapup, of sorts)
Each Friday on @Midnight">DBAs@Midnight (my live weekly webshow, 11pm CST at webshow.MidnightDBA.com!) I don’t feel like I have enough time...
2011-11-04
934 reads
What is SQL PASS?
A few weeks ago I asked a colleague, who is a DBA, if he was going to the SQL PASS...
2011-11-04
1,117 reads
Why I'm Running For The PASS Board Of Directors
If you read this week's onnector email you may have noticed that I'm one of the six candidates who have...
2011-11-04
821 reads
Why SQL Server is using so LESS memory
Today I want to talk about a phenomenon regarding memory management in SQL Server.
A few weeks ago I had a...
2011-11-04
7,207 reads
An Attempt to Make SSIS Package Deployment More Reasonable
Full disclosure: There might be a better way to do this. I am not aware of it.
Problems:
Maintaining multiple DB environments...
2011-11-03
1,469 reads
Another Color Wheel
Some time ago, I had the opportunity to work on a problem involving the color wheel. The requirements for that problem lent themselves to a solution involving bitwise operations...
2011-11-03
5 reads
Blogs
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...
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...
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