Leveraging the “STUFF” Function for Enhanced Data Representation and String Manipulation
Abstract In the realm of data management and business intelligence, effective data representation becomes crucial for deriving actionable insights. This is true specially when dealing with raw data, where inconsistencies and scattered information acros …
Oracle Architecture Overview
I often fall back to the tried-and-true methods to understanding Oracle environments. Yes, sometimes the older ways are best, but understanding where Oracle has been and where it’s going is essential to us building the best products to support this ent …
2024: the year in books
Back in 2009 I started posting a summary at the end of the year of what I read during the year and people have been enjoying it so I did it every year afterward until 2019 and then restarted for 2023 (see 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, …
Five changes to SQL Server I’d love to see
I’ve had lots of wish lists over the years, from Ladybug to Connect to UserVoice, and very few of my dreams ever come true. Still, it’s fun every once in a while, to be whimsical about the way I wished SQL Server worked. Especially in January because, …
[Video] Office Hours in Tokyo, Japan
For the last Office Hours of the year, I’m coming to you from Tokyo, the last stop on my 3-week tour of China and Japan. This was a big Epic Life Quest task for me, for sure, something I’ve wanted to do for decades. Let’s bring you al …
Your Favorite Blog Posts & Videos from 2024
The year is coming to a close, so it’s time to look back on your favorite stuff from this year. 2024 Blog Posts with the Most Comments What’s Your Biggest Database Regret? Query Exercise: Fix This Computed Column Query Exercise: Find the Be …
Simple Talk 2024 Year in Review
Happy New Year to all of the Simple talk readers! What a year this has been. I just read a list of the things we did last year for an internal report, and I wanted to share some of the pertinent stats. This year we went through a project we called “Sim …
Updated First Responder Kit and Consultant Toolkit for December 2024
If there was ever a release you could skip, this is probably the one, because you could count this release’s changes on just one hand! Well, assuming you were an alien with six fingers. I won’t even recap the most important changes – …
GUID in SQL Server
The post GUID in SQL Server appeared first on SQLServerCentral.
How to Attach and Detach Databases in SQL Server
Introduction Managing databases in SQL Server requires a solid understanding of various methods for transferring and maintaining data. One essential process is attaching and detaching databases. This method allows administrators to move database files …
2023 (not a typo!): the year in books
(Yes, this is for last year!) Back in 2009 I started posting a summary at the end of the year of what I read during the year and people have been enjoying it so I did it every year afterward until 2019 (see 2009, 2010, 2011, 2012, 2013, 2014, 2015, 201 …
Introduction to MySQL Shell and Basic Configuration Management (Part 1)
The database is an important part of any application and setting it up correctly is key to ensuring smooth performance. MySQL, an open-source relational database management system (RDBMS), is widely used in applications ranging from small websites to …
Working Today? Take a Break to Fill Out the Annual Salary Survey.
Working today? You’re not alone. As a small business person, I tend to find myself working on emails, catching up with stuff on quiet days like today. Let’s take a second for your professional development though. Every year, I run a salary …
SQL Server Forced Plans Overwite the Query Hash
The post SQL Server Forced Plans Overwite the Query Hash appeared first on SQLServerCentral.
How to Repair Corrupt MySQL Tables
In the modern world, the companies are not solely dependent on a specific database server platform. There are many database platforms available that are adequate to handle moderate workload and client requirements of high availability and disaster reco …