Guidance on Moving Off of SQL Server 2008 and 2008 R2
July 9, 2019 will be here soon. With it comes the end of support, including security updates for SQL Server 2008 and SQL Server 2008 R2 unless you either...
2019-06-21
53 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Why Security Through Obscurity Is Bad (Alone)
Security through (by) obscurity is where we try to protect an asset by hiding it. Anyone who has ever played the game Capture the Flag knows that a motivated...
2019-06-21 (first published: 2019-06-05)
396 reads
Amazon’s Concept of Ownership and Technical Debt
I’m reading Think Like Amazon: 50 1/2 Ideas to Become a Digital Leader. In talking about Amazon’s pursuit of a second headquarters, John Rossman wrote the following regarding ownership: Amazon’s second leadership...
2019-06-12
381 reads
#tsql2sday – A Letter to My 20 Year-Old Self
Self, I am writing this to you in my mid 40s. I know when I was 20, I wasn’t thinking about 30, much less 40. Here’s some advice I’d...
2019-06-11
38 reads
Building Your Brand Right
I was interviewed yesterday by Stephen Wynkoop (twitter) for the upcoming SSWUG Virtual Conference on May 23rd. One of the questions was about how to keep management engaged on...
2019-06-07 (first published: 2019-05-21)
481 reads
Mitre’s ATT&CK Security Framework
Mitre’s ATT&CK security framework was mentioned often at the Techno Security and Digital Forensics Conference. I admit that I’m not well-versed on it, yet. However, its purpose makes sense....
2019-06-07
55 reads
Sysinternals – A Swiss Army Knife for IT Pros
I’m at the Techno Security and Digital Forensics conference in Myrtle Beach again this year. I sat in on a presentation about performing malware analysis. The analyst began with...
2019-06-06
451 reads
Security Controls: CISA vs. CISSP
When looking at the Certified Information Systems Auditor (CISA) exam, we focus on teaching 3 types of controls: Preventative – keeps an incident from occurring Detective – Identifies the...
2019-06-04
304 reads
Mini-Rant: Spoofed Phone Numbers and Trust
I’ve seen this more and more over the last year: I receive a phone call with a number that indicates it’s coming from a town or city near me....
2019-05-24
191 reads
Same Webcast, New Name: Introduction to Auditing Features in SQL Server
I’m giving another webcast through MSSQLTips.com. This one is on May 9, 2019, at 3 PM EDT. It’s called Introduction to Auditing Features in SQL Server. We renamed it...
2019-05-07
24 reads
Blogs
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers