Pages

▼
Thursday, 4 March 2021

Don't Place the Blame on SQL Server

›
I have never worked for Microsoft, but SQL Server has given me a lot in terms of learning, community and opportunities, all these together h...
2 comments:
Monday, 22 February 2021

Cryptography is Everywhere

›
Historically, cryptography was used for secret communication by exclusive sectors only — such as governments, military and spies — since it ...
7 comments:
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...