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
189 reads
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
189 reads
In this article, learn how to control access levels to various data and parts of Power BI reports using row-level security as well as column and object-level security.
2024-01-09 (first published: 2023-06-19)
2023-05-29
302 reads
Steve notes that password expiration is important for SQL Logins, but he knows this isn't always configured when logins are created, or checked later to see if it is still enabled.
2023-05-27
418 reads
This article looks at four security best practices for protecting databases in AWS along with how GuardDuty can be used to provide additional security.
2023-05-17
1,246 reads
The way the public thinks about security issues isn't always accurate, but we have to accept that and learn to respond in a professional manner.
2023-05-03
116 reads
This article looks at security mechanisms in the cloud that can help protect your data, with specific examples in AWS.
2023-04-14
1,313 reads
Not only is the security of our organization important, but that of our partners matters as well.
2023-03-08
131 reads
Stale data from Microsoft has led to many systems being more vulnerable than they should have been. There's no excuse for this, from Microsoft or our own organizations.
2023-03-01
113 reads
2023-02-06 (first published: 2023-02-01)
873 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers