Use SSMS with a Different Windows Account – Back to Basics
Runas should be a very common tool in the toolbox of all IT professionals - not just Data Professionals. Learning how to test different accounts is essential to being...
2018-06-28
276 reads
Blog Posts
File Growth Rate – The GUI Lies
If you are like me, you use the SSMS GUI for various things. Though, I tend to use scripts for...
2018-06-27 (first published: 2018-06-15)
1,176 reads
Revoke the permission(s) before dropping the server principal
As a remote DBA I often have to log in to client systems for a fixed amount of time and...
2018-06-27 (first published: 2018-06-15)
13,977 reads
Tools to connect to a SQL database
Today I'm getting back to basics, whether you are new or veteran with the database engine you need a tool...
2018-06-27
1,519 reads
Update your production servers and stop making excuses about it
Folks, we all like to make sure we’re doing our level best to make things work smoothly. So why am...
2018-06-27
368 reads
Azure SQL DB – Login failed for user NT AUTHORITY\ANONYMOUS LOGON.
Now that I have your attention with a powerful title how about some context? It is quite common to get...
2018-06-26 (first published: 2018-06-15)
2,304 reads
Filtering Tables, Procedures, And Other Objects In SSMS
Watch this week's video on YouTube
While the text of this post contains good information on SSMS object filters, I highly recommend watching this week's video on YouTube - I...
2018-06-26
11 reads
Filtering Tables, Procedures, And Other Objects In SSMS
Watch this week's video on YouTube
While the text of this post contains good information on SSMS object filters, I highly recommend watching this week's video on YouTube - I...
2018-06-26
6 reads
Login Failed – Token-based server access validation failed for SQL Server
Login failures are a common item to troubleshoot with SQL Server. Out of all of the possible log failure reasons...
2018-06-26
197 reads
Power BI Custom Visuals Class (Module 107 – Advance Card)
In this module you will learn how to use the Advance Card. The Advance Card is similar to the native...
2018-06-26 (first published: 2018-06-12)
2,821 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
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