Can You Catch SQL Injection?
Steve found an attack against Google's SQL database that their SREs detected.
2020-09-03
232 reads
Security
Better Government Security Through DevOps
DevOps can help provide better security for your databases.
2020-08-26
111 reads
Recover database encrypted modules code with dbatools
If you own a database with encrypted modules but you don't have a decrypted version, this can be a horror story.
Learn how to get back the code of the encrypted modules using dbatools.
2020-08-18
3,075 reads
Attacks on Unsecured Databases
Unsecured databases are a problem, but someone is fighting this issue by wiping them out.
2020-08-11
214 reads
A Data Attack
A ransomware attack takes down Garmin, not just the company, but also Steve's data. He has a few thoughts about what this might mean for our data.
2020-08-10
181 reads
2020-08-06
243 reads
Hacking the Admin
A Twitter hack brings into the question of who can make changes in production for Steve.
2020-07-22
484 reads
Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules
Being able to get information and save it on a Excel as a report can be a common and tedious task. What if we could join dbatools and ImportExcel PorwerShell modules to accomplish this in a easier and fast way? We will see how to export roles and its' member and save that info on a multi spreadsheet Excel file with handy tables ready to be explored.
2020-06-30
7,161 reads
Jumping Air Gaps
There are all sorts of viruses, worms, and malware out in the world, and some of us have had to deal with them at different points in our career. SQL Slammer was particularly memorable for me, but there were plenty of non data related virus issues I've had to work on at various employers. To […]
2020-05-27
233 reads
Defending Against Ransomware
Many more companies that you have heard about have been attacked by ransomware. Steve suggests you get prepared before this happens to you.
2020-05-12
226 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