2016-01-26
1,429 reads
2016-01-26
1,429 reads
2015-12-28
1,142 reads
2015-12-24
1,647 reads
It's 15 years after the beginning of the century. Time to eliminate the security exposure of SQL logins, and implement integrated security. Active Directory Groups make this easy for the DBA.
2018-02-02 (first published: 2015-12-21)
9,681 reads
This article details SMKs, DMKs and certificates in SQL Server as they relate to Transparent Data Encryption and Encrypted Backups.
2015-12-09
4,858 reads
2015-08-18
1,392 reads
A vulnerability has been released that can affect SQL Server 2008, 208 R2, 2012, and 2014.
2015-07-15
5,811 reads
Consider a situation when you have a large number of databases on your SQL Server, and you are requested to grant user access to all SQL Server databases. How can you grant access to a user for all databases on a SQL Server instance?
2015-06-30
5,795 reads
2015-05-29
1,372 reads
2015-05-21
1,251 reads
We value your privacy. This policy explains what personal data we collect and why. What...
This came up one day at my work when a developer was using it....
I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...
I have a list of transactions in a table. Each transaction has a unique...
I spotted this in the release notes for CU17 in SQL Server 2022: KB3616559...
I migrated DB server from 2017 enterprise to 2019 enterprise. After the migration, every...
I have a SQL Server instance that is not listening for connections on port 1433. By default, all ports are locked down on my server, except for the SQL Server port. What can I do to allow users to connect to the instance without knowing the port?
See possible answers