SQLSERVER-DBA.com Blog

Windows Folder Permissions With Powershell Get-ACL

2017-05-07 11:23

Windows folder permissions report using Powershell Get-ACL is required by the Operations Team. They need to be able to pick any Windows folder and report on the permssions . The equivalent a… Read More

Powerhsell Get-ChildItem Folders Only

2017-05-02 14:10

Question: When I’m using Powershell Get-ChildItem I get a recordset to get all files in directory. It also returns all the folders in the currrent directory. I’d like to be able… Read More

Read SQL Server Error Logs With Powershell And SMO

2017-05-01 10:31

SQL Server troubleshooting and SQL Server problem analysis usually results in a DBA reading the SQL Server Error Logs and other error logs , such as Windows Events Logs. The… Read More

Ultimate Psychology Guide - MEMORY

2017-04-30 16:11

Psychology plays a large part in daily life. Having a basic understanding of why you behave in a certain way - can give you great power in fixing behaviour that you think is working against… Read More

Powershell Monitor Log File For String With Select-string And Regex

2017-04-25 15:13

Question: I am trying to monitor a log file – used by a third party software. It is a text file where results are dumped if a file transfer is successful. I want to use a powershell sc… Read More

Powershell Get-childitem And Date Modified

2017-04-19 14:24

Question: I can list out the files of a directory using Powershell get-childitem , but how can I display the Windows sdirectory “date modified” column as part of the recordset re… Read More

How To Write To A Sql Error To Windows Server Event Viewer

2017-04-18 16:04

Over the last few versions SQL Server has improved greatly on writing sql server error messages . A good example is writing to both SQL Server Error Log and the windows serv… Read More

SQL Server 100 Cpu Diagnose

2017-04-17 08:31

Question: Users are reporting long delays in query responses. I checked on the server and noticed CPU counter at 100 % on Performance Monitor. There are 4 cores associated to this serve… Read More

Script To Check If A SQL Database Has A Backup

2017-04-15 08:12

Not being able to get data back from the backup system , is one of the more embarrassing moments for a DBA. Vigilance needs to be maintained to ensure that what i… Read More

With Great Ignorance Comes Great Confidence

2017-04-14 16:44

I saw this cartoon in the New Yorker. Take the DBA Ignorance , complacency and arrogance experiment Read More

Powershell Script To Check Disk Space On Remote Servers

2017-04-12 16:36

Question: I need a powershell script to return drive letter , drive capacity , drive used and free space for a remote server on the network. Rather than checking on the Windows G… Read More

Configurations Eating Up Sql Server Performance

2017-04-11 11:06

Question: I’m setting up a best practises document for our SQL Server builds and would like to focus on some configurations which fit in with sql server tuning best practises, What are… Read More

Sqlserver-dba.com Blog

Share the post

Subscribe to Sqlserver-dba.com

Thank you for your subscription