DDL Auditing using the Default trace
This article explains how default trace can be used for auditing purposes when combined with PowerShell scripts
2015-05-05
4,191 reads
This article explains how default trace can be used for auditing purposes when combined with PowerShell scripts
2015-05-05
4,191 reads
The following blog post has 2 objectives.
1) How to size the memory correctly ( or atleast being close to correctly )
2)...
2013-05-27
2,747 reads
I have always been a big fan of Xp_readerrorlog. The simple reason is that it much faster to read errorlog...
2013-05-16
1,232 reads
What is the fastest and perhaps easiest way to find the last successful database backup?
Just right click on the Database...
2013-03-01
378 reads
Another question I have answered 100s of times to Non SQL folks. "SQLServr.Exe is consuming 80% of memory. Can you...
2012-05-20
1,352 reads
I am not sure how many of you have faced this situation? I have faced it many many times. Somebody...
2012-04-23
1,004 reads
If one needs to call a UDF or System function ( ex: Serverproperty, Getdate(), etc ) on a remote server, then one...
2012-04-08
2,647 reads
Consider the situation where one needs to store multilingual data / Special characters into a table. For example Chinese characters or...
2012-03-27
7,475 reads
What is File Group backup?
Backing up a portion of a database, say a File Group is termed as Filegroup...
2012-01-13
488 reads
Quick summary of the post:
A restoration of a full database backup retains the log file size before restoration.
Now...
2011-11-01
503 reads
By Steve Jones
incidental contact high – n. an innocuous touch by someone just doing their job...
My company is moving from an Azure PostgreSQL single server to a flexible server....
By Steve Jones
The survey is out now and you can share your experiences for a chance...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Comments posted to this topic are about the item How to Add a New...
Comments posted to this topic are about the item Knowing What You Don't Know
How can I tell from T-SQL if I'm connected to SQL Server or Synapse Analyics?
See possible answers