Find Database Names in Microsoft SQL Server (SSMS, T-SQL and sqlcmd)
List all databases on a Microsoft SQL Server instance with SSMS, a sys.databases query, sp_databases, sqlcmd or PowerShell.
List all databases on a Microsoft SQL Server instance with SSMS, a sys.databases query, sp_databases, sqlcmd or PowerShell.
Index SQL Server Database Index SQL Server 2008R2 Database Every once in a while it’s a good idea to re-index your tables when you are using Microsoft SQL Server. Unlike…
Differential Backup SQL Server Express Differential Backup SQL Server 2008R2 Express if you are already doing full backups of SQL Server, as a DBA you would know that that does…
Create New Database SQL Server Create New Database SQL Server 2008R2 The first thing you need to do is open SQL Server Management Studio from here login with the necessary…
Fix Microsoft SQL Express Memory Issues Fix Microsoft SQL Express Memory Issues In this example, we have Microsoft SQL Server express. We know that express only can use 1GB RAM…
Create Document Library SharePoint 2010 creating a document library in SharePoint 2010 is relatively easy if you have the correct access, go ahead and logon to you SharePoint Site with…
Backup SQL Server Express Backup SQL Server Express 2008R2 Open up SQL Server Management Express Studio, and Expand Databases For this example, we will be backing up a SharePoint Server,…
Install SQL Server 2012 Express Install SQL Server 2012 Express on Server 2008 Start here by downloading SQL Express with Tools from here: http://www.microsoft.com/en-us/download/details.aspx?id=29062 download SQLEXPRWT x64 version once Downloaded…
Install SharePoint 2013 Install SharePoint 2013 I have a new 2008R2 VM Setup with SQL Server 2012 Express freshly installed (if you are not yet at this point, get the…
this i unfortunately had to learn on the fly, not sure how it happened, but let’s just say that it did. i noticed a bunch of my SQL Server Databases…