Author Archives: Robert Matthew Cook

no more blogging at this site as I begin learning the ropes as a new postgresql dba. cheers!

Today would have been my sister’s 43rd birthday. I love you Tammy!

There is an illness in the family which has been the focus of my time.

Wednesday Weekly #sqlserver Links  Grab a plate and load it up. Current Feed Content Tagged as [ADMIN] SQL Server Database SUSPECT state – SQL Server DBA According to BOL , a database in SUSPECT state is : “At least the … Continue reading →

Joining If you have experience with joining the military then thank you sir or ma’am but as a SQL Server DBA you are sure to have experience with joining tables using Transact-SQL. My first blog post was on this exact … Continue reading →

Wednesday Weekly #sqlserver Links  Help yourself to this link feast. Current Feed Content Tagged as [ADMIN] Less Than Dot – Blog – Tips and Tricks to Make SQL Server Management Studio Awesome Webpage without description Semicolon Not terminating T-SQL statements … Continue reading →

Wednesday Weekly #sqlserver Links  Here are some yummy links from this week. Current Feed Content Tagged as [ADMIN] SQL University: Architecture for Small Businesses | The SQL UPDATE Statement This post covers general architecture advice for small businesses (SMB) looking … Continue reading →

Wednesday Weekly #sqlserver Links  Biggest SQL Server feast to date so be sure to come back for seconds. Current Feed Content Tagged as [ADMIN] How to prevent blocking in your SQL Server database | James Serra’s Blog Different solutions to … Continue reading →

T-SQL Tuesday Robert Pearl has heeded the call of hosting the T-SQL Tuesday blog party this month. Please click on the #tsql2day image above to learn more about why the topic is “data-presentation”. If you want to read more party-style … Continue reading →

Get-ChildItem -path “C:\getdeepestfolder\top1alphabetical\” -recurse | Sort-Object -property @{Expression={[regex]::matches($_.FullName, “\\”).count}; Ascending=$false} | Select-Object -property “FullName” -first 1