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,514 reads
Nagaraj Venkatesan
How to Size the SQL Server Memory & Why is it important?
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,940 reads
Xp_readerrorlog in SQL Server 2012
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,717 reads
When was the last successful backup?
What is the fastest and perhaps easiest way to find the last successful database backup?
Just right click on the Database...
2013-03-01
392 reads
SQL Server Memory Usage - Task Manager
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,477 reads
Sysprocesses CPU and CPU Percentage - utilization
I am not sure how many of you have faced this situation? I have faced it many many times. Somebody...
2012-04-23
1,270 reads
Calling Function / UDF using linked server
If one needs to call a UDF or System function ( ex: Serverproperty, Getdate(), etc ) on a remote server, then one...
2012-04-08
3,036 reads
Inserting UniCode / Special characters in tables
Consider the situation where one needs to store multilingual data / Special characters into a table. For example Chinese characters or...
2012-03-27
7,918 reads
File Group Backups - Intro
What is File Group backup?
Backing up a portion of a database, say a File Group is termed as Filegroup...
2012-01-13
505 reads
Log file size after backup and restore
Quick summary of the post:
A restoration of a full database backup retains the log file size before restoration.
Now...
2011-11-01
532 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Forums
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Planning for Change
Comments posted to this topic are about the item Planning for Change
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers