Audit SQL Server Extended Stored Procedures Usage
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
Articles
Returning 0's in a SUM (SQL Spackle)
Learn how you can sum data by hour and by day while showing 0 values in your result sets for those time periods without a sum in this short article by Patrick Cahill.
2024-10-25 (first published: 2011-06-13)
10,210 reads
Using a Service Account in Microsoft Fabric
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
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
2024-10-21
1,973 reads
Data Lake Implementation – Data Lake Zones and Containers Planning
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.
2024-10-21
Outer Join – What am I missing (SQL Spackle)
This article shows how to find missing rows in a table using a outer join.
2024-10-18 (first published: 2013-11-12)
24,261 reads
Uncover SQL Server Missing Indexes
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
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
354 reads
Use Logic Apps To Save Money In Azure: Data Engineering in Fabric
This next article looks at how a Logic App in Azure can start and stop various database services and save money.
2024-10-16
2,036 reads
Blogs
A New Word: Ecstatic Shock
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Forums
sp_prepare and sp_execute vs sp_executesql
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
Find Invalid Objects in SQL Server
Comments posted to this topic are about the item Find Invalid Objects in SQL...
Question of the Day
Who am I?
If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?
create procedure AddNewCustomer
@customername varchar(200)
AS
BEGIN
DECLARE @added VARCHAR(100)
SELECT @added = xxx
IF @customername IS NOT NULL
INSERT dbo.Customer
(
CustomerName,
AddedBy
)
VALUES
(@customername, @added)
END See possible answers