[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 …
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 …
[Video] Office Hours in Kyoto, Japan
My Asian vacation continues in Kyoto, the City of a Thousand Temples. They’re not playing around – the town is chock full of gorgeous historic temples, and it was tough to pick a scene for today’s Office Hours. Let’s go through …
Convert Excel Workbooks to CSV with Microsoft Fabric
The post Convert Excel Workbooks to CSV with Microsoft Fabric appeared first on SQLServerCentral.
The Ebb and Flow of AI
It’s the end of the year. Everybody’s coasting and looking back. Let’s kick our heels up, get comfortable, and talk big picture industry stuff. You and me, our weirdo jobs involve: Databases – which is already unusual, and most …
Frappe’s Configuration vs Laravel’s Code-Centric Customisation
This article compares the Frappe and the Laravel frameworks, focusing on key technical differences in customization, database management, and API development. While Laravel’s popularity lies in its code-centric approach to web development, Frappe simpl …
Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.
Introduction In SQL Server, the transaction log file is essential for keeping your database reliable and durable. It tracks every change and transaction, which is crucial for recovering data if something goes wrong. Unfortunately, there are times when …