Cumulative Update – 11 for SQL Server 2008 R2 Service Pack 1 Is Now Available !
The 11thcumulative update release for SQL Server 2008 R2 Service Pack 1 is now available for download at the Microsoft...
2013-02-19
1,001 reads
MSSQLFUN
Backup not starting for Database with Full Text Catalog…………..Failed to change the status to RESUME for full-text catalog in database. Error: 0×80043607
Issue :-
One of our Database with Full Text Catalog is not getting backed up. When I checked, backup keeps pending...
2013-02-14
756 reads
Connect PerfMon to a Remote Server
It seems to be a simple & easy thing to connect Perfmon to a remote server.
GO TO RUN > Perfmon > Right Click...
2013-02-14
1,251 reads
How to get list of all available parameter of .EXE file ?
Today, We discuss How to get list of all available parameter of .EXE file OR How to find list of...
2013-02-13
5,275 reads
Refresh Intellisense in SSMS(SQL Server Management Studio) 2008 & above
Intellisense is a new feature that comes with SSMS(SQL Server Management Studio) 2008 onwards. Intellisense makes coding quite easy.
But Sometimes...
2013-02-11
1,781 reads
Move or Relocate the files of Resoruce Database in SQL Server 2005
The Resource database is a read-only database that contains all the system objects that are included with SQL Server. SQL...
2013-02-07
703 reads
Microsoft SQL Server License Helpline
Microsoft SQL Server license has lots of flavors in terms of user based \ CAL or processor based license, license based...
2013-02-05
910 reads
How to find/modify SQLServer Agent logfile location?
1. To get the location of SQLServer Agent log file, the log file is called SQLAGENT.out
DECLARE @AGENT_ERRORLOG NVARCHAR(255)
EXECUTE MASTER.DBO.XP_INSTANCE_REGREAD N’HKEY_LOCAL_MACHINE’,
N’SOFTWAREMICROSOFTMSSQLSERVERSQLSERVERAGENT’,
N’ERRORLOGFILE’,
@AGENT_ERRORLOG...
2013-01-31
7,730 reads
SQL Server Silent unattended installation using configuration file
1) Open Installation Wizard
Open Installation Wizard
2) Select Feature You want to install
Select Feature You want to install
3) Provide installation configuration
Provide...
2013-01-29
6,402 reads
Cumulative Update – 2 for SQL Server 2012 Service Pack 1 Is Now Available !
The 2nd cumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 2 contains all...
2013-01-26
1,091 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
Huge frustration - Database watcher with two elastic pools
Think there's a reason why this is still in preview, but have someone manage...
SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
Is it uncommon for Dev's to have a data model of the source data
This is a generic question. To the moderators, I wasn't sure where to place...
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers