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.

External Article

Add and Subtract Dates using DATEADD in SQL Server

Date manipulation is a common scenario when retrieving or storing data in a Microsoft SQL Server database. There are several date functions (DATENAME, DATEPART, DATEADD, DATEDIFF, etc.) that are available and in this tutorial, we look at how to use the DATEADD function in SQL queries, stored procedures, T-SQL scripts, etc. for OLTP databases as well as data warehouse and data science projects.

SQLServerCentral Editorial

Technical Pain Behaviors

In my family’s history of the past 10+ years, we have become well versed in nagging, ongoing, non-debilitating pain. In some ways, the lessons we have learned about physical pain correlate all too well to the types of pain that we technical people are involved with daily. But there is a huge difference, even if […]

SQLServerCentral Article

Boosting Data Accuracy: Resolving Common Data Quality Issues Using SQL

Poor data quality significantly hinders large enterprises from deriving meaningful value. The variety of data is a crucial factor to account for when assessing & rectifying data quality, as diverse data types introduce unique challenges in maintaining accuracy and consistency. Good data quality and integrity are essential for accurate insights, good decision-making, and potential success of large enterprises. Inconsistent, incomplete, and inaccurate data significantly affect business operations, customer satisfaction, and financial performance. SQL provides robust functions to proactively identify and resolve these data quality issues, ensuring accurate, reliable, and consistent data for reporting and analysis.

Blogs

Troubleshooting SQL Server – Starting with the Error Log

By

We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...

From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures

By

In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...

Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4

By

One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...

Read the latest Blogs

Forums

SQL Server 2025 Jobs

By Do

Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...

how to optimise whole database full of table and sp in one go using githubcopilo

By rajemessage 14195

i have subscription of github copilot which i can access in vs 2022 comunity...

Password Guidance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Password Guidance

Visit the forum

Question of the Day

Using table variables in T-SQL

What happens if you run the following code in SQL Server 2022+? 

declare @t1 table (id int);

insert into @t1 (id) values (NULL), (1), (2), (3);

select count(*)
from @t1
where @t1.id is distinct from NULL;
 

See possible answers