Hey #sqlfamily , curious how everybody is doing Ci/CD. I want to do it. I’ve checked in everything in prod into GitHub. I have access to GitHub Actions. But what do people do to get from dev to prod? If I change a table and add a permission, what scripts out the changes from my dev DB? Looks like Sqlpackage and Flyway? If I can’t have the database look like prod (because of extra audit triggers, etc), how should I handle that? Is there a Recommended Best Practice somewhere? #sqlserver

Do you want to give back and feel like you are part of something important?

If so, get involved in your industry's professional community. I'm glad I started attending and speaking at Microsoft SQL Server events. They are great ways to make new friends and find professional and personal support.

I look forward to the privilege of presenting this year, and I know I'll meet new people and reacquaint with people I already know.

#sqlserver
#sqlfamily

Is there any information specifically on the impact of enabling wait stats capture in query store? I'm in a hyper-cautious company and am being asked about this.

Erin Stellato has never mentioned anything about it, and I don't recall it being me tioned in Tracy and Grant's book on query store.

#sqlhelp
#sqlfamily
#sqlserver

Given the current social media landscape, I'm giving Mastodon another try. I'm also looking to see what other social media platforms have sprung up that I might be interested in.

Dear #SQLFamily, I'm looking for a new laptop. Mainly for Power BI and Data Engineering, should be rock solid and long lasting.

Any specific recommendation?

Blog alert!

About my 2024 and a little on 2025. Enjoy the change of calendars!
#SQLFamily #MVPBuzz #Community

http://sqlreitse.com/2024/12/30/2024-in-review-2025-in-preview/

Just a reminder for those looking to take part in this months T-SQL Tuesday and #FestiveTechCalendar crossover that your posts are expected to be published this coming Tuesday.

For those who missed it, the invite for this month is to write about a Microsoft Data Platform announcement that you considered to be as amazing as a present. In other words, something which made you go “wow”.

Further details are in the post for those looking to take part. #tsql2sday #sqlfamily #CloudFamily

https://www.kevinrchant.com/2024/12/03/t-sql-tuesday-181-first-ever-t-sql-tuesday-and-festive-tech-calendar-crossover

I stopped moving. This may have been a mistake. If anyone sees me sleeping in the lobby, please wake me up. #passdatasummit #sqlfamily

Wheels down in Chicago. Off to gate B7 then next stop, #PASSDataSummit and #sqlfamily

We are hiring! We are looking for Database Engineer to help manage our databases and building ETL jobs. https://jobs.elon.edu/jobs/database-engineer-elon-university-campus-north-carolina-united-states #sqlserver #azure #ssis #sqlfamily

Quick thoughts on #sqlsaturday #syracuse this weekend. #sqlfamily https://flxsql.com/2024/09/08/sql-saturday-syracuse-2024-recap/

Only 10 days until #sqlsaturday #syracuse on September 7th! Join me there! Register at https://sqlsaturday.com/2024-09-07-sqlsaturday1095/ #sqlfamily

This problem has been getting the better of me for a while and a snippet of code finally got me over the hump. Shoutout to @HannahVernon for the StackOverflow answer that got me on the right path.

Hey #sqlfamily event organizers,

I finally got around to documenting a Data Platform event organizer process. These are a few things I would have wanted someone to tell me about in 2019.

Feel free to contribute with comments & your own checklist items.

https://github.com/sqlsunday/saturday-checklist

Pagelatch contention has two main causes; tempdb and the hot page issue. My blog at https://www.sqljared.com/blog/page-latch-waits/ provides several possible solutions for the second. #sqlfamily #sqlblog

Spotted at PHL this afternoon and got me wondering if it’s a member of #sqlfamily

Hey, #sqlfamily speakers and event organizers, give me your honest/direct feedback. Is this a useful report for you as a conference speaker?

I'm looking for your thoughts on the report - the presentation/visualization - not the questions.

NB: The data is just dummy/test data.

https://test-feedback.datasatsto.se/presenter-report/10124/fa832a84-79c4-41b8-99dc-36fbaca47c7f

Safe travels to all going to #fabcon #sqlfamily #datafamily!

After about 17 hours home following #mvpsummit time to move again. This time to @SQLBits where I'm volunteering and presenting.
https://sqlbits.com/attend/the-agenda/friday/#Infra_as_code_control_it_from_the_tower

Looking forward to meeting you there!
#mvpbuzz #azure #microsoft #sqlfamily #speaking #community