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 …

Check mySQL and MariaDB Server Version

There are circumstances where you need to know the version of your database server, e.g., when upgrading the database or patching any known server vulnerabilities. There are a few ways to find out what the version of your MariaDB server is. 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 …

Active Directory – Schema Master FSMO Role

Schema Master is another FSMO role which is responsible for making changes to the Active Directory schema. The schema stores descriptions of all Active Directory classes and attributes (LDAP://cn=schema,cn=configuration,dc=). Read More …

Microsoft SQL Server – TCP Port vs TCP Dynamic Ports

The default instance of SQL Server will listen on port 1433 (unless you’ve changed it to something else). However, by default, named instances will use a dynamic port, and SQL Server Browser will determine which port has been allocated and direct traffic accordingly. Read More …

SQL Server Management Studio – Exporting CSV

Microsoft SQL Server Management Studio is a commonly-used bit of the Microsoft SQL Server installation, and a decent enough tool for browsing, querying and managing the data. 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 …