Security Update for SQL Server 2022 RTM CU8
The Security Update for SQL Server 2022 RTM CU8 is now available for download at the Microsoft Download […]
Archives du mois : octobre 2023
Security Update for SQL Server 2019 RTM CU22
The Security Update for SQL Server 2019 RTM CU22 is now available for download at the Microsoft Download […]
Security Update for SQL Server 2019 RTM GDR
The Security Update for SQL Server 2019 RTM GDR is now available for download at the Microsoft Download […]
Security Update for SQL Server 2017 RTM GDR
The Security Update for SQL Server 2017 RTM GDR is now available for download at the Microsoft Download […]
[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 […]
Parsing a Pairs of Values in a String While Preserving ...
Introduction In a project I’m currently working on, I need to modify a stored procedure that returns a […]
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 […]
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. […]
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 ...
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 […]
Using SQLite with Flutter
Storing, retrieving, and modifying data are common tasks in many applications. In a cross-platform application, it is important […]
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 […]
First Normal Form Gets No Respect
Dr. Codd first described the relational model in a paper in Communications of the ACM (CACM 13 […]
[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 […]
Fabric: My Content compilation
Microsoft Fabric was first announced during Microsoft BUILD. Since then, I’m publishing content about Microsoft Fabric, creating […]
[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 […]
SQL Server 2022 on SUSE Enterprise Linux v15 SP5 – ...
You might have already seen the post for SQL on SLES 15 SP4 release, where we announced the […]
Something’s Up with Parallelism in Azure SQL DB Serverless
Or perhaps another way to phrase that is, Microsoft is up to something with parallelism. I don’t know […]
SQL Server Row Level Security Deep Dive. Part 6 ...
As seen in the previous section, there are several ways bad actors can attempt to bypass RLS. […]
Normalize strings to optimize space and searches
While this article is specifically geared to SQL Server, the concepts apply to any relational database platform. […]
Which of These Azure Courses Would You Attend?
A member of the community (no, it’s not me) is thinking about offering a live training course and […]
Getting Started with Power Query M Language in Excel
The post Getting Started with Power Query M Language in Excel appeared first on SQLServerCentral.
Sentiment Analysis with IA
Introduction In this article, we will do sentiment analysis of text stored in SQL Server with comments about […]
PostgreSQL 101: A guide to PostgreSQL documentation & useful resources
In the latest webinar of our PostgreSQL 101 series, join Ryan Booz, PostgreSQL Advocate at Redgate, and Grant […]