SQLBif Gets A Job - SQLCommunity Redeemed...
Back in May, I had a conversation with a sql friend in the community, and well, my friend (who I...
2012-06-26
1,445 reads
Blog Posts
Want to lose #20PoundsBeforeTheSummit? Join the #GetHawt competition!
We here in the IT community are clearly concerned about our weight. More specifically, we’re concerned about our weight going...
2012-06-26
967 reads
X-XMLA: v. Creating XMLA Script from Visual Studio and Deploy the Database
This will be the easiest entry in this series. This is a reblog of an article I wrote last year....
2012-06-26
1,177 reads
Almost an MCSA
I took four beta tests earlier this year for SQL Server 2012. I had debated writing another book, and I’ve...
2012-06-25
1,286 reads
And the results are in…..SQL Server 2012 beta exams
Well after being a bit late in trying to book the beta exams I managed to get three of the...
2012-06-25
950 reads
Goals – The end of one year, start of another
Just about a year ago, I talked about the importance of setting goals for yourself, both personally and professionally, making...
2012-06-25
1,027 reads
How to use a multidimensional cube with Power View
The requirements for Power View state that it can only use tabular models as data sources. So if you want to...
2012-06-25
2,316 reads
I’m speaking at the PASS Summit 2012
The PASS Summit 2012 schedule has been released, and I’m proud to announce that I’ve been selected to present a...
2012-06-25
683 reads
It’s that time of year…..Exceptional DBA Awards 2012
Being a 2011 finalist I felt I should try and rally all those who truly are exceptional to get their...
2012-06-25
785 reads
Join me at the PASS Summit
It seems just yesterday that we were all in Seattle together, getting a crash course in what’s new and exciting...
2012-06-25
640 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