[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 …
New Flyway Course on Redgate University
The post New Flyway Course on Redgate University appeared first on SQLServerCentral.
An Introduction to SQL Triggers
The post An Introduction to SQL Triggers appeared first on SQLServerCentral.
Amazon RDS – Configuring a Connection to a SQL Server Instance
Introduction In a previous article, we explored the factors worth considering when deploying a database in the public cloud. We also created a SQL Server RDS instance on Amazon Web Services. In this article we shall demonstrate how to connect to this n …