Pages

▼
Friday, 15 January 2021

Do You Want to Be a Cryptographer?

›
Alan Turing I've always been interested in information security since 2003, but it wasn't until I enrolled on the cryptography modul...
Monday, 30 July 2018

Installing a stand-alone SQL Server 2017 instance step by step

›
Undoubtedly, many of us have the task of installing a new stand-alone SQL Server instance which includes the database engine service only. F...
Tuesday, 20 March 2018

Configuring Read-Only Routing and load-balancing across Read-Only replicas

›
With the arrival of AlwaysOn Availability Group in SQL Server 2012, implementing HA+DR solutions have been an easier and not expensive task ...
Saturday, 17 February 2018

Quickly Checking for Stale Statistics in SQL Server

›
Monitoring the state of database statistics is crucial because they significantly influence overall performance. When statistics become outd...
2 comments:
Tuesday, 13 February 2018

Avoid changing default ANSI database options

›
Not having another way of fixing some specific errors, at times some people may consider turning off any ANSI database options as a final s...
Sunday, 21 January 2018

How to make uniform all the collations of table columns for all databases

›
Clearly, it is of paramount importance to standardise the collations for all databases in a SQL Server instance in order to avoid dealing wi...
Friday, 12 January 2018

MSSQL_ENG003165: An error was encountered while replication was being restored/removed. The database has been left offline

›
While restoring a replicated database without KEEP_REPLICATION  option, SQL Server will remove replication settings by executing  sp_restore...
Thursday, 4 January 2018

Table-valued user-defined functions and the database collation

›
When it comes to altering database collations we may face some problems that tend to slow us down at the beginning. Nevertheless, digging in...