database-tools

Parsing DISM Log File

PowerShell 2.0 and later In your Windows folder, you find all kinds of system log files. One is DISM.log which contains information about the...

Setting Active Directory Attributes

ActiveDirectory Module To set AD attributes for a user account, PowerShell uses hash tables. That’s a versatile approach that lets you specify...

Adhoc Database Monitoring Made Easy

There are times when you need to get adhoc monitoring information from your databases. Well, now you can! with Embarcadero's DBArtisan Analyst...

Removing AD Group Members

Module ActiveDirectory To remove one or many users from an Active Directory group, try this approach: $user = @() $user += Get-ADUser -Filter { Name...

Steps to Configure PowerShell (Part 3)

All PowerShell versions If you use PowerShell at home or in an environment without central group policy management, here are some additional steps...

Steps to Configure PowerShell (Part 2)

PowerShell 2.0 and later If you use PowerShell at home or in an unmanaged environment, here are some additional steps you should consider to make...

Achieving Data Modeling Nirvana

Data Modeling has forever been a realm of a segment of folks that are immersed into the nitty gritty of Database Architecture from a model to...

Steps to Configure PowerShell (Part 1)

PowerShell 2.0 and later If you use PowerShell at home or in an unmanaged environment, here are some steps you should consider to make PowerShell...

Did you choose to be a DBA?

We have had this survey question and a few others on the community for a few months and thought we would share some of the results. This was a brief...

NULL Values in Arrays

All PowerShell versions Whenever you assign NULL values to array elements, they will count as array elements, but will not be output (after all,...

Randomize Lists of Numbers

All PowerShell versions This line will take a list of numbers and randomize their order: Get-Random -InputObject 1, 2, 3, 5, 8, 13 -Count...

Reading Disks and Partitions

Windows 8.1 / Server 2012 R2 Disk management has been greatly simplified with the many new client and server cmdlets that ship with Windows 8.1 and...

Finding Out Windows Version

All PowerShell Versions Do you own Windows 8.1 Basic, Pro, or Enterprise? Finding out the Windows version is easy. Finding out the exact subtype is...

Join-Path Fails with Nonexistent Drives

All Versions To construct path names from parent folders and files, you may have been using Join-Path. This cmdlet takes care of the correct number...

SQL Server Data Modeling Made Easy

Microsoft SQL Server is slowly beginning to become the preferred platform for most organization big and small. So it would make sense in building...