Cumulative Update – 9 for SQL Server 2008 Service Pack 3 Is Now Available !
The 9th cumulative update release for SQL Server 2008 Service Pack 3 is now available. Cumulative Update 9 contains all...
2013-01-23
1,371 reads
MSSQLFUN
SQL Server Reserve 1 user connection for DAC (Dedicated Administrator Connection)……want to confirm ?
Sometime before, I was giving training on basics of SQL Server. One of attendee is having doubt & want to confirm...
2013-01-21
751 reads
Reminder about your invitation from Rohit Garg – MCTS, Microsoft Community Contributor
This is a reminder that on January 14, Rohit Garg – MCTS, Microsoft Community Contributor sent you an invitation to become...
2013-01-21
933 reads
The server principal “xxxx” is not able to access the database “msdb” under the current security context.
Problem :
Yesterday Night, One of my team member called & report that some users are getting below error no. 1 while...
2013-01-15
34,358 reads
Under which user your SQL Agent Job run : SQL Agent Service Account or SQL Agent Job Owner ?
Today, I am willing to do demo that under which user my SQL Agent Job run, SQL Agent Service Account...
2013-01-11
4,021 reads
The EXECUTE permission was denied on the object 'sp_start_job', database 'msdb', schema 'dbo'.
Reblogged from MSSQLFUN:
Issue : Today I have read one issue over one forum, One user is having below 3 DB roles...
2013-01-09
5,428 reads
The EXECUTE permission was denied on the object ‘sp_start_job’, database ‘msdb’, schema ‘dbo’.
Issue : Today I have read one issue over one forum, One user is having below 3 DB roles on MSDB...
2013-01-09
10,713 reads
How to move file through FTP by CMD ?
CMD code to upload file direct into root of FTP site of server
@ echo off
REM ******** this batch file is to...
2013-01-07
1,664 reads
What happen, If SQL Server new instance try to use exitsing named instance name?
We all know that SQL Server can have 1 default instance & many named instance.
But I want to check, How SQL...
2013-01-04
1,201 reads
MSSQLFUN – Year 2012 Review
The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.
Here’s an excerpt:
600 people reached the top of...
2013-01-03
712 reads
Blogs
Expanding Your DBA Horizons: Installing PostgreSQL in a Home Lab
By gbargsley
Are you diversifying your DBA skillset? My recent job search made one thing clear:...
Back in the EU
By Steve Jones
I flew to Amsterdam last night and hopefully by the time this publishes I’ll...
The Feedback Multiplier: How Leaders Can Turn Input into Innovation
By Chris Yates
In every organization there is a hidden currency more valuable than capital, more enduring...
Forums
Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Vector Datatype
Comments posted to this topic are about the item Vector Datatype
PRs Are Like Trouble Tickets
Comments posted to this topic are about the item PRs Are Like Trouble Tickets
Question of the Day
Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers