Install SQL Server Agent on Ubuntu (Linux)
With the release of SQL Server vNext CTP 1.4, the SQL Server Agent support is included. It enables DBAs to...
2017-06-16
3,057 reads
Dharmendra Keshari
Log File Space Issue Monitoring Using SQL Server DMV
As a continuation of “Database Monitoring using DMV” series, this blog will cover how quickly you can address the log...
2017-06-14 (first published: 2017-05-31)
5,722 reads
SQL SERVER ON LINUX INSTALLATION – PART4 – Install SQL Server Tools on Ubuntu – Updated!
Installing SQL Server on Linux does not install SQL Server tools by default. You have to install it individually. In...
2017-06-13
1,664 reads
SQL Server 2017 – DMF – sys.dm_db_log_info
The release of Microsoft SQL Server 2017 brought a lot of very interesting new features. One of them is the...
2017-06-12
957 reads
Top Function – Performance Gain
Recently, I presented at Singapore SQL Pass Chapter on the topic T-SQL Fun, and the most of the attendees were...
2017-06-05
452 reads
Configure Distribution Database
In this blog, we are going to learn about the Distribution database, how to configure the Distribution database, and how...
2017-05-18 (first published: 2017-05-06)
11,907 reads
SQL Server 2017 – The operating system returned the error 21
Recently, I was exploring SQL Server 2017 CTP 2.0 using SQL Server Management Studio V17. Till the time, I was...
2017-05-15
4,628 reads
SQL Server 2017 sys.dm_os_enumerate_fixed_drives
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...
2017-05-15
1,505 reads
Setting Up a Subscription
In the last two blogs, we went through Configure Distribution Database and Publication Creation. If you haven’t read them, I...
2017-05-10
3,567 reads
Setting Up a Publication for Transaction Replication
In the previous blog, we discussed how to Configure Distribution Database. Once you setup your Distribution database successfully, you can...
2017-05-09
2,792 reads
Blogs
Set Theory vs. Batch Mode in SQL Server
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Monday Monitor Tips: The Jobs Report
By Steve Jones
A customer wanted a report they could email to their boss about jobs, something...
Automating SQL Maintenance: How DevOps Principles Reduce Downtime
By Chris Yates
In the world of modern data infrastructure, SQL databases remain the backbone of enterprise...
Forums
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
All the Costs of Downtime
Comments posted to this topic are about the item All the Costs of Downtime
How Well Does the MSSQL Extension in VSCode Work?
Comments posted to this topic are about the item How Well Does the MSSQL...
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers