Microsoft Announces a New Security Program
Microsoft has announced a new security program to help system administrators secure their sites. Worth a read.
2001-10-19
4,120 reads
Security
SQL Server Security Best Practices
Learn how to secure your data by implementing SQL Server security best practices.
2001-09-20
3,675 reads
Using Java to Encrypt Passwords
Lots of applications store user names and passwords in the database. This article presents a method for encypting this information using Java.
2001-07-19
14,950 reads
2001-07-19
2,600 reads
Encrypting Data With the Encrypt Function
One of the major problems in the database field is when people store sensitive data unencrypted into SQL Server. This article shows you one of the most basic ways to encrypt data to the casual viewer.
2007-09-22 (first published: 2001-07-17)
34,083 reads
Security Alerts and Information
A new security alert affecting SQL Server was released on June 12, 2001
2001-06-14
3,620 reads
2001-06-14
5,614 reads
2001-05-25
4,004 reads
Removing NT Administrators as Sysadmins
By default, all NT administrators of the domain that your SQL Server is installed in, have SA rights in every database. This presents interesting challenge for DBAs, political and technical. Does your NT administrator group need SA rights to every database? The answer is no.
2001-05-25
4,074 reads
More About the Fixed Database Roles
This article by Andy Warren provides an introduction to some of the fixed database roles and things to consider when using them.
2001-05-17
4,714 reads
Blogs
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
Forums
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers