[Video] Office Hours with a Surprise Special Guest
I have a special guest star on today’s episode: Pinal Dave dropped by the house! We went through a few of the top-voted questions from https://pollgab.com/room/brento. 00:00 Start 00:15 What happened to you? Did you spend too much time in the sun …
[Video] Office Hours at the Northernmost Town in the World
Despite its location, Hammerfest, Norway attracts countless tourists eager to see the festival celebrating one of the world’s favorite rappers. Did I get that right? I’m not sure I got that right. There’s also fierce competition for t …
Parsing a Pairs of Values in a String While Preserving Order
Introduction In a project I’m currently working on, I need to modify a stored procedure that returns a list of items based on criteria set by the procedure parameters. The new requirement is as follows: the stored procedure must be able to retrieve the …
Well, I’m Not Doing SQLBits After All.
I was so excited when SQLBits announced their 2024 dates & location, and I told y’all that I was blocking out my calendar and I’d be there. Unfortunately, not gonna happen. This year, SQLBits dramatically cut payments for speakers. We u …
PostgreSQL Indexes: What They Are and How They Help
In the previous blog in this series, we learned how to produce, read and interpret execution plans. We learned that an execution plan provides information about access methods, which PostgreSQL use to select records from a database. Specifically, we ob …
Alternatives To SQL Server 2022 Built-in function GREATEST
The post Alternatives To SQL Server 2022 Built-in function GREATEST appeared first on SQLServerCentral.
SQL Athena Introduction – How it works, Use Cases and Advantages
The post SQL Athena Introduction – How it works, Use Cases and Advantages appeared first on SQLServerCentral.
The Basics of Using GENERATE_SERIES()
First, SQL Server 2022 has many interesting new features for both DBAs and database developers. GENERATE_SERIES is one of the new additions, and will likely please a lot of database developers and administrators. This function allows us to create a tab …
Using SQLite with Flutter
Storing, retrieving, and modifying data are common tasks in many applications. In a cross-platform application, it is important to have a lightweight storage mechanism, as opposed to a heavy database software. This article explores how to use SQLite in …
Power BI Workspace Permissions and Roles
The post Power BI Workspace Permissions and Roles appeared first on SQLServerCentral.
Different Ways to Populate the List of Tables
A database administrator has various tasks and responsibilities. Managing and keeping track of the database is one of them. Whether you are new or an experienced database administrator, you must know how to get the list of tables because of following …
First Normal Form Gets No Respect
Dr. Codd first described the relational model in a paper in Communications of the ACM (CACM 13 No 6; June 1970). Some more work followed up after that by other people, giving us normal forms and other things we have taken for granted for 50+ years. …
[Video] Office Hours at the Arctic Circle
Just after passing the Arctic Circle marker and celebrating with a glass of champagne, I took your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:13 TheEveryDayDBA: Does it matter on what column y …
Fabric: My Content compilation
Microsoft Fabric was first announced during Microsoft BUILD. Since then, I’m publishing content about Microsoft Fabric, creating an interesting sequence of content. In this blog, I’m summarizing the content I published about Fabric, helping …
[Video] Office Hours Off the Coast of Norway
Come join me in my cabin aboard the Hurtigruten Nordlys, sailing up the coast of Norway, and we’ll cover your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered today: 00:00 Start 00:57 Accidental DBA: What are …