SELECT DISTINCT SQL Command to Return a Unique List of Values
Learn about the SELECT DISTINCT SQL command to return a unique list of values from SELECT queries along with several examples.
Has Everyone Had a Data Breach?
Not only is the security of our organization important, but that of our partners matters as well.
Stairway to SQL Server Security Level 11: Auditing
By defining server- and database-level audits, you can record just about any kind of event that occurs in SQL Server, which can be an invaluable source of security troubleshooting and forensic information when security breaches occur. In this stairway level you’ll learn how to define the various audit specification objects, how to capture audit data, and how to explore and use the data.
AWS Lambdas with C#
In this article, I will take you through the development process of building an API on the serverless cloud with C#. This API will be built to serve pizzas, with two endpoints, one for making pizza and the other for tasting fresh pizzas. I expect some general familiarity with AWS and serverless computing. Any previous experience with building APIs in .NET will also come in handy.
Complex Production Database Deployments and Flyway
This article explains how, by use of schemas and stub interfaces, we can use Flyway to manage the main development work smoothly alongside any changes or additions required to maintain production-only code.
ChatGPT in SQL Server - Practical examples
Introduction ChatGPT in SQL Server In this article, we will learn some basic examples of ChatGPT in SQL Server. In a previous article, we had an interview with ChatGPT an AI chatbot developed by OpenAI. If you do not know how to use it yet, you can go to that article. We will show some […]
Nested Transactions
Steve Jones notes there aren't really nested transactions in SQL Server. And we all ought to know this.
Join us in our castle at SQL Bits, March 15-18
SQL Bits is coming to Wales, home of dragons and D&D, and we’re happy announce we’re supporting them as platinum sponsors again this year. Meet us at our Red Keep and catch sessions by noble Fighter Grant Fritchey, Sorcerer Steve Jones, and more beloved Redgate Paladins and Druids. For a magical 10% discount on your ticket, use 10REDGATE from our spell book.
Snowflake for SQL Server Developers - NULL Functions - Part 2
Learn about NULL functions that exist in Snowflake but not in SQL Server like NVL2, ZEROIFNULL, EQUAL_NULL, and IS_NULL_VALUE.
The Top SQL Server Engine Errors
The SQL Server Support team published the top errors they see in calls. Steve has a few comments on what they're doing to help customers.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCU ASIA CSTelpon : 0853-73737551
Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II, Kec. Medan Area,...
BCA KCP Tebet Barat 2 Telpon/wa.085373737699
BCA KCP Tebet Barat 2 Telpon/wa.085373737699.Jl. Tebet Raya No.25 B Blok CI, Tebet Tim.,...
BCA KCP Duri Raya Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. Duri Utara No.37 B, Duri Sel., Kec. Tambora, Kota Jakarta Barat, Daerah...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers