What Is Good Database Design?
The post What Is Good Database Design? appeared first on SQLServerCentral.
SQL Server Security Primer
SQL Server security structure, mechanisms and methods are very thoroughly documented in the Microsoft documentation, but it is quite daunting if you don’t already know about the functionality. I recently had a request to explain some security fea …
The SQL Developer Experience: Beyond RDBMS
SQL Server has always empowered developers through a wide variety of drivers, the robust T-SQL language, and an industry proven database engine with security, performance, and availability. Some developers though are not aware of the SQL Server and Azu …
Integrating Python with MongoDB
Introduction MongoDB has gained significant popularity as a NoSQL database solution due to its flexibility, scalability, and document-oriented nature. Python, on the other hand, is a versatile programming language known for its ease of use and rich eco …
New Microsoft Sandbox Uses Natural Language LLMs for SQL Queries
The post New Microsoft Sandbox Uses Natural Language LLMs for SQL Queries appeared first on SQLServerCentral.
A Beginners Guide To MySQL Replication Part 6: Security Considerations in MySQL Replication
This article is part of Aisha Bukar’s 6 part series: A Beginners Guide to MySQL Replication. The entries include: Part 1: Introduction to MySQL Replication Part 2: Configuring Source and Replicas Part 3: Multi-Source Replication Part 4: Using GTID Base …
[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 …