Explore SQL Server 2008 on Experts Exchange

Expert Solutions for Your Tech Problems

SQL Server 2008Microsoft SQL Server 2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.C...

Read more
  • 50K Content
  • 7.1K Contributors

Expert Spotlight
SQL Server DBA & Architect, EE Solution Guide

I'm a SQL Server Architect experienced in Design, Development, Administration, Performance Tuning.. Exploring BI, SSIS & Data Science Arena!

Article

How to Fix SQL Server Login Failed Error 18456 State 38

One of the most common issues faced while connecting to a SQL Server instance is "Login failed for …
Article
Restore Stored Procedure in SQL Server

How to Restore Stored Procedure in SQL Server

In this article, we will discuss how to deal with a situation wherein you face an issue with a mandatory stored procedure in your critical database.
Article

SQL Database Backup and Recovery - All you Need to Know

This tutorial is a great guide for newbies in SQL Server who never backup the database and for people with some experience, because you will learn some tips that you may not know.
Article

How to Recover Deleted SQL Data with the Help of Best SQL Recovery Software

1
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and consists of using a SQL Recovery Software.
Article
Attach SQL Database

How to Attach SQL Database Which is Not Properly Detached

1
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Article

Stellar SQL Database Toolkit is Best Solution for All SQL Database Issues

1
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as well as instant password recovery. 
Article

Getting User Permissions for SQL Server 2008+

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Article

How to replicate SQL 2008 database to SQL 2014 by using Initialize from Backup.

bylcohan
2
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup Transactional replication as described below.
Article

How to recover deleted rows in SQL Server

3
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Article

How to Reset a Lost SA Password in Microsoft SQL Server

5
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Article

Batch File to Perform Backup of MSSQL Database

8
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and will then append that to the file name.
Article

Share One TLS Certificate for Remote Desktop Services and SQL Server

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Article

SQL Server database migration - The Copy Database Wizard method

2
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Article

SQL Server database migration - The Backup & Restore method

2
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Article

SQL Server database migration - The Detach/Attach method

1
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Article

Robust Field Cleaning Function

11
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. …
Article

SQL Server Security: Server authentication mode

1
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server …
Article

SQL Server - Converting RFC822 Dates Into Any Timezone

2
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an …
Article

Monitoring table-level activity in a SQL Server database by using T-SQL

5
Tracking database activity

There are a number of ways to view SQL Server activity; SQL …
Article

How to run 2008R2 SSIS packages on both SQL Server 2012/2014 and SQL Server 2008

2
In couple weeks ago, I encountered an extremely difficult problem while deploying 2008 SSIS packages…

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more