2016-01-26
1,428 reads
2016-01-26
1,428 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,676 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,850 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
Understanding how permissions work in Microsoft Fabric can be essential for anyone managing access...
By Kevin3NF
Does skipping a DBA save money? Wait until your system grinds to a halt,...
By Brian Kelley
I admit that until I read the article, Who are you as a Leader?,...
I am in the process of migrating from MySQL to SQL Server. I have...
I have the following select statement --#1 Select supplier, s.refnum, desc from supplier as...
Good morning to all. I am a novice when it comes to SQL so...
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL , @value2 VARCHAR(20) = NULL; SELECT COALESCE (@value, @value2, 100.5) AS Result; GOSee possible answers