Why Haven’t You Disabled SA? Wrong Answers Only.
On social media, I asked folks, “Why haven’t you disabled the SA account in your SQL Servers? Wrong answers only.” The results were pretty funny:
2023-12-01
SQL Server security
2023-11-17
378 reads
2023-10-14
93 reads
Removing Weak Security from SQL Server
The password options for BACKUP at deprecated, which Steve thinks is a good thing.
2023-08-25
176 reads
2023-08-02
407 reads
How to Change the SQL Server Database Owner
Discover the importance of database ownership in SQL Server and learn the process of changing database owner using SQL Server Management Studio or ALTER AUTHORIZATION statement
2023-07-31
38,079 reads
2023-07-26
506 reads
2023-07-12
408 reads
2023-06-28
426 reads
Securing All Your Connections
Microsoft is recommending more security for SQL Servers, including dev and test instances. Do you agree this is a good idea? Would you implement this?
2023-06-28
215 reads
Blogs
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Microsoft Purview data governance best practices
By James Serra
Microsoft Purview can be the best data governance tool in the world, but it...
Forums
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
The Data Model Matters
Comments posted to this topic are about the item The Data Model Matters
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers