SQL 2019 INSTALLATION

SQL 2019 Installation: Tips & Tricks

By Maninder Sing, Principal Consultant SQL Server 2019 has made available 2 core features during the installation(Among a few other like SSIS Scale out which was also available in SQL 2017 ) The 2 Core features available during the installation are Memory settings and MAXDOP settings. I personally believe this is a excellent thing to […]

READ MORE
The Usefulness of a Little R in SQL

Work smarter: Little R

By Rohit Khadka, Sr. Database Administrator At some point of our DBA career, we all have had an opportunity to run a set of scripts one by one for each instance until your fingers and mouse gave up. Then, we came back to work next day with a bandage wrapped around our fingers and continue […]

READ MORE
SQL Server and PowerShell Automation – DBATools

SQL & PowerShell

By Rohit Khadka, Sr. Database Administrator Many of us – Production DBAs, at some of our career have had to work with PowerShell to perform operations outside of SQL Server. Sometimes, this task can be a bit intimidating considering that it wasn’t really part of the job description (let’s just admit that we didn’t read […]

READ MORE