Joined March 2017
10 Photos and videos
24 May 2022
Bonehead question of the day. If you restored a DB to an AWS RDS MSSQL instance (test) and accidently delete the admin login from that database. Is there any hope of getting access back to that database or is it a nuke the RDS moment? #AWS #SQLHelp #YesitsTest
2
25 May 2022
We have a solution! If you reset\change the password on the Admin user in RDS AWS console, it re-associates with all of the user databases on the RDS instance. Big props to @DbaShand !!! I owe you a drink at Re:Invent 2022
3
17 Mar 2022
SQL On AWS question: We moved an on-prem test VM to an AWS EC2 (L&S) and immediately our RESTORE DATABASE times went through the roof. DB restores that took 45-60 minutes now taking 13-14 hours. Can anyone explain that to me and how to get it back to normal? #sqlHelp #AWS
2
12 Feb 2022
Once again defending my db systems honor and innocence. Is there any script, tool, log, etc that can tell me if a query attempted and failed to execute successfully against my SQL Server database? #sqlHelp
3
12 Feb 2022
Context: Application tanked hard this afternoon, App team claims the DB isn't responding but I can verify session connection, tested user login creds, executed in SSMS SPs as user would through application. ms return times...I'm at a loss and on edge.
2
17 Dec 2021
This non-sense needs to stop. #ItsNotFunny #DeleteTikTok
11 Nov 2021
Current Rank #11 of 17736 on the PASS Ribbon leaderboard! How the heck does someone have over 600 points on Day 2 of the conference though? #didyousleep #PASSDataCommunitySummit
10 Nov 2021
Loving spending the day in and out of virtual sessions at #PASSDataCommunitySummit 2021!
1
10 Nov 2021
"If you want to go fast, go alone. If you want to go far, go together." - Rohan Kumar I love this quote. #PassDataCommunitySummit
2
14 Oct 2021
So today my alma mater, officially announced it's merger with two other schools in Western PA. The new name for the university, that combined three schools with over 300 combined years of existence. Pennsylvania Western University or PennWest. My school is now a utility company.
29 Sep 2021
Does anyone have a way to extract all of the RDL files from a ReportServer database? I have a legacy (2008 SSRS instance without a viable SC option, and need the RDLs. TIA #sqlhelp #ssrshelp
1
6 Aug 2021
Just want to rant here for a second... This is what I am spending my evening trying to solve, because a decision to use a product that supposedly can't handle calling stored procedures and wants views. Stored Procedure returns cleanly in seconds by the way.... END RANT
25 Jun 2021
Well...that happened.... Now comes the interesting part.
24 Jun 2021
I was today years old when... I realized I was actually an accidental network and server admin, and responsible for doing everyone else's job!!!
1
24 Jun 2021
@Kevin3NF I almost called you guys back in today, but I can't seem to punch out these networking issues.
24 Jun 2021
Is it possible for a server to have an "identity" crisis? I have a server that is refusing to acknowledge it's membership in a WSFC from one node and is successfully acknowledging memberships from two other nodes. This is driving me nuts!
24 May 2021
PDMI is hiring! We have several Data \ BI \ Dev positions posted now and more opening soon. Come be a part of our growth! Check out our careers page for more info and to apply! ow.ly/FrMm50Es1Nd #teampdmi #joinourteam #nowhiring #SQLServer #AWS

8 Apr 2021
Is it safe to assume Developer and Enterprise edition are the same when it comes to patch \ update testing for SQL Server? Can we safely assume that if we setup an AG using Dev edition and apply the services packs\updates\etc it will behave similarly to EE? #sqlhelp
1
6 Apr 2021
Can a SQL Server Availability Group be extended (async) from an on-prem WSFC configuration to include a Linux based SQL Server instance on AWS EC2? Trying to extend our on-prem clusters to the cloud for read-only workloads. #sqlhelp
1
1
1