Ben Miller

@drsql @SQLFlipFlopsDBA Dude, hope all goes well.

@SQLFlipFlopsDBA I feel better about my broken hip replacement now. Hope that doesn’t hurt as much as it does to look at it!

Sooo, things not on my 2024 bingo card: the pin in my big toe *breaking* and prying up my big toe nail. Photo in comments, don’t look if you can’t stand toes/feet/blood/ewies.

Hey. In town for a Boston Red Sox game. Time for some downtime after speaking last night at #nesql user group.

@Warwick_Rudd @GFritchey @gt1gt1 @SQLHA Anytime. I am here all week.

@GFritchey @gt1gt1 @DBAduck @SQLHA I need to catch up with you both

I've been fortunate to speak at PASS Summit and still get overwhelmed when I'm around people like @GFritchey , @DBAduck , @SQLHA and @Warwick_Rudd. I picked the right lunch table 😊

@GFritchey @gt1gt1 @SQLHA @Warwick_Rudd Likewise always.

@gt1gt1 @DBAduck @SQLHA @Warwick_Rudd Always good to see you.

Join us at the first annual #MicrosoftFabric Community Conference and see how Microsoft Fabric & the rest of the data and AI products at Microsoft can help your organization prepare for the era of AI. #FabCon #PowerBI aka.ms/fabcon

Night at the theater for Jenny Oaks Baker. Merry Christmas!

@pshore73 40 yard line. Great seats this year.

@DBAduck Looks like you might have OK seats. 😁

Time for some #byucougars football. Go cougs.

You don’t have the time — or resources — to see to all of your data demands. And you shouldn’t have to. Let us handle it so you can fully focus on your business. Book a call: buff.ly/3NOthgE #SQLServer #DataPlatform #DBA #PowerShell #TechConsulting

@SQLInfo #sqlhelp No I am not sure totally why it does this, I am only sure that I have had it happen and have resolved it. Sorry I am not helpful in the cause.

@DBAduck Thank you!! Any ideas on what could have made the DB get into “initializing/ in recovery” state. The dbs were in sync and redo queue was zero before failover. Post failover, the error log said “DB recovery completed” but it was still stuck in this state for over 5 hours #sqlhelp

SQL 2019 AG DB stuck in “initializing/in recovery” state after failover. The DB is in secondary role. The error log said - “recovery completed for database <db name> in 30 seconds” an hour ago but DB still stuck in initializing/recovery state. Any help to recover the DB #sqlhelp

@MJSwart Remember that temporal tables are about the validity dates of the row. So adding values in a column for ValidTo actually has a date of 9999-12-31 and so the scan has to happen to retain consistency for the data. Scanning has to happen for that.

@DBAduck Thanks Ben. The thing I was hoping for was that although it needs the locks, it doesn’t necessarily need to scan (but it does anyway)

#sqlhelp Can I enable temporal tables on an existing table online? dba.stackexchange.com/q/330288/1782?…

@mike_r_edwards SQL Server does not honor the expiration date of the certificate so that you don't run into that problem. Not saying you shouldn't manage certs to not expire. But that you can restore with it. #sqlhelp

1/2 So #SQLHelp. Want to encrypt backups SQL 2022 for 3 node Windows cluster Always On. Worried that means 3 different certs and if a log chain needs to be restored all 3 nodes potentially need all 3 certs if failover happened ie .baks from several. Is there a better way? ...

New post: SQL Server 2019 Cumulative Update 22 glennsqlperformance.com/2023/08/18/sql… #sqlserver #sqlserver2019

DataGrillen has been a leader in new talent generation in the MS data community through the new speaker track. Now it's time for the next wave to break. Become a new speaker at the tastiest MS data event on the planet. (We have excellent mentors) sessionize.com/datagrillen-20…

@jdanton I agree.

Controversial opinion, but Activity Monitor should really be ripped out of SSMS.

@GFritchey @SQLRunr See you there.

On my way to #SQLSatColumbus. Well, first a little entertainment tomorrow. Sadly @SQLRunr is a big meanie and has forced me to check luggage. The monster. Oh, and we'll be playing golf tomorrow. I have practiced my CPR so I can revive Allen after he laughs himself unconscious.

Happy birthday @sqlmal

@burby_geek Sad plight. Sorry.

@DBAduck Powershell is locked down and hard to use. Along with service accounts. Ssms is a lot easier

Just curious my twitter friends. Is SQL PowerShell not interesting to many these days? Am I doing it wrong? Missing something? Bad times I stream? Help me help you. I am live Monday and Tuesday at 4PM Mountain time. But I get 1 attendee on average and no questions are posed.