2020-01-21
511 reads
Security
Let's Fix a Password Problem
Grant discusses the need for password managers to help prevent security issues between different accounts.
2020-01-15
245 reads
2020-01-14
575 reads
Quick Security Mistakes
Steve reminds you to be careful of taking shortcuts, as these can compromise security. Automation and DevOps might help you avoid mistakes.
2020-01-06
267 reads
2019-12-30
564 reads
2019-12-23
684 reads
Better Protection from Hardware
Today Steve looks at a research project from Microsoft that provides some better protection from firmware security issues.
2019-12-17
129 reads
Querying Master Database DMVs in Azure SQL Database
Learn how you can query information in the logical server's master database from an Azure SQL Database.
2019-12-12
1,338 reads
Data for Defense
The Microsoft Threat Intelligence Center actively works to track the world's hackers and help warn us when we become the object of their attacks.
2019-12-09
155 reads
2019-12-06
681 reads
Blogs
Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)
Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...
ANSI_WARNINGS = OFF can break update statements with some SQL features
By Will Assaf
Working on a SQL 2017 database where an external, non-Microsoft application has direct access...
Bring Your Own Key to Azure SQL Database Managed Instance TDE
Last year Azure SQL Database Managed Instance saw the introduction of bring your own...
Forums
How to update status with conflict data where chemical temp table have same chem
How to update status with conflict data where chemical temp table have same chemical...
Blob to ADF to Stored proecure
I'm reading file from BLOB through ADF and I would like to pass the...
RTO 15 minutes with differential backups
Hi. I'm working through the official exam reference book for 70-764 by Isakov and...
Ask SSC