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 …

Microsoft SQL Server SSIS – The RPC server is unavailable

Once installed Microsoft SQL Server SSIS (Integration Services) on a Windows Server node, when you try connect to it remotely (SQL Server Integration Service) directly from SSMS you could see an error related to “The RPC server is unavailable”. Read More …

SQL Server – Performance Best Practices

Talking about SQL Server optimization, query tuning is often the fastest way to accelerate SQL Server performance. Most often system-level Read More …

Windows 7 – Windows Server 2008 – Skip the KB4480970 Update (Bug)

The Windows 7 KB4480970 is one of those updates that will bring a lot of pain on multiple Windows 7 and Windows Server 2008 (and probably 2008 R2) systems. This is the first Patch Tuesday of 2019 and is all about security. 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 …

Triggers – SQL Server

In SQL Server, a trigger is a special type of stored procedure which will run automatically in response to some Read More …

Backup Paths and File Management (SQL Server)

How often do you execute a SQL Server backup on a remote server and then say to yourself, “Oh I Read More …