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 […]
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 […]
Things you are doing wrong in SQL Server (and how to do them right). With our CEO, Jeff Garbus.
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 […]
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 […]
Scaling refers to increasing a company’s computing resources to manage the exponential growth of work. Simply put, it is the ability of a database to expand the output as load increases. Under heavy loads, the database can slow or even collapse, crippling business operations Scaling the database can be extremely challenging and demands a far […]
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. […]
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 […]
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, […]