steve@thesqlguy.com

I am a Microsoft certified SQL Server expert with over 20 years of experience. Creating secure, reliable, and fast data structures is my passion, and I want to share my expertise with you.

I am passionate about sharing my experience with the community, making information available and seamless to the world. Check out my blog and look for my various articles across the internet.

I love an audience. I have experience speaking to dozens or thousands, and I love to share my knowledge and experience. I would be happy to speak at your event with content ranging from very technical to more conceptual and business-friendly.

SQLServerCentral Article

6 steps to a more secure SQL database

Security is often something people think about only after they have had a problem. Given that the average cost of a data breach is $3.92 million (SecurityIntelligence 2019) and ransomware attacks have increased 97% over the past 2 years (PhishMe 2019), the "if it's not broke, don't fix it" approach can clearly be catastrophic. Here […]

5 (2)

You rated this post out of 5. Change rating

2019-10-07

9,324 reads

Blogs

Creating a GitHub Actions Self-Hosted Runner

By

I had to demo the Flyway Autopilot system recently and created a GitHub Actions...

Migrating from Azure PG Single Server to Flex with Azure VM and pg_dump/restore

By

This is more complicated than using the Azure Migration method, but because it’s maxed...

PowerShell (and T-SQL) and Elastic Jobs

By

I’ve covered how to create Elastic Jobs in the portal (this one is important...

Read the latest Blogs

Forums

Contracting DBA - Permissions for initial analysis

By StephenSQL

Accidental DBA here.  After looking at all the work that needs to be done,...

How to convert run_date and run_time columns to datetime from SQL Agent systable

By Lord Slaagh

Hello SSC, Hope you are all having a great Monday! I am trying to...

SQL Server Reporting Services 2022 Permissions Issue

By benkaz

I'm having a bit of an issue with SSRS permissions. Users (Operations Manager Report...

Visit the forum

Question of the Day

AG Rules for Databases

Which of these is not a requirement for a database to be added to an Availability Group (AG)?

See possible answers