Tag Archives: Microsoft SQL Server
-
SELECT FORMAT(COUNT(1),’N’) FROM TableName WITH (NOLOCK);
9December 26, 2023 by Kenneth Fisher
Alternate title: How do I tell how far I am on that command? This little command (frequently with a WHERE …
Continue reading -
Can you take a differential backup of master?
2December 19, 2023 by Kenneth Fisher
In one of the sessions I attended during the Pass Data Community Summit the speaker asked “If master is in …
Continue reading -
Making Extended Events a bit more usable : T-SQL Tuesday #166
1September 14, 2023 by Kenneth Fisher
Running a bit late this month for T-SQL Tuesday (it’s not exactly Tuesday is it!) but that’s Grant Fritchey’s (blog|twitter) …
Continue reading -
SQL Homework – September 2023 – Time for temporal tables.
1September 5, 2023 by Kenneth Fisher
Recently I needed to use temporal tables. And not just for the job history table in a managed instance. In …
Continue reading -
Windows Hello may cause a “SSPI Context” error
2August 22, 2023 by Kenneth Fisher
I’m going to start out by saying I don’t know a tremendous amount about this subject. I’ll tell you what …
Continue reading -
What’s in a SQL Server Managed Instance?
Leave a commentAugust 3, 2023 by Kenneth Fisher
My current position involves a lot of work with SQL Server Managed Instances so you’ll probably be hearing a lot …
Continue reading -
SQL Homework – August 2023 – Have the best practices changed while you weren’t looking?
17August 1, 2023 by Kenneth Fisher
It’s been a bit since I did one of these so let’s go back to the basics. Best practices. We …
Continue reading -
db_ddladmin Jr.
1July 20, 2023 by Kenneth Fisher
A while back I talked about the fact that you can grant someone CREATE PROCEDURE and ALTER on a schema …
Continue reading -
How do I tell if a user is orphaned or actually created without a login?
5July 18, 2023 by Kenneth Fisher
One of the wonderful things about blogging is the ability to make notes for future me. Which is basically what …
Continue reading -
SQL Homework – December 2022 – What’s new in SQL Server?
Leave a commentDecember 1, 2022 by Kenneth Fisher
SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still got a while before retirement. I …
Continue reading
SQL Studies 