How to Perform Database Hack-Attach

This blog demonstrates attaching a database on the SQL Server Instance which already has the same name database up and...

I’ve gotten a transaction log full error but when I look it’s not full??

Every now and again I’ll get an error telling me a transaction log is full. This can be for any...

Is this command broken? I can't see some properties! - DefaultDisplayPropertySet, Get-Member and Select-Object *

Every now and again I see some people complaining about not getting the properties they want when using a PowerShell command.
For instance, someone was using the Get-Service command to...

Power BI Custom Visuals Class (Module 100 – Flow Map)

In this module you will learn how to use the Flow Map. The Flow Map is useful for tracking direction...

Presentation Tools

Let’s face it, the core of a presentation is you. Your knowledge and your ability to share that knowledge through...

Webinar: 6 Principles of the GDPR and SQL Provision

On April 24, I’ll be hosting a webinar that talks about the GDPR and how you can help ensure compliance...

GUID or Integer Primary Key?

If you are designing a new data model or maybe you are looking to improve an...

Checking Tempdb with dbatools

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...

Easy to use WMI commands to query windows system

WMI has been around for a while and it has grown significantly over the years. With Microsoft's focus on powershell,...

GDPR, Database Backups, and the Right to be Forgotten

I’ve said it before, but it bears repeating, there is no cause for any kind of panic when it comes...