Category: Standards
Guide available for enhancing privacy and addressing GDPR requirements with the Microsoft SQL platform

Guide available for enhancing privacy and addressing GDPR requirements with the Microsoft SQL platform

The EU Global Data Protection Regulation (GDPR) goes into effect on May 25, 2018 - and we know that many of you are searching for guidelines and recommendations for how to ...

READ MORE +
0
CAST vs. CONVERT

CAST vs. CONVERT

Datatype conversion is a common scenario that we face while writing SQL queries. Cast and Convert are two functions provided by SQL for this purpose. But what is the difference ...

READ MORE +
0
What are naming standards/conventions for SQL Server? (1/5)

What are naming standards/conventions for SQL Server? (1/5)

I think it will be good idea to setup some naming standards throughout your database servers’ farm. Most of us already have these standards in place. And if there is nothing, I ...

READ MORE +
0
Common Human Errors as DBA (Part 3)

Common Human Errors as DBA (Part 3)

  In continuation of the series of “Common Human Errors as DBA” – here I am posting Third Part of it. You may check others here. Part 1 & Part 2 Poor naming ...

READ MORE +
0
Is tempdb configured correctly?

Is tempdb configured correctly?

Let’s learn about tempdb and some of the best practices about tempdb. Before doing this, let’s talk about tempdb and its usage. A Tempdb is a system database that is available ...

READ MORE +
0
MAXDOP – What is best approach to use it!!!

MAXDOP – What is best approach to use it!!!

The Maximum Degree of Parallelism (MAXDOP) setting will determine the degree to which SQL server will attempt to parallel process transactions which are received from the ...

READ MORE +
0
Database Accidents : Unwanted Restore

Database Accidents : Unwanted Restore

Number of times, while working as a DBA many accidents happen. Most common of them is when a database is restored without checking if a backup is available or not. As a thumb rule ...

READ MORE +
0
Fragmentation of Log files and VLFs

Fragmentation of Log files and VLFs

In a SQL server, having multiple log files does not have any performance benefits as the log files are written sequentially. The log files can have external (disk level) ...

READ MORE +
0