SQL Server – Creating linked server in SQL Server Management Studio

In SQL Server environments the linked server functionality is commonly used to connect to another (remote) database or file (Xls, CVX) using SQL Server Management Studio (SSMS) and access and use the remote data and objects. Read More …

Exporting Data From SQL Server to Script File

SQL Server provides the ability to generate scripts for creating databases, tables, stored procedures, functions, views and inserting data. For Read More …

SQL Server – ANSI_Padding and Scripting from SSMS

Let’s say that you want to quickly create a table from an existing table in another database. If you are Read More …

Performing a Silent Install of SQL Server Management Studio (2016)

Send Us a Sign! (Contact Us!) Show More Info This article has total words. (Including header) With the release of Read More …

SQL Server Management Tools – Basic versus Complete

When, to install SQL Server Management Tools, you install SQL Server 2008 editions other than SQL Server 2008 Express, you Read More …

SQL Server memory performance metrics and bottlenecks

Let’s begin saying that monitoring any system is strongly recommended in an IT infrastructure, and for data analysis and good Read More …

Configure the Global Profile in Database Mail

After installing and configuring Database Mail on SQL 2005 or SQL 2008, when you try to send an email using Read More …

Configure SQL Server Database Mail to send email

If you are using SQL Server 2005 or higher, you might have noticed that there is now a “Database Mail” Read More …

WSUS – Range protocol header error and access Windows Internal Database MICROSOFT##SSEE

Microsoft products such as Windows Server Update Services (WSUS) 3.0 and Windows Sharepoint Services (WSS) 3.0 ship with SQL Server Read More …