SQL Server Blog

role-based access control

Role-based Access Control In SQL Server, and You

This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the month of June. Visit our sp_CheckSecurity page to learn about our free SQL Server tool you can download and run to check your own server. Role-Based … Read more

What securityadmin Role Members Can and Cannot Do

This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the month of June. Visit our sp_CheckSecurity page to learn about our free SQL Server tool you can download and run to check your own server. Based … Read more

CONTROL SERVER Permissions Are the Hidden SQL Server Superpower [30 SQL Server Security Checks in 30 Days]

This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the month of June. Visit our sp_CheckSecurity page to learn about our free SQL Server tool you can download and run to check your own server. The … Read more

Your Biggest SQL Server Security Vulnerability Is Your sysadmin Role Members [30 SQL Server Security Checks in 30 Days]

This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the month of June. Visit our sp_CheckSecurity page to learn about our free SQL Server tool you can download and run to check your own server. It … Read more
free sql server dba tool sp_CheckSecurity

SQL Server Tool Update: sp_CheckSecurity version 1.1

Since releasing our initial version of sp_CheckSecurity, we have received quite a bit of feedback. Thank you for all the emails, blog comments, and issues noted in GitHub, that have all been helpful in directing us towards making this SQL Server tool more useful. Today we are announcing the release of version 1.1, available for download … Read more

How to Troubleshoot SQL Server With PowerShell.

PowerShell is an essential tool for SQL Server database administrators looking to streamline their workflow and automate repetitive tasks. When it comes to troubleshooting your SQL Server instances, PowerShell is an essential tool for the DBA toolbox. As a versatile scripting language and command-line shell, PowerShell enables seamless integration of commands, arguments, variables, and modules … Read more
free sql server dba tool sp_CheckSecurity

Introducing sp_CheckSecurity

Are your SQL Servers secure? With new threats to your data emerging daily, it’s a difficult question to answer. And what is even included in the word “secure”? Sure, maybe you’re confident you have security against hacking (or maybe not?), but what about internal security? Are you protected against oops moments? Are there elevated permissions … Read more
sql server consultancy core values guiding principles

Building a Consultancy: More Principles

A couple of weeks ago, I started blogging about part of the journey of creating our SQL Server Consulting firm. I may someday work on more posts on the journey from full-time DBA to doing some side work to leaving with an “anchor client” to going off on my own (and my adventures with Linchpin … Read more
sql server consultancy core values guiding principles

Building a SQL Server Consultancy

Principles and Values First In 2011, I set out to be an independent SQL Server consultant. At the time, if you told me I’d be looking back 13 years later as a “CEO” with a team of 15+ FTEs I would have laughed at you, I think. But it happened. I’ve been reflecting back on … Read more

Subscribe for Updates

Name

2 thoughts on “SQL Server Blog”

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.