Server vs Instance. A rant.
It’s a SQL Server Instance not a SQL Server. The product is SQL Server. The installed copy is an Instance. ... Continue reading
2021-07-29
351 reads
SQLStudies
Speaking: In person vs webinars vs recordings
I don’t speak all that often. A few times a year for the most part. Because of that I don’t ... Continue reading
2021-07-27
29 reads
How do I unlock a SQL Server Login using T-SQL (without changing the password)?
We recently had an application login (SQL Server authenticated) in one of our training environments start locking out on a ... Continue reading
2021-08-09 (first published: 2021-07-22)
811 reads
Experiment: If I have Dynamic Data Masking enabled will BCP pull the non masked data.
Hypothesis: If I have Dynamic Data Masking enabled on a column then when I use something like BCP to pull ... Continue reading
2021-07-20
28 reads
Padding a string in SQL Server
I’ve been working on converting a piece of DB2 code into T-SQL and one of the functions I had to ... Continue reading
2021-08-02 (first published: 2021-07-15)
422 reads
Interview with the Amazing Kellyn Pot’Vin-Gorman
Thanks for agreeing to do this Kellyn. I’ve always found you to be one of the more interesting personalities in ... Continue reading
2021-07-23 (first published: 2021-07-08)
258 reads
The SQL Server community and the rising tide (and all that).
I was speaking with one of my favorite people in the SQL Server community, Grant Fritchey (blog|twitter), on twitter today. ... Continue reading
2021-07-06
103 reads
SQL Homework – July 2021 – Log shipping
Log shipping is probably the least complicated and easiest to configure of the various methods of creating a secondary copy ... Continue reading
2021-07-01
44 reads
Another reason I prefer side-by-side SQL Server instance upgrades.
This is a quick non-technical discussion (i.e. not a how to in any way) of some of the benefits of ... Continue reading
2021-07-16 (first published: 2021-06-29)
690 reads
DDL Trigger to log database level security commands.
In my last post I talked about reasons why your permissions might go missing. One of the reasons, and in ... Continue reading
2021-07-05 (first published: 2021-06-24)
239 reads
Blogs
Audit – Security Compliance Frameworks (Part 1)
By Vinay Thakur
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Forums
SQL 2025 SSMS Nonsense
Yeah, I know this is a 2022 forum, but I don't see a 2025...
PowerBI Question - Data Sources
I don't see a PowerBI forum, so I'm posting here. I have a need...
SQL Server Certificates
Comments posted to this topic are about the item SQL Server Certificates
Question of the Day
SQL Server Certificates
Which of these is not true for certificates used for SQL Server connections?
See possible answers