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 …
Backing Up MySQL Part 2: Percona XtraBackup
There’s no doubt about it – if you’ve ever heard of Percona, you’ve heard of XtraBackup as well. XtraBackup is one of the primary Percona’s offerings in the backup space: the tool is famous amongst DBAs as one of the prima …
SQL Server 2022 Release Date: November 16, 2022
Microsoft released SQL Server 2022 today, November 16, 2022. The footnotes indicate: SQL Server 2022 free editions (Developer edition, Express edition) are available to download starting today. SQL Server 2022 paid editions (Enterprise edition, Standar …
Join #TeamHugo and Help Fight Leukemia.
If you’ve been reading this blog for a while or subscribed to my email newsletters, you’ve learned something from Hugo Kornelis. Hugo is the wildly productive and selfless guy behind the Execution Plan Reference, SQLServerFast.com, tons of …
#PASSdataCommunitySummit Keynote Day 1 Live Blog
I’m in Seattle for the biggest annual gathering of Microsoft data platform professionals, the PASS Data Community Summit. This is the first in-person Summit since the pandemic, and the first since Redgate took over ownership from the old PASS org …
Flyway Enterprise is here…
The post Flyway Enterprise is here… appeared first on SQLServerCentral.
SQL LIKE Statement for Various Text Patterns
The post SQL LIKE Statement for Various Text Patterns appeared first on SQLServerCentral.
How monitoring tools can help you excel at your job
The post How monitoring tools can help you excel at your job appeared first on SQLServerCentral.