Password-less Authentication for Azure AD Guest Accounts with Azure SQL DB with Access Tokens
Learn how we can generate tokens that will give access to resources inside Azure without actually adding new users to your domain.
2019-07-01
2,629 reads
Security
Spread the Word about Basic Security
This week we have a few back to the basics security comments from Steve.
2019-06-25
411 reads
2019-06-18
911 reads
Segments for Protection
Computer network security is important, and it's something we ought to be more concerned with as data professionals.
2019-06-18
275 reads
2019-06-12
860 reads
2019-06-04
913 reads
High Prices for High Security
I was excited to see the new Secure Enclave technology come to Always Encrypted (AE) in SQL Server 2019. I've thought that the way Microsoft implemented the AE technology in SQL Server 2016 was a start and a good step forward, but it had too many restrictions. Kind of like Availability Groups in 2012 and […]
2019-05-30
412 reads
Long Live All Passwords
Steve talks about passwords and new guidance from Microsoft that short expiration periods are unnecessary and unhelpful.
2019-05-29
321 reads
2019-05-28
920 reads
Google bots shut down Baltimore officials’ ransomware workaround Gmail accounts
Google automatically suspended accounts after dete...
2019-05-24
Blogs
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
Forums
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers