Has Everyone Had a Data Breach?
Not only is the security of our organization important, but that of our partners matters as well.
2023-03-08
154 reads
Security
Stale Data Causes Security Issues
Stale data from Microsoft has led to many systems being more vulnerable than they should have been. There's no excuse for this, from Microsoft or our own organizations.
2023-03-01
141 reads
2023-02-06 (first published: 2023-02-01)
922 reads
The Home Password Cracker
Passwords cracked in under an hour using modern hardware have Steve shaking his head.
2022-10-22
454 reads
2022-10-21
2022-09-12
560 reads
How to use fn_builtin_permissions SQL Server Security Function
Learn how to find all securable objects in SQL Server and the permissions for each securable object using the system function fn_builtin_permissions.
2022-08-31
Reducing Debt and Increasing Security
DevOps is often thought of as bringing more features to customers, but it can also help security.
2022-08-15
171 reads
SQL Server vs Oracle: Data Masking
In this article, we look at how to mask/hide data for users using Dynamic Data Masking in SQL Server and Data Redaction in Oracle
2022-08-08
How to grant PowerBI Service Workspace access using PowerShell
Learn how to more easily manage permissions in the Power BI service using PowerShell.
2022-06-06
3,360 reads
Blogs
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers