Dharmendra Keshari

Dharmendra is a SQL Server/Microsoft Data Platform professional with over eight years of experience. He enjoys helping others in the SQL Server community and does this by contributing on blogs, speaking at several SQL events. His passion and focus is to explore and share more and more on SQL Server.

Install SQL Server Agent on Ubuntu (Linux)

by Dharmendra Keshari

SQL Geek

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,039 reads

Log File Space Issue Monitoring Using SQL Server DMV

by Dharmendra Keshari

SQL Geek

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,685 reads

SQL SERVER ON LINUX INSTALLATION – PART4 – Install SQL Server Tools on Ubuntu – Updated!

by Dharmendra Keshari

SQL Geek

Installing SQL Server on Linux does not install SQL Server tools by default. You have to install it individually. In...

2017-06-13

1,662 reads

SQL Server 2017 – DMF – sys.dm_db_log_info

by Dharmendra Keshari

SQL Geek

The release of Microsoft SQL Server 2017 brought a lot of very interesting new features. One of them is the...

2017-06-12

956 reads

Top Function – Performance Gain

by Dharmendra Keshari

SQL Geek

Recently, I presented at Singapore SQL Pass Chapter on the topic T-SQL Fun, and the most of the attendees were...

2017-06-05

449 reads

Configure Distribution Database

by Dharmendra Keshari

SQL Geek

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,582 reads

SQL Server 2017 – The operating system returned the error 21

by Dharmendra Keshari

SQL Geek

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,624 reads

SQL Server 2017 sys.dm_os_enumerate_fixed_drives

by Dharmendra Keshari

SQL Geek

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,475 reads

Setting Up a Subscription

by Dharmendra Keshari

SQL Geek

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,470 reads

Setting Up a Publication for Transaction Replication

by Dharmendra Keshari

SQL Geek

In the previous blog, we discussed how to Configure Distribution Database. Once you setup your Distribution database successfully, you can...

2017-05-09

2,706 reads

Blogs

Using Cron in Postgres Flex

By hellosqlkitty

pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...

Can I Change a Primary Key Value? #SQLNewBlogger

I heard someone say recently that you can’t change a primary key value in...

SQL Server Index Primer

Indexes 101: What, Why, and When? “What Is an Index?” I get this question...

Read the latest Blogs

Forums

50 Years of Microsoft

By Steve Jones - SSC Editor

Comments posted to this topic are about the item 50 Years of Microsoft

Multiple Collations

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Collations

Retrieving Data Using the REST API in Data API Builder

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Retrieving Data Using the REST...

Visit the forum

Question of the Day

Multiple Collations

Can I have a collation expression like this in SQL Server 2022?

...
WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS
...

See possible answers