Get SQL server database size, location and volume info using DMVs

SELECT * FROM sys.master_files AS f 
CROSS APPLY sys.dm_os_volume_stats(f.database_id, f.file_id) v; 

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,...