After some recent talks with security folks and auditors, one of the things I have had a hard time getting across is that you must trust those folks responsible for account and server management when it comes to securing your data. Yes, you can put in...
2009-02-26
2,549 reads
This question comes up a lot in the forums: "How do I know if the login owns any objects?" Usually...
2009-02-24
7,400 reads
Today, Microsoft release a security advisory about a new vulnerability in Microsoft Excel. This one affects both PCs and Macs....
2009-02-24
1,801 reads
Yesterday I blogged about how to figure out what database principals corresponded to what server principals. The key is to...
2009-02-23
1,859 reads
All of the videos I've done are up under my profile. However, the video for The difference between GRANT, DENY...
2009-02-23
1,492 reads
A question on the forum asked how to find all the database mappings for a particular login. If you're on SQL...
2009-02-22
9,729 reads
When the Kindle 2 was first announced, I debated about whether or not to get it. Then I realized I...
2009-02-21
1,365 reads
There is an active attack in the wild for the newly announced Adobe Acrobat and Adobe Reader vulnerability. While the...
2009-02-20
2,063 reads
After some recent talks with security folks and auditors, one of the things I have had a hard time getting across...
2009-02-20
3,074 reads
This is a follow-on post to You Must Trust Someone. My point in that post was to establish that being...
2009-02-20
1,944 reads
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
I’m giving two online sessions soon on virtual events that are free to attend....
Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...
i have subscription of github copilot which i can access in vs 2022 comunity...
Comments posted to this topic are about the item Password Guidance
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers