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

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 ...

0
CAST vs. CONVERT
0

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 ...

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

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 ...

0
Common Human Errors as DBA (Part 3)
0

  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 ...

0
Is tempdb configured correctly?
0

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 ...

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

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

0
Database Accidents : Unwanted Restore
0

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 ...

0
Fragmentation of Log files and VLFs
0

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 ...