SQL Server at Scale – Using an Archive Table – Part 2
The post SQL Server at Scale – Using an Archive Table – Part 2 appeared first on SQLServerCentral.
The Curious Case of… community
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some t …
Backing Up MySQL Part 5: Backing Up Big Data
According to research made by Statista in 2022, the amount of data that is being worked with globally is expected to reach more than 180 zettabytes. Part of that is because more and more data is being introduced to the online world – but another …
[Video] Office Hours: Black Friday Edition
My Black Friday sale is in its last days, so most of my time at the moment is spent keeping an eye on the site and answering customer questions. I’m happy to say it’s our best year so far, too! Y’all really like the new access-for-lif …
Express.js or Next.js for your Backend Project
Backend projects create projects to execute code on a centralized server and then communicate results with a client. These kinds of projects are executed efficiently with Express.js, and the number of web developers who use this framework is increasing …
Is Azure SQL Database a Good Choice for your Database Applications?
The post Is Azure SQL Database a Good Choice for your Database Applications? appeared first on SQLServerCentral.
Why bother automating?
The post Why bother automating? appeared first on SQLServerCentral.
Contest: Guess the Next SQL Server Release Date
When will Microsoft officially release SQL Server 2023 (or 2024, or whatever it’ll be) for download? The dust is just barely starting to settle on the 2022 box, so it’s time to guess the next one. Leave one – and only one – comment here in …
Migrate Azure Analysis Services to Power BI Premium
Power BI has evolved into the leading platform for both self-service and IT-managed enterprise business intelligence. The decision to migrate to Power BI Premium depends on the requirements of each customer. Customers should carefully evaluate addition …
Using SQL Backup in Development Work
The post Using SQL Backup in Development Work appeared first on SQLServerCentral.
Are You Underpaid? Let’s Find Out: The 7th Annual Data Professional Salary Survey is Open.
Whew. This is a crazy time, isn’t it? The aftermath of the pandemic is kicking in, and there are layoffs happening in Silicon Valley companies, but… the data profession is on fire. I don’t know anyone who’s been out of work for …
Backing up MySQL Part 4: mydumper
There are many tools we can use to back up our MySQL databases. Some are well-known and used by the best technology companies out there (mysqldump comes to mind), and some are a little less famous, but still have their place in the MySQL world. Enter m …
Converting Data Across Time Zones: An In-Depth Primer
If only the entire world used UTC, wouldn’t life be so much easier? We can dream, can’t we? While some software applications can live in an ecosystem where all dates and times can be stored in a single time zone with no conversions needed, …
SQL Server 2022: Azure AD Authentication
SQL Server 2022 is finally GA and one of the features I was most expecting is finally available. It’s the allows Azure AD Authentication. Azure AD users can access SQL Server directly, without a second user account. SQL Server on premises require …
Looking Back at the 2022 #PASSDataCommunitySummit in Seattle
I’m back home in Vegas, back down to Inbox Zero, and I’ve had some time to think about last week’s conference in Seattle. I liveblogged the keynotes, but I wanted to talk about the conference overall. This was Redgate’s first ti …