SQLServerCentral Editorial

Throwing Iron at the Cloud and AI

As organizations move to the cloud, the once essential role of the Database Administrator (DBA) as the guardian of system optimization, has been overshadowed, often viewed as a bottleneck to innovation. Yet, as technology evolves, the one thing I know is history repeats itself, and optimization skills are once again emerging as a critical necessity. […]

SQLServerCentral Article

JSON in Microsoft SQL Server: A Comprehensive Guide

Introduction JSON (JavaScript Object Notation) has become a popular data format for storing and exchanging information. Microsoft SQL Server, starting from version 2016, introduced built-in support for JSON, allowing developers to work with JSON data more efficiently within the relational database environment. This article will explore how to store, retrieve, and manipulate JSON data in […]

SQLServerCentral Article

Creating a Linked Server in Amazon RDS for SQL Server: A Step-by-Step Guide

Linked servers in Amazon RDS for SQL Server allow seamless connectivity to remote databases for distributed queries and data integration. In this article, I guide you through the step-by-step process of creating a linked server using SQL commands, from setting up authentication to testing the connection. Learn best practices, advanced configurations, and essential considerations, including why you can't use SSMS for linked server setup in RDS. This professional guide is tailored for experienced database administrators looking to optimize cross-server operations.

Technical Article

A Practical Guide to Using Azure Key Vault in Enterprise Deployments

Key vaults define security boundaries for stored secrets. It allows you to securely store service or application credentials like passwords and access keys as secrets. All secrets in your key vault are encrypted with a software key. When you use Key Vault, you no longer need to store security information in your applications. Not having to store security information in applications eliminates the need to make this information part of the code.

Blogs

Using T-SQL Snapshot Backup - Multi-Array Database Snapshots

By

In this post, the fourth in our series, I want to share an example...

AIs Struggle with Family

By

This post looks at a logic problem asked to an AI, and which is...

Advice I Like: Why am I doing this?

By

You are never too young to wonder “Why am I still doing this?” You...

Read the latest Blogs

Forums

Why you should avoid Implicit Measures in your Power BI model

By Koen Verbeeck

Comments posted to this topic are about the item Why you should avoid Implicit...

Building SSIS Custom Task

By bodempudi111

Hi Everyone, Greetings of the day! I am working on building SSIS Custom task...

Visit the forum

Question of the Day

Precision and Scale I

I have this number: 456.23 What is the scale of this number?

See possible answers