Yearly Archives: 2012

Master database is in simple recovery model & simple recovery model supports Full & Differential backup. “Is it possible to take the differential backup of master database?”. The answer is No. Why not try taking the differential backup of master database instead. Open SSMS and the backup option looks like this. Only FULL backup type … Continue reading →

Issue We are having SharePoint on Windows Server 2008 but when we are trying to run SharePoint commands from PowerShell we are getting below error message. Resolution Run below commands in PowerShell to register SharePoint in PowerShell & try again. Remove-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

3 steps to create custom Snippets in SQL Server 2012 :- Create a snippet using XML Register the snippet in SQL Server Management Studio (SSMS) Invoke the snippet when using Query Editor Step 1. Create a T-SQL Snippet File with XML A snippet that can use to write a backup statement for any database. Save … Continue reading →

The snippets in SQL Server 2012 are essentially templates that can help in building database statements. T-SQL snippets helps you in quickly building up T-SQL statements without having to remember the commands or their syntax. You can use this feature to reduce development time, syntax mistakes and increase productivity for your developers and DBAs. Snippet … Continue reading →

Those who have been working with SQL Server administration for a while now undoubtedly have at times referred to the old SQL Server system tables in order to automate some processes, or document their tables by for example combining the sysobjects and syscolumns tables. As per SQL Server 2005 and onwards, Microsoft added a number … Continue reading →