MS SQL

Step 1:     Go to https://sqlbackup.appliedi.net/ and choose the server which your database is held on:   Step 2:     Now type in your username (login) and password of your database user and click Connect: Step 3:   Now look at the left side in the Tools section and click Backup databases:   [...]

  Summary When you restore a Microsoft SQL Server database on a different machine, you cannot access the database until you fix the permissions. Detail The problem is that the user in the database is an "orphan". This means that there is no login id or password associated with the user.  All of these instructions [...]

You can connect to a SQL Server 2005/2008 database using SQL Server Management Studio Express Edition. (this download is available free at http://www.microsoft.com/en-us/download/details.aspx?id=22985)   Step 1:   Open up SQL Server Management Server Studio and click "Registered Servers"   Step 2:     Right click "Database Engine', go to "New", then click "Server Registration"     [...]

Step 1:   Go to https://sqlbackup.appliedi.net/ and choose the server which your database is held on:     Step 2:   Now type in your username (login) and password of your database user and click Connect:   Step 3:     go to the Tools section and click Restore databases:     Step 4:       Now [...]

Once you have connected to MS SQL using SSMS Right click on the database Select New Query Paste the below query and click Execute SELECT t .NAME AS TableName, s .Name AS SchemaName, p .rows AS RowCounts, SUM(a .total_pages) * 8 AS TotalSpaceKB, SUM(a .used_pages) * 8 AS UsedSpaceKB, (SUM( a.total_pages ) - SUM( a.used_pages [...]

To reduce the disk usage of an MS SQL database, a shrink operation can be performed. It's best not to shrink your database however, as this causes index fragmentation which affects performance. If you need to reduce your database size, an ideal time to shrink your database is after you have deleted a lot of old or unneeded [...]

How to View a Report of SQL Database Disk Usage   First, remotely connect to your database by logging in to the database server using SQL Management Studio. A separate KB is available here that covers connecting to your database if needed needed: http://support.appliedi.net/index.php?/Knowledgebase/Article/View/458/84/how-to-login-to-your-ms-sql-server-through-sql-server-managment-studio-express   Once logged in, simply right-click on your database name, go to the 'Reports' [...]

This article will show you how to whitelist an IP address for MS SQL access on a Windows 2012 server.    Step 1.  Log-in to the server as an administrator.     Step 2.  Hover the cursor over the lower, left-hand corner of your screen.       Step 3.  The Start icon will appear.  Click Start.     [...]

When restoring a MS SQL database from another server sometimes the tables/objects will be owned by the previous user on the old server. To change ownership on all tables/objects to DBO (the user you assigned to the database and gave DBO permissions) run the following query on the database (see below for last step after [...]

Some developers may choose to utilize SQL's Mail option as in some scenarios there may be different front end type web applications tied to a single type of database (in this case MS SQL 2005). This prevents the developer from having to write the same email method for each type of front end application. This [...]