The Best Security for Database Administrators
Today Steve talks about limiting security issues for administrators.
2020-09-08
157 reads
Today Steve talks about limiting security issues for administrators.
2020-09-08
157 reads
Steve found an attack against Google's SQL database that their SREs detected.
2020-09-03
194 reads
DevOps can help provide better security for your databases.
2020-08-26
68 reads
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
2,089 reads
Unsecured databases are a problem, but someone is fighting this issue by wiping them out.
2020-08-11
164 reads
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
155 reads
2020-08-06
69 reads
A Twitter hack brings into the question of who can make changes in production for Steve.
2020-07-22
253 reads
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
4,145 reads
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
73 reads
Statistics objects are important for allowing the SQL Server Optimizer to make good estimates...
By DataOnWheels
Saving the Day from Delay Part 2 Creating DateKey and TimeKey columns can be...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
We're having a very peculiar problem with the "Maximum stored procedure, function, trigger, or...
1. What is the difference among nested loop?hash join and merge join? 2. what...