The recording for my presentation on Building a Proper SQL Server DB Security Model is now available. It’s right at an hour long and in it I present a...
2021-03-18 (first published: 2021-03-15)
311 reads
Tomorrow, March 9, 2020, at 3 PM EST, I will be giving a presentation on how to build a database security model in SQL Server. We’ll primarily focus on...
2021-03-08
45 reads
Through high school and college, I carried deep wounds due to what was going on at home. Only a handful of people outside of my family knew what what...
2021-01-29 (first published: 2021-01-20)
367 reads
Dum Spiro Spero – “While I breathe, I hope.” Because it’s the motto for South Carolina, it’s on the state seal. As a result, it is part of The...
2020-09-23
13 reads
Reading Steve Jones’ posts about daily coping and seeing how it has affected me in a positive way, I’ve decided to share some of the things I’ve done to...
2020-08-14 (first published: 2020-07-30)
279 reads
Tomorrow, June 11, 2020, at 3 PM Eastern I’m giving a webcast on the Principles of Data Modeling. Sign up link: https://www.mssqltips.com/sql-server-webcast-signup/?id=822 Here’s what we’ll be covering: You’ve been...
2020-06-10
35 reads
First, a true story: I was a senior in high school, applying for college. One of the colleges I applied for was the Naval Academy. As part of the...
2020-06-08 (first published: 2020-05-22)
324 reads
I’ve done a follow-on to my webinar with Kevin Kline on Learning from Data Breaches. Here we’ll talk about some specific technologies that come out of the box with...
2020-05-12
17 reads
Back in January I gave a presentation to a small group of folks on foundational SQL Server security items. The last thing I covered was the concept of ownership...
2020-04-21
16 reads
Recently I partnered up with Kevin Kline (SentryOne blog | twitter) and SentryOne to record a webinar on learning from data breaches. We start by talking about Mitre’s ATT&CK...
2020-04-13
5 reads
By Steve Jones
It’s actually my month to host T-SQL Tuesday, and I came up with the...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Windows Subsystem for Linux is probably my favourite feature of Windows 10. It gives...
SEO & Mobile Responsive, Domain, Hosting. 3 Months Free Maintenance. Offer Limited. Call Now....
Hi all! I want to create a stored procedure that returns a result based...
Potentially dumb question. There is 1 x ldf & 1 x mdf for DB1. ...
Ask SSC