Job History – Back to Basics
An important part of any DBAs job is to ensure database related jobs are running prim and proper. Sometimes that just doesn't happen. When jobs are being overlooked, it...
2019-06-20
8 reads
Blog Posts
Just a Week to SQL Sat Pensacola
One of my favorite events, in a wonderful place to spend the weekend. I’ve been to Pensacola a few times (3?), including a couple times with my daughter. It’s...
2019-06-20
39 reads
Undercover Catalogue 0.2 Hox Fix 2 and SQL2008r2/2008/possibly 2005 Compatibility Patch RELEASED
Undercover Catalogue 0.2.2 It looks like a bug has crept it’s way into the Undercover Catalogue. When running with certain versions of DBA Tools, a number of the modules...
2019-06-20
14 reads
dbatools v1.0? It’s available – Check it out!
Dear reader, before continue please open a PowerShell console and run the following command: If you are doing this on the date of this blog post, you have just...
2019-06-19
61 reads
dbatools v1.0? It's available - Check it out!
Dear reader, before continue please open a PowerShell console and run the following command:
Install-Module -Name dbatools If you are doing this on the date of this blog post, you...
2019-06-19
2 reads
How do I force a SQL Login to change it’s password on next login
Forcing someone to change their password on a periodic basis is a pretty common thing, and any time I’ve gotten ... Continue reading
2019-06-19 (first published: 2019-06-05)
559 reads
Powershell script to find new servers in an AD domain
This is actually part of a process I am creating to automatically discover SQL Server instances in an Active Directory domain. So there...
2019-06-19 (first published: 2019-06-06)
1,344 reads
What is a container anyway?
Recently there was a thread on Twitter which established that a lot of IT people didn’t know the difference between virtual machines and containers. |???????|| CONTAINERS || ARE NOT...
2019-06-19
135 reads
What permissions do temp stored procedures use?
In a performance tuning class I recently took with Brent Ozar (b/t) he mentioned temporary stored procedures and an interesting ... Continue reading
2019-06-19
105 reads
Achieving application consistent recovery points of SQL Server 2008 R2 with Azure Site Recovery in Azure
If you want to use ASR to replicate SQL Server 2008 R2 standalone or clustered instances, you will need to update the SQL Writer to 2012 or later. You...
2019-06-18
134 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers