Renewed as a Friend of Red Gate
I recently received the news that I’ve been renewed as a Friend of Red Gate. I’ve been a big fan of Red Gate since the days when SQL Compare...
2020-02-25
11 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
SheLeadsTech Webinar: Braving the Wilderness of Cybersecurity
ISACA has a SheLeadsTech webinar for tomorrow, February 25, 2020 titled Braving the Wilderness of Cybersecurity. Registration Link: https://www.isaca.org/education/online-events/lms_w022520 If you can’t make the talk, ISACA archives all webinars...
2020-02-24
15 reads
[Cross post] Innovating Yourself as an IS Auditor
This is also posted to the ISACA Journal blog, Practically Speaking: As new technologies are developed, we have to stay up to date with them. More so than almost...
2020-01-08 (first published: 2020-01-02)
226 reads
Azure – BGP Community for Application Insights (Need Votes)
Working with Microsoft, we determined that there is no BGP community for Azure’s Application Insights. As a result, I’ve created a feedback request for Microsoft to consider doing just...
2020-01-08 (first published: 2019-12-30)
114 reads
Personal Goal Accomplished: Speaking at the PASS Summit
I mentioned on twitter that a family tragedy about a decade ago had resulted in a false start with respect to this goal: After a false start about a...
2019-11-07
17 reads
Should I Be Worried About skip-2.0?
A new piece of malware which hooks into SQL Server, skip-2.0, has been making the tech media rounds. If you’ve not read about it yet or you’re looking for...
2019-10-25
68 reads
SQL Server Security: Fixed Database Roles
Brian is back with a new security article, this time working through the details of the fixed database roles. There are some important concepts here. In particular if you're not totally clear on the difference between dbo and db_owner, read this article.
2019-09-18 (first published: 2003-12-12)
64,189 reads
July 2019 – New Microsoft security update for Spectre variant
If you remember the flurry of news from the beginning of 2018 about side channel attacks called Spectre and Meltdown, Microsoft has included in its July update a patch...
2019-08-20 (first published: 2019-08-07)
357 reads
New Security Update for SQL Server in July 2019 Patches
It doesn’t look like this would affect SQL Server 2008 or SQL Server 2008 R2 since the earliest reported platform is SQL Server 2014, but in Microsoft’s release of...
2019-07-17 (first published: 2019-07-09)
1,733 reads
Basic SQL Server Configuration Help for Involuntary DBAs
After my presentation at the Techno Security and Digital Forensics conference, I had a information security professional stop by to ask a few questions. He’s in the position where...
2019-06-24 (first published: 2019-06-10)
1,189 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
Advice I Like: Praise
By Steve Jones
Don’t reserve your kindest praise for a person until their eulogy. Tell them while...
Forums
Is there a way to have dynamic table headers?
Hi everyone I have a SP which compares two tables and outputs mismatching entries:...
Learning a New Language
Comments posted to this topic are about the item Learning a New Language
is there a way to "detect" schema like changes on a server?
Hi, we have a few people who like to experiment on our prod sql...
Question of the Day
Copying Production Schema
If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?
See possible answers