#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.
Build Your Own SQL Server Central Monitoring Solution with PowerShell
The post Build Your Own SQL Server Central Monitoring Solution with PowerShell appeared first on SQLServerCentral.
Tutorial to Create a Power BI Report Using PostgreSQL
Introduction The current article will show how to create a Power BI report using PostgreSQL data. This article is for people who need to work with PostgreSQL to create reports in Power BI, but do not have experience in PostgreSQL. If you do not have Po …
Introducing the MySQL DELETE statement
Preparing your MySQL environment As with the previous few articles, I used the same database and tables for the examples in this article (the travel database and the manufacturers and airplanes tables). In this case, however, I recommend that you start …
Office Hours: Read This, Watch This Edition
This week, a lot of the questions you posted at https://pollgab.com/room/brento just need pointers to resources at other places. Welcome to the Read This, Watch This series of answers. Don’t Blame Anthony: Our developers prefer writing TSQL queri …
The Art of Data Ingestion – Part 1
Data movement is a fundamental piece of a data engineer’s duties, and recently I’ve been thinking about the art of data movement. What are some of the most important pieces that a data engineer needs to think about when confronted with data ingestion? …
Refresh a Power BI Dataset using Microsoft Power Automate
The post Refresh a Power BI Dataset using Microsoft Power Automate appeared first on SQLServerCentral.