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,746 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,887 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
686 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,799 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
970 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
775 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,420 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,988 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,122 reads
2014-03-17
602 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers