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 …
Backing up MySQL Part 3: mysqlpump
In the MySQL world, there are a couple of ways to take backups of your data. Backups in MySQL can be categorized into two distinct categories: logical or physical. MySQL also comes with a lot of tools helping us achieve our backup objectives: we have w …
#PASSdataCommunitySummit Keynote Day 3 Live Blog
Today at the PASS Data Community Summit in Seattle, Kimberly Tripp is doing the first-ever in-person community keynote. Here’s the abstract: Over the 30+ years I’ve been working with SQL Server, I’ve seen an incredible amount of innovation and ch …
Try Before You Commit in Flyway
The post Try Before You Commit in Flyway appeared first on SQLServerCentral.
How to get IO statistics of SQL Server database files
SQL Server is a resource-intensive database system that requires adequate CPU and memory capacity to run transactions with acceptable performance. Another resource that can cause poor performance is the storage subsystem. We should carefully plan stora …
#PASSdataCommunitySummit Keynote Day 2 Live Blog
I’m in Seattle for the PASS Data Community Summit, and the day 2 keynote is about to start. This year, now that Redgate owns the Summit event, they’re doing the day 2 keynote. Gotta pay the bills, I suppose! Redgate’s CEO, Jakub Lamik …
SQL Server 2022 Paid Editions Require a Licensing Key.
For the final release of SQL Server 2022, Microsoft popped a surprise that wasn’t in the release candidates: Your choices are: Install a free edition: Evaluation (which times out after 180 days), Developer (which isn’t allowed to be used fo …