Additional Articles

Live webinar - Prioritizing security: Essential strategies for IT leaders

by Additional Articles

SQLServerCentral

Conferences, Classes, Events, and Webinars

In today's rapidly evolving landscape, managing the security of large and complex database estates is a critical challenge for organizations. Join us for a webinar on Nov 21 covering “Prioritizing security: Essential strategies for IT leaders,” where Redgate’s security experts will share their tips on how you can safeguard your database estate and minimize reputational risk. There will also be a Q&A session where you can get expert advice from our panelists.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2024-11-04

Optimize SQL LIKE Wildcard Searches

by Additional Articles

MSSQLTips.com

Learn about different ways to improve the performance of full wild card text searches to find strings in SQL Server tables.

2024-11-01

Consistency and Concurrency in NewSQL Database Systems

by Additional Articles

SimpleTalk

NoSQL / NewSQL

Companies today require database systems that are reliable and capable of efficiently handling large volumes of data and numerous transactions. Traditional relational databases, once the foundation of data management, often struggle to meet these modern demands, leading to delays and program slowdowns. In response, NewSQL databases, a new class of SQL systems, has emerged.

2024-10-30

Audit SQL Server Extended Stored Procedures Usage

by Additional Articles

MSSQLTips.com

In this article, we look at how to audit and monitor the use of SQL Server extended stored procedures in your database instance.

2024-10-28

Using a Service Account in Microsoft Fabric

by Additional Articles

SimpleTalk

Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

Applications should never depend on user accounts for their own authentication. User accounts have unique security configurations, such as MFA and password expiration.

2024-10-25

Troubleshoot Chained SQL Server CTE

by Additional Articles

MSSQLTips.com

This article will explore how SQL Server chained CTEs might make troubleshooting code harder and whether you should stop using CTEs altogether.

2024-10-23

Data Lake Implementation – Data Lake Zones and Containers Planning

by Additional Articles

SQLServerCentral

Data Lake

The Azure Data Lake is a massively scalable and secure data storage for high-performance analytics workloads. We can create three storage accounts within a single resource group.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2024-10-21

Uncover SQL Server Missing Indexes

by Additional Articles

MSSQLTips.com

In this article, we look at a SQL Server Dynamic Management View (DMV) that helps find queries that trigger missing index recommendations.

2024-10-18

AWS Services Using SQL for Big Data Analysis

by Additional Articles

SimpleTalk

AWS offers a robust suite of tools designed to manage big data effectively. This article explores focusses on how SQL is leveraged within Amazon Redshift and Amazon Athena. We will delve into the technical features, practical applications, and step-by-step examples for using these services, highlighting how they can transform raw data into actionable insights for your business.

2024-10-16

358 reads