Category Archives: SQL Server

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 →

Service packs are very critical and important. It is very important from product upgrade & bug fixing point of view. Regular upgrades to your system with latest releases help you in :- · Continued Support · Resolves Problems · New Features Microsoft has recently released SQL Server 2008 R2 service packs. Please note SQL Server … Continue reading →