Migrating on-premise Microsoft SQL Server to Azure
Interested in migrating your on-premise Microsoft SQL Server to Azure? One of Guru DBAs, Maninder Singh, has created this detailed presentation on moving SQL Server VMs to Microsoft Azure.
Category: Database Administration
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 […]
Automating SQL Server Installation
By Rohit Khadka, Sr. Database Administrator As a Production DBA, I have had the opportunity to do an upgrade/migration from SQL Server 2012 to SQL Server 2016. During the process, I realized that installing a new SQL Server on 20-30 servers in a short time was going to be challenging and monotonous. Going through the […]
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 […]
SQL Tips and Tricks with Jeff Garbus
Things you are doing wrong in SQL Server (and how to do them right). With our CEO, Jeff Garbus.
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 […]
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 […]
So you are going from 1 server to 10, are you ready to Scale your Databases?
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 […]
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. […]