SQL Performance – Using Query Hint OPTION (FAST N)
It is fun working with SQL/Application developer where you exchange a lot of technical thoughts to find the root of...
2018-03-21
7,284 reads
SQL Geek
New Built-in Function CONCAT_WS() – SQL Server 2017
In my previous post on new functions in SQL Server 2017, I discussed about the STRING_AGG function. Here, I am...
2018-03-02
1,358 reads
Set New Errorlog File location – SQL Server on Linux
For SQL Server 2017 RTM, the fourth cumulative update was released on 20th February, and it is available for download...
2018-03-08 (first published: 2018-03-01)
1,582 reads
New Built-in Function STRING_AGG() – SQL Server 2017
SQL Server 2017 introduces a set of useful functions like STRING_AGG(), STRING_SPLIT(), TRIM()… and many more. In this tip, I am...
2018-02-28
9,349 reads
Who installed SQL Server?
Recently, I was working with the team and got stuck up with SQL Server Installation information. We got an urgent...
2018-02-27
10,837 reads
Change the name of master database files – SQL Server on Linux
In my recent blog, I discussed about how to move master database to another location. One of the readers requested...
2018-02-26
729 reads
How to Move Master Database to Another Location – SQL Server On Linux
With the release of SQL Server 2017 CU4, you can use the mssql-conf utility to move the master database file...
2018-03-07 (first published: 2018-02-23)
2,065 reads
Capture SQL Server Reported Errors using Extended Events
In my introduction to Extended Events blog, I mentioned that the xEvent is my favorite toy for performance troubleshooting. This blog may...
2018-03-05 (first published: 2018-02-20)
8,074 reads
Extended Event Packages
I continue blogging on extended events. Today, I will discuss about the top level containers (Package) that gives access to...
2018-01-25
457 reads
Mapping SQL Trace to Extended Events
Since I started actively participating in SQL community, I found it is very common that people will approach to seek...
2017-12-19
1,858 reads
Blogs
Recovering a TDE Database Without the Certificate
If you don’t have the backups of the certificate and private key from the...
Daily Coping 31 Jan 2023
By Steve Jones
Today’s coping tip is to take a small step towards and important goal. One...
Tales From The Field Weekly Wrap Up for the Week of 01-23-2022
By SQLBalls
Hello Dear Reader! It's been a while since I had time to sit down...
Forums
how to become a digital marketer
i am from science background i want to shift my career in digital marketing...
Using a set based approach as opposed to Loop Based Procesing to Improve Perform
Hi there I have a script which processes and aggregates data. Now this is...
Newbie Azure Data Factory question.
Hello! When setting up a sink in ADF, what makes the "Preview data" button...
Ask SSC