Sergey Pustovit

Easy Auditing a Shared Account

Despite the major advances made with Profiler in SQL Server 2005, auditing changes isn't one of the strengths of the product. New author Sergey Pustovit brings us his technique that allows auditing of actions using shared accounts from an application. A few minor code changes, but overall this is a very interesting idea.

5 (2)


7,078 reads


Understanding Azure Geo-Redundant Storage


While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery...

Prompt in ADS


Ever since VS Code and Azure Data Studio came out, people have been asking...

When Too Much is Not a Good Thing


Explore how to avoid unwanted results that oft occur due to lack of attention...

Read the latest Blogs


BAckup history not showing into MSDB

By pdsqsql

Hello, We had an strange issue that our sql server 2012 Sharepoint Databases backup...

Pivot or convert column to rows

By sqltester1

Hi All, I have table which stores all in single column, I want to...

Having trouble with simple select query where all ordere item statuses = shipped

By Goalie35

I'm trying to write a simple query but having trouble returning the correct results. ...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers