SqlServer Engineer | fmr SJSSUG Organizer | Occasional Speaker | Drummer | WRFH799 | Kayaker | Cyclist | Paintballer-D1nppl7m | Stockton Alum

Berlin, NJ
Joined September 2009
Consider this your daily reminder to make sure you're not playing in production ... was in dev looking to remove unused system generated statistics on a 25k table db to run downa theory. Somewhere along the line, I grabbed a new window in prod. Whoops. The secondary was not happy
1
31
Tonight is going so well ... Vendor keeps saying cxconsumer is a wait. Send coffee #endrant
1
2
47
Had a vendor say to me when I suggested they add rcsi to help with a current issue ... "but we run Nolock on everything so we're fine"
1
28
There's some chatter about starting up the south jersey sql server chapter (SJSSUG) again but concern about speakers. Is there a good place to start besides just posting here on #sqlfamily? More details to come. Reach out to me if interested.
9
1
5
1,463
There's some chatter about starting up the south jersey sql server chapter again but concern about speakers. Is there a good place to start besides just posting here? More details to come
33
Ever have one of those moments where you kick yourself for incompetence? I spun my wheels for 3 days on a dynamic sql issue. I was missing the parenthesis. Yup, feel like an idiot now
19
I was proud to report in our daily incident meeting that yesterday [due to reasons outside my control] a report in dev had gone awry and I wrote a kill loop, in a loop. It tickled my maniacal genius buds but was successful at killing the process.
1
36
i wish solarwinds would do the decent thing and sell sentryone assets to someone who is interested in developing them further.
9
6
59
5,530
How can anyone afford a home right now? mortgage rate are just ridiculous ... coupled with anything available being either a crack house or a million dollars.
This news makes me very happy. Can’t help but think of my friends who are @WaltDisneyCo fans @SQLHA @datachick @JoshLuedeman @AndrewNathan05 deadline.com/2022/11/disney-…
3
1
9
#sqlhelp. I recall a way to make a database a "system database" .. am I wrong or can I not find the command/alter? Don't want to get into the why
I know I don't post alot but following the trend to counter.social ... I'm there too now same name and username
#sqlhelp I am trying to find a way to hide specific databases from public users. I know how to hide them all, but not just show certain ones. Ideas?
1
#sqlhelp is there an easy way to create all of the agent replacement tokens? Not sure how but jr on my team built a sql box not following our standards ... I find out its in prod after. None of them exist.
1
#sqlhelp Is there any downside or danger to creating a database master key? The server in question doesn't have one and service broker is saying it needs one (error 28054,11,1).
1
Why must my @DoorDash order always be wrong from @Wawa? I'd say it's a 90% failure rate of something missing or not made to order. Yes I can get a refund of partial purchase but now I have to reorder it, pay extra fees and tip.
2
#sqlfamily we're finally starting to look at monitoring/management tools after pausing 2 years ago. SentryOne was the top of our list then. Since solarwinds acquired, has the product changed much? Is it still a top product in the category?
1
I am loving @dbatools again this morning. Had scheduled steps for an upgrade that I wasn't sure I'd be available to run. Scheduled my steps and it just handled it all in 4 simple commands
Do I have a right to be mad at a vendor who did nothing on a support ticket for 10 days, then on the 11th day replied and said as of the day prior, that product is no longer in support and we need to upgrade? Please contact professional services.
2