Mainstream Support End || SQL Server 2008 and SQL Server 2008 R2
Mainstream Support for SQL Server 2008 and SQL Server 2008 R2 was ended on July 8th 2014. This will result...
2014-07-14
613 reads
MSSQLFUN
How to restore MSDB & MODEL database – SQL Server System Databases?
The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as...
2014-07-14
16,121 reads
How to change TempDB system Database files location?
Steps to change TempDB system Database files location :- 1) Check current file location of TempDB Exec SP_helpDB TempDB You can use below query as well for file location...
2014-07-07
10 reads
How to change TempDB system Database files location?
Steps to change TempDB system Database files location :-
1) Check current file location of TempDB
Exec SP_helpDB TempDB
You can use below...
2014-07-07
14,945 reads
Cumulative Update – 2 for SQL Server 2014 RTM Is Now Available !
The 2nd cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 2 contains all the hotfixes released since...
2014-07-02
5 reads
Cumulative Update – 13 for SQL Server 2008 R2 Service Pack 2 Is Now Available !
The 13th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 13 contains all the...
2014-07-02
7 reads
Cumulative Update – 2 for SQL Server 2014 RTM Is Now Available !
The 2nd cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site....
2014-07-02
1,101 reads
Cumulative Update – 13 for SQL Server 2008 R2 Service Pack 2 Is Now Available !
The 13th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the...
2014-07-02
1,147 reads
Rename or Change SQL Server Standalone Default Instance
Today, We will go through with the steps of renaming or changing SQL Server Standalone Instance.
Step 1 : Check Current Instance...
2014-06-30
22,771 reads
SQL Server 2014 – How to add features to existing instance ?
SQL Server 2014 – How to add features to existing instance ? :-
1) Start installation center
2) Run Global Rule, You need to...
2014-06-26
13,437 reads
Blogs
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
Forums
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Upgrading Admin Queries
Comments posted to this topic are about the item Upgrading Admin Queries
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers