With the release of SQL Server vNext CTP 1.4, the SQL Server Agent support is included. It enables DBAs to schedule any task using a SQL Server Agent Job on Linux machine. In this post, I will explain how to install the SQL Server Agent package on the Ubuntu system. Before you start installation SQL […]
SQL SERVER ON LINUX INSTALLATION – PART4 – Install SQL Server Tools on Ubuntu – Updated!
Read more
Installing SQL Server on Linux does not install SQL Server tools by default. You have to install it individually. In my previous posts of this series, I discussed how to create a virtual machine using Windows Hyper-V, how to install Ubuntu Server on the created virtual machine and how to install SQL Server on the […]
SQL Server 2017 – DMF – sys.dm_db_log_info
Read more
The release of Microsoft SQL Server 2017 brought a lot of very interesting new features. One of them is the addition of DMF sys.dm_db_log_info. It allows having a look at the structure of the transaction log without using the undocumented DBCC LOGINFO command. DMF – sys.dm_db_log_info It returns VLF information of the transaction log file […]
Top Function – Performance Gain
Read more
Recently, I presented at Singapore SQL Pass Chapter on the topic T-SQL Fun, and the most of the attendees were a developer. During the session, I discussed TOP function, and I throw a question to the audience – “Not using Top function especially when you can use it – Can it cause performance problem or […]
Log File Space Issue Monitoring Using SQL Server DMV
Read more
As a continuation of “Database Monitoring using DMV” series, this blog will cover how quickly you can address the log file space related issue. Below are the previous blogs which you may find useful in your everyday job. Disk Space Monitoring Using SQL Server DMV SQL Database File Wise Disk Space Monitoring To address the […]
SQL Server 2017 sys.dm_os_enumerate_fixed_drives
Read more
In SQL Server 2017, you can use the new DMV sys.dm_os_enumerate_fixed_drives to identify free disk space. The DMV is replacement of xp_fixeddrives. Old way XP_FIXEDDRIVES New Way SELECT * FROM sys.dm_os_enumerate_fixed_drives; I wish Microsoft could have included the capacity of the drive. Not including the drive capacity requires the DBA to perform additional computations to […]
SQL Server 2017 – The operating system returned the error 21
Read more
Recently, I was exploring SQL Server 2017 CTP 2.0 using SQL Server Management Studio V17. Till the time, I was restoring the databases using tsql script on the SQL Server 2017 instance, and I didn’t encounter any issue. But, When I tried to restore a database backup using GUI using SSMS V17, I encountered the […]
Setting Up a Subscription
Read more
In the last two blogs, we went through Configure Distribution Database and Publication Creation. If you haven’t read them, I will request you to go through before you start exploring this blog. If you don’t have the Subscription database, You must create your subscription database. Once you created the database, you’re ready to create your […]
Setting Up a Publication for Transaction Replication
Read more
In the previous blog, we discussed how to Configure Distribution Database. Once you setup your Distribution database successfully, you can create a publication. Here, we will learn how to create a publication for Transaction Replication and how many jobs get created after the publication setup. Create Publication I’ll walk you through step by step process […]
Configure Distribution Database
Read more
In this blog, we are going to learn about the Distribution database, how to configure the Distribution database, and how many jobs get created during the configuration of the Distribution database. Distribution Database Distribution Database is a system database. It contains many objects that keep replication metadata and replicated data information. Each Publisher is linked […]