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
Eliminating Redundant Indexes

Reclaiming Space

Recently I was called into a shop that had a 4 terabyte database, who claimed they didn’t have anywhere near that much data. Upon investigation, they were correct. They had about 100 gig of data, and about 3.9 T of indexes. Is this too much? Well, in order to make that kind of judgement call […]

READ MORE

What’s New in MS SQL 2019

Like all previous versions, Microsoft SQL Server 2019 is packed with new features and capabilities. Let’s look at some of the most helpful features for database management systems (DBMS). Indexing One of the new capabilities is related to indexing. If indexing goes wrong, SQL Server 2019 gives DBAs the tools to deal with such situations. […]

READ MORE

How Does Database Performance Affect Your Business?

Database failure could turn into an ordeal for CTOs and IT Managers. Making sure that database systems operate efficiently is a core requirement of modern IT management. Several tools can help database administrators monitor, maintain, and improve the performance of databases. But before considering the need for database performance software, it’s essential first to understand […]

READ MORE
database monitoring

How Does Database Activity Monitoring Work?

According to techopedia.com, database activity monitoring (DAM) is a fairly established technology, existing over a decade, which is in charge of observing, identifying, and reporting a database’s activities. DAM tools use real-time security technology to provides alerts and reports to analyze configured activities independently. These tools also help detect irregular activities, whether internal or external, […]

READ MORE