Articles

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2025-01-29

2 reads

Add and Subtract Dates using DATEADD in SQL Server

by Additional Articles

MSSQLTips.com

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.

2025-01-27

Boosting Data Accuracy: Resolving Common Data Quality Issues Using SQL

by ganeshmasti

SQLServerCentral

Uncategorized

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2025-01-24

2,117 reads

Discuss

Oracle Architecture Overview

by Additional Articles

SimpleTalk

Oracle

In this document I will share an overview of Oracle’s architecture that isn’t complete, but it will give you a basic understanding of how the architecture works, especially if you are coming from other database platforms.

2025-01-24

Why Standards are Important

by David Poole

SQLServerCentral

Uncategorized

There is something in the tech mindset that simultaneously loves and loathes a standard. Having standards is important, what those standards are is less so.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2025-01-22

2,363 reads

Discuss

How to Install SSIS in Visual Studio 2019

by Additional Articles

MSSQLTips.com

ETL/SSIS/Azure Data Factory

This tool has always been an integral part of the Visual Studio. However, the name of this tool as well as the method of its installation varies from version to version of Visual Studio (VS). In this article, we are going to illustrate how to install SSIS in Visual Studio 2019.

2025-01-22

Influencing a Local AI

by Steve Jones

SQLServerCentral

Artificial Intelligence (AI)

I set up a local AI LLM to run and then conducted some experiments. This post shows a bit about the experiments and a little code. The setup is on my blog using Docker to containerize an Ollama LLM, which you can read about. The Basic Setup If you read my blog, I downloaded an […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2025-01-20

1,816 reads

Discuss

Demystifying Continuous Integration vs. Continuous Delivery Part 3 – Real World Examples of CI CD

by Additional Articles

SimpleTalk

DevOps and Continuous Delivery (CI/CD)

This article covers examples of how some larger companies have successfully implemented CI/CD practices to transform their development processes.

2025-01-20

Vector DB implementation using FAISS

by Utsav Verma

SQLServerCentral

Searching for relevant information in vast repositories of unstructured text can be a challenge. This article explains a Python-based approach to implementing an efficient document search system using FAISS (Facebook AI Similarity Search) for Vector DB and sentence embeddings, which can be useful in applications like chatbots, document retrieval, and natural language understanding. In this […]