PCI DSS has strict requirements about implementing security updates and using only applications which are supported by the vendors. How do you create a patching policy for SQL Servers?
2015-01-12
5,700 reads
2014-11-10
1,557 reads
2014-11-07
1,761 reads
Connecting to resources in untrusted domains with windows authentication can be tricky. Here's how to make it easy.
2014-10-06
9,329 reads
Following on from a webcast, Tim Smith answers some questions on SQL Server security like: Is It Better To Mask At the Application Level Or The SQL Server Database Level? Are there any options to find SSNs in SQL Server besides RegEx? And, why would anyone store sensitive data un-encrypted in SQL Server?
2014-10-02
8,457 reads
In this tip Tim Smith looks at different approaches to stop confidential data from getting into the database.
2014-09-22
8,091 reads
Data security? No worries! Tell me how much you are willing to pay.
2014-09-03
142 reads
Last week one of my team members was supposed to create a SQL Authenticated ID on a SQL Server 2005 instance. This was as per the request of the Application team who would be using it for an Application.
2014-08-20 (first published: 2014-08-13)
1,909 reads
Set a security standard across environments that developers can see and run, but not change.
2014-07-30
3,866 reads
CONNECT ANY DATABASE is one of three new permissions in SQL Server 2014 that can be granted to server logins. What is this new permission good for and why would we ever want this?
2014-07-29
15,025 reads
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Comments posted to this topic are about the item Creating JSON II
Comments posted to this topic are about the item Engineer Lessons
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers