SQLServerCentral Article

Review of Lumigent Entegra

We've been trying to catch up on reviews lately, Hai was kind enough to give Entegra a try and report back on it. The basic concept is that it lets you do extensive auditing without having to add triggers. If you're trying to find an auditing solution, this is worth considering.

Technical Article

Regular Expression Library

This isn't a SQL site nor can you easily do regular expressions from SQL. That said, sometimes regular expressions are EXACTLY what you need to solve a problem. The downside? They're tricky! This is a great resource to pass on to your development team.

Technical Article

What is the difference between SET and SELECT?

Both SET and SELECT can be used to assign values to variables. But when to or when not to use SET or SELECT? Or does it matter? This articles shows you how SET and SELECT are different in various scenarios, along with examples. You will also find a test script that you can run, to identify the performance differences between SET and SELECT

Technical Article

SQL Server Web Data Administrator

The Web Data Administrator is a utility program implemented in ASP.NET that enables you to easily manage your SQL Server data wherever you are. Using its built-in features, you can do the following from Internet Explorer or your favorite Web browser:

Create and edit databases in Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (MSDE)
Perform ad-hoc queries against databases and save them to your file system
Export and import database schema and data

SQLServerCentral Article

Worst Practice - Triggering External Events

Andy Warren started his worst practice series some time ago with the intention of looking at the worst things you can do. Given that we may not always be able to implement the best practices, at least we can try to avoid doing things harm the system or decrease performance. This article continues the series and looks at an item I see mentioned in our discussion forum quite often, triggering external events. From a trigger.

Blogs

Another AI Faux Pax

By

I was experimenting with a local model (article) and as a part of this,...

Monday Monitor Tips: Using the PowerShell API

By

Redgate Monitor has grown tremendously from its early days and I find many customers...

Data Governance: The Invisible AI Accelerator

By

The post Data Governance: The Invisible AI Accelerator appeared first on Joyful Craftsmen.

Read the latest Blogs

Forums

Problem with the dll (version 1.2) of an Extended Stored Procedure with SQL Serv

By SKEITA

SQL Server 2022 16.0.4165.4 Windows Server 2022 Datacenter 21H2 20348.2849 Our Extended Stored Procedure...

PK violation in replication but only one subscriber

By cphite

We have a publication with three subscribers; it's basically a part list with around...

Recovery Takes 10-20 mins with ADR enabled

By VastSQL

Hi Experts, I have database about 300GB in size with ADR enabled but after...

Visit the forum

Question of the Day

Data API Builder Operations

What types of database operations does the Data API Builder support?

See possible answers