analyze Windows Perfmon
Using Power BI to analyze Windows Perfmon data for SQL Server
27 Jan 2020

In this second blog post for my series, Power BI for the SQL Server DBA, I’m going to show how you can take Windows Perfmon (Performance Monitor) data for SQL Server and analyze it with Power BI.
I’m going to assume that as an SQL Server DBA, you probably have not used Power BI yet. If you have some familiarity with Power BI, I hope there are still gems you can pull out of this blog post.

optimize SQL Server performance on AWS EC2
Capturing performance counters to optimize Microsoft SQL Server performance on AWS EC2 instances
22 Jan 2020

Over the last few months of benchmarking SQL Server performance on AWS, I discovered a way to optimize SQL Server performance running on EC2 instances by paying close attention to several key Windows performance counters. This blog post is the first in my new series called Power BI for the SQL Server DBA. I’m going to show how you can easily capture performance counters to optimize SQL Server performance and cost on AWS EC2 instances. I’m going to start with […]

SQL Server statistics update
Improve SQL Server statistics update 1000 times faster than traditional approaches
22 Nov 2019

One of the customers contacted DB Best to help address performance issues with their SQL Server application. They started experiencing problems after upgrading from SQL Server 2008 R2 up to SQL Server 2016. However, after we analyzed their database system, we discovered a complex issue with updating SQL Server statistics.
We utilized industry best practices and internal expertise to correct issues. Read our blog post to learn how we approached this complex task.

testing code changes
How to test breaking changes and new features during the SQL Server upgrade
12 Nov 2019

Our fully automated Migration Platform confidently guides you through an upgrade project. Read the blog post and watch the related video to discover how you can use the DB Best Migration Platform to test breaking changes and new features during the SQL Server upgrade.

Oracle virtual columns SQL Server
Converting Oracle virtual columns to Microsoft SQL Server
19 Sep 2019

In Oracle, you can specify virtual columns in a table definition. However, when migrating your Oracle database to Microsoft SQL Server, you need to utilize computed columns. You may want to use SSMA to automate the conversion. The problem is that SSMA does not correctly convert source Oracle virtual columns to SQL Server. So, you will need to update the converted code manually.
Read this blog post to discover our proven solution to Oracle virtual columns conversion to Microsoft SQL Server.

setting up SQL Server on Linux
Greater performance with lower cost with SQL Server on Linux Data Warehouse
26 Aug 2019

Our customer’s data science team needed to perform read-only data warehouse queries against a mission-critical online transaction and batch processing database. They were performing read-only queries over 4 terabytes of historical data. These queries are ad-hoc and look at multiple months of historical data for analysis. The queries would consume all available I/O on the production databases environment and impede the performance of the primary workload. This blog talks about how we helped them solve this problem.

Convert Oracle sequences
Converting Oracle sequences to Microsoft SQL Server
15 Aug 2019

In Oracle, you can use a combination of a trigger and sequence to generate unique values for the key columns. However, when migrating your Oracle database to Microsoft SQL Server, you need to find the right path to convert this construction. This is an architecture-level decision, so you need to approach it at the very beginning of your migration project. Otherwise, you will need to recreate tables, reload data and recreate backups, and even rewrite code that relates to these tables.
Read this blog post to discover our proven solution to Oracle sequences conversion.

cleaning-up-sql-server
Cleaning up a disorganized SQL Server for informed business decisions
26 Jul 2019

For quite a period of time, our customer was using a SQL Server database that at the long last became disorganized and fairly difficult to arrange. The difficulties with finding and retrieving the right data negatively influenced their performance. In addition, their server was storing duplicating views and tables that utilized space. The problem Our customer considered hiring several data analysts to reinforce their team. However, extra people in the team couldn’t address the challenge for they weren’t aware of […]

naming convention
Defining a naming convention in Oracle to SQL Server migrations
17 Jul 2019

When migrating Oracle databases to Microsoft SQL Server, you need to define a naming convention for the conversion of packaged procedures and functions. This step is as important as setting the schema mapping and data type mapping. This is an architecture-level decision that you should make at the very beginning of your migration project. Read this blog post to discover the importance of this decision and the possible issues it may cause.

convert SQL Server Standard edition to Developer Edition
How to convert a development server running SQL Server Standard or Enterprise edition to Developer edition
03 Jul 2019

I recently had a client using SQL Server 2012 Standard Edition on three of their development servers. However, SQL Server 2012 has a developer edition that is specifically designed for development servers. More importantly, our client has free SQL Server 2012 Developer edition licenses as part of the paid SQL Server Standard Editon purchase.
Our customer decided to convert their Standard Edition to the Developer Edition so they could save big bucks. However, the conversion process can be a bit tricky. In this blog post, we will show how you can easily convert SQL Server Standard Edition to the Developer Edition.