Database Backup Encryption with SQL Server 2014
A brand new & long awaited feature “Backup Encryption” along with SQL Server 2014. Microsoft reveled this upcoming feature in PASS...
2014-05-26 (first published: 2014-05-19)
5,741 reads
MSSQLFUN
Add Node to Windows Server 2008 Cluster
Steps : Add Node to Windows Server 2008 Cluster
1) Open Cluster Administration wizard > Right click on Windows Cluster & select Add Node
2)...
2014-05-12
1,885 reads
Thanks to Toadworld.com team for recognition !
Thanks to Toadworld.com team for recognition !
Toadworld.com Profile : http://www.toadworld.com/members/rohit-garg/blogs/default.aspx
If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun
Reference : Rohit...
2014-05-11
684 reads
Cumulative Update – 12 for SQL Server 2008 R2 Service Pack 2 Is Now Available !
The 12th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the...
2014-05-05
1,794 reads
Cumulative Update – 1 for SQL Server 2014 RTM Rollback by Microsoft !
The 1st cumulative update release for SQL Server 2014 RTM was released by Microsoft.
But due to issues in setup Microsoft...
2014-05-05
965 reads
How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ?
Steps : How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ?
1) Open SQL Server Installation...
2014-04-28
771 reads
How to install SQL Server Failover Cluster from SQL Server 2008 onwards ?
Steps to install SQL Server Failover Cluster from SQL Server 2008 onwards :-
1) Open SQL Server Installation Center > Go to...
2014-04-29 (first published: 2014-04-22)
2,417 reads
SQL Server 2000 || Disable sa login
Question : How to disable sa user in SQL Server 2000?
Reason : Due to Security requirement of audit, We have to disable...
2014-04-15
1,984 reads
Antivirus Exclusion Policy for SQL Server
Anti-virus & SQL Server on one system together are friends not enemies, if configured properly.
Anti-virus are very useful programs from security,...
2014-04-08
13,110 reads
2014-03-17
599 reads
Blogs
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Forums
Extract sql data in psh
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
caught off guard by some greek lettering in a warehouse feed
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
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...
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