Daily Coping 6 Feb 2023
SQLServerCentral Blog
by Steve Jones - SSC Editor
5h ago
Today’s coping tip is to get back in contact with an old friend. This is something I don’t do too often, but I have done a few times. I’ve met a lot of great people in my life. Some I worked with, some I encountered in other parts of life. When I go to the UK, I usually see if I can reach out and get the chance to meet someone I know from there for a meal or drink. Which reminds me, I need to reach out to someone and try to make plans for June. Around here, I’ve met some really interesting people as a part of coaching. I took time recently to go watch a few kids play that I coached in the past ..read more
Visit website
Rotating a Certificate Used by TDE
SQLServerCentral Blog
by Matthew McGiffen
11h ago
In terms of encryption, Key Rotation is the process of replacing your encryption keys on a periodic basis. This is considered good practice and is required by many security certifications. In practice, if you had to rotate/replace the key that is used to encrypt your data then that would be an intensive activity requiring all … The post Rotating a Certificate Used by TDE appeared first on SQLServerCentral ..read more
Visit website
Daily Coping 3 Feb 2023
SQLServerCentral Blog
by Steve Jones - SSC Editor
3d ago
Today’s coping tip is to ask other people about things they’ve enjoyed recently I asked the question on Twitter and on Facebook, looking for interesting responses from friends. The more fun ones: Got a dog (love this!) tabletop gaming cooking a meal with a kid (love the kids around the kitchen) woodworking bought running shoes (I can relate) For me, I think a couple quiet dinners out with my wife were very enjoyable. I cook a lot at home, and we often have our kids with us. Date nights have been rare lately, so these were nice. I started to add a daily coping tip to the SQL Server Central ne ..read more
Visit website
Why Managed Identities are Awesome
SQLServerCentral Blog
by Koen Verbeeck
3d ago
For the first workdays of this new year, I had the pleasurable task of resetting a bunch of passwords. The passwords belong to Azure AD users, service principals, SQL Server users etc. and all of these are tied into the ETL process of a data warehouse. Some are used to connect to source data, others to connect to the Power BI REST API and some are used in Power BI to connect to the data warehouse. The reason I had to reset all these passwords was because of the LastPass breach (we use LastPass to store our passwords). Even though there were no actual passwords stolen, our IT Security Officer s ..read more
Visit website
Daily Coping 2 Feb 2023
SQLServerCentral Blog
by Steve Jones - SSC Editor
4d ago
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m struggling with some negative thoughts outside of work. This year as I coach older girls, they have many other interests, they’re distracted, less committed, less motivated. Not all, but enough that it’s tough to build cohesion and makes the job of a coach harder. The upside is that it’s an opportunity for me to learn how I might approach things differently. I’m not sure what to do here, but I recognize there’s an upside, even as I’m unsure and frustrated, even a little down. I started to add a daily coping tip t ..read more
Visit website
Goal Progress for Jan 2023
SQLServerCentral Blog
by Steve Jones - SSC Editor
5d ago
The grade for January is a D. Details below, but just not making a lot of progress in these areas. I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. Reviewing Goals The various sections are listed below, and I’m giving a SMART grade based on what I listed. Have I gotten much done. January wasn’t too busy for me at work, but a little busy outside of work with coaching ramping up and my wife being down from work for a few weeks. I got a bit done, but not a lot. Reading Two books on the list: marketing and coaching. I haven’t picked a marketing b ..read more
Visit website
Deadline for Microsoft MVP contributions is 20 March 2023
SQLServerCentral Blog
by Randolph West
5d ago
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31 March each year to provide the list of their annual contributions. For 2023, the deadline has been brought forward to 20 March 2023. If you always leave it to the last minute, know that the last minute is almost two weeks… Read More »Deadline for Microsoft MVP contributions is 20 March 2023 The post Deadline for Microsoft MVP contributions is 20 March 2023 appeared first on SQLServerCentral ..read more
Visit website
Introducing… Data On Rails!
SQLServerCentral Blog
by DataOnWheels
5d ago
Data On Rails is a Data On Wheels project designed to give a platform for up and coming data professionals in the data community. This project is the brainchild of Steve and Kristyna Hughes with the intent to support members of the data community who are excited to contribute but not sure where to start. Data On Rails is intended to be a launchpad for people’s brand and community involvement. Our goal is to see the next generation of data professionals and data community leaders accelerate their industry presence. Our goal is to see the next generation of data professionals and data communit ..read more
Visit website
Context Info Across Databases–#SQLNewBlogger
SQLServerCentral Blog
by Steve Jones - SSC Editor
5d ago
Does Context Info work across databases? This post shows it does. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Here are some hints to get started. The Demo Someone asked the question, would a trigger in another database see context info from a different database. I thought it should work, but decided to test it. Here I’m going to create a table and trigger in database compare2. This is looking for a context value. USE compare2GOCREATE TABLE TriggerTest (myid INT, mychar CHAR(1))GOCREATE TRIGGER tri_triggertest ON ..read more
Visit website
Tempdb Performance Improvements in SQL Server 2022 are Dramatic
SQLServerCentral Blog
by SQLEspresso
5d ago
Tempdb is always a topic for me whether it’s in my sessions or blogs I have written. However, I’ve never been so excited about it then I am when it comes to the dramatic performance changes introduced in SQL Server 2022. THEY HAVE SOLVED ONE OF OUR BIGGEST PERFORMANCE BOTTLE NECKS, System page latch concurrency. In SQL Server 2019 they addressed what’s known as metadata contention, when pages that belong to systems object take page latches while updating tables that track table metadata by introducing memory optimized tempdb. Additionally, the product team made improvements to object allocatio ..read more
Visit website

Follow SQLServerCentral Blog on Feedspot

Continue with Google
OR