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
Tonight is going so well ... Vendor keeps saying cxconsumer is a wait. Send coffee #endrant
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"
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.
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
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
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.
Dan White retweeted
i wish solarwinds would do the decent thing and sell sentryone assets to someone who is interested in developing them further.
Dan White retweeted
SSMS 19 is released: techcommunity.microsoft.com/…
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.
Dan White retweeted
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-…
#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?
#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.
#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).
#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?
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



