Attacks on Unsecured Databases
Unsecured databases are a problem, but someone is fighting this issue by wiping them out.
2020-08-11
186 reads
Security
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
160 reads
2020-08-06
210 reads
Hacking the Admin
A Twitter hack brings into the question of who can make changes in production for Steve.
2020-07-22
440 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
6,526 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
195 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
194 reads
Remote Data Challenges
While working remotely, we still need good security practices and strong data protection.
2020-05-06
193 reads
A Security Regression
Marriott has had another security breach. Does this mean they aren't taking security seriously? Steve has a few thoughts.
2020-04-30
107 reads
2020-04-23
164 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
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
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
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