Script to grant a SQL a user read-only access to all the databases in Server instance except the system databases and
-- the Log shipped databases(if any : secondary :read-only)
2017-11-22 (first published: 2017-11-14)
22,990 reads
In this article we will show some common roles and queries related to Azure SQL Data Warehouse.
2017-07-25
5,028 reads
2017-03-30 (first published: 2017-03-16)
12,749 reads
2017-03-09
984 reads
This article outlines five SQL Server capabilities you can use to enhance your efficiency as a DBA.
2017-01-18
3,755 reads
2017-01-06
1,091 reads
Microsoft has introduced very impressive new security feature in SQL Server 2016 called Dynamic Data Masking (DDM).Dynamic Data Masking allow user to decide how much of the sensitive data to reveal with minimal impact on the application layer.
2017-01-05
4,952 reads
2016-12-13
889 reads
2016-12-07
1,061 reads
2016-11-14 (first published: 2016-11-06)
654 reads
By Steve Jones
This month we have an interesting invite. Erik Darling is the host, and since...
By Chris Yates
In the bustling world of sports, leadership appears as a beacon of hope and...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Is it possible to write a script that checks a subscriber's environment for prerequisites...
I have the following...anyone can point me the right direction to rewrite this code?...
I yesterday dowload a sqlexpress and intalled on one of a testing database for...
When I create a user in a SQL Server 2022 database, on which types of logins in the master database can it be based?
See possible answers