Identify SQL Accounts Without Password Policy Enforced
When ‘Enforce Password Policy’ for SQL Server logins is turned off, you can make your password anything you want! Hooray!...
2017-03-02
464 reads
Loading to Azure from On-Prem SSIS
In my introduction to the topic of using SSIS in the cloud, I noted that SSIS is not currently available...
2017-03-02
427 reads
Step By Step Logshipping configuration
Log shipping provides a means to maintain a secondary server on an automated basisusing a chain of transaction log backups. This chapter explains the basic confi guration oflog shipping...
2017-03-02
16 reads
Step By Step Logshipping configuration
Log shipping provides a means to maintain a secondary server on an automated basis
using a chain of transaction log backups....
2017-03-02
21,689 reads
SQL Server Permissions – Database Roles
A fundamental component of SQL Server is the security layer. This article covers three common security misconfigurations in SQL Server.
Related Posts:
When Too Much is Not a Good Thing December...
2017-03-02
81 reads
SQL Server Permissions – Database Roles
EZ PZ Permission Squeezee
Given the critical level of importance related to permissions, one may think it is a concept that...
2017-03-02
1,453 reads
Random Blog Post Challenge
OK, for no particular reason at all or maybe because I had too much food at lunch or just because...
2017-03-02
396 reads
The Psychology of Value
J.C. Penney is one of the oldest and most storied retailers still in existence in the United States. For years,...
2017-03-02
381 reads
Tempdb settings in SQL Server 2016
A nice little error log feature that I noticed in SQL Server 2016 regarding tempdb. Tempdb, a system database in...
2017-03-02
415 reads
Do you need a degree to be DBA?
This question gets asked a lot and reoccurs over the years. Do you need a degree to be DBA? I have seen...
2017-03-02
434 reads
Blogs
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers