SQL Connectivity issues: A guided walk through
The SQL Tiger Team (t) has recently put out a guided walkthrough for SQL Connectivity issues.
Announcement
Walk Through
If you look...
2017-02-06
423 reads
Kenneth Fisher
My SQL logins don’t work. Again.
My recent post on why SQL logins aren’t working has generated a couple of follow up posts. The first one...
2017-02-02 (first published: 2017-01-25)
2,389 reads
Changing what SSMS opens on startup
When you open SSMS a connection window automatically comes up. Then once you pick your server, connection type, username and...
2017-02-01
785 reads
Azure quick start
In case you hadn’t noticed, I love built in help. DBCC HELP, the script button in SSMS, even BOL. Well...
2017-01-30
684 reads
Creating a connect entry.
I recently wrote a blog about how to tell why your SQL login isn’t working. There were a lot of...
2017-01-30 (first published: 2017-01-23)
1,125 reads
What is COPY_ONLY?
You’ll frequently hear that you should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up...
2017-01-19 (first published: 2017-01-16)
2,549 reads
Lead Blocker
Blocking is just part of life I’m afraid. Because we have locks (and yes we have to have them, and...
2017-01-18
3,136 reads
A detailed view into your Azure resources
I’ve been studying Azure recently and came across a really interesting Azure site.
resources.azure.com
To give you an idea why I find...
2017-01-13 (first published: 2017-01-05)
1,463 reads
Why won’t my SQL Logins work?
I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a...
2017-01-12
813 reads
Connect suggestion to add included columns to sp_helpindex
I’m a big fan of the sp_help system stored procedures, which is why I’ve been a bit disappointed that the...
2017-01-10
462 reads
Blogs
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Forums
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Another Model, More Data Loss
Comments posted to this topic are about the item Another Model, More Data Loss
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers