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,944 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
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers