kohera-logo-regular.svg

Ten Commandments when you install SQL server

  1. Above all, Install SQL server with much fun and devotion.
  2. Preconfigure TEMPDB, not leaving defaults, for better throughput and performance.
  3. You shall protect the data and make back-ups as if it was the Chosen one.
  4. Test, Test and Test the restoring of data in order to anticipate on future disasters, this might be your salvation.
  5. Thou shallt install SQL server updates and patches after testing.
  6. Carve traceflags into stone, they can relieve the pressure and pain.
  7. Spend time setting up appropriate maintenance as if it were fitness to your body. It will keep your database healthy after you install SQL server.
  8. Make adjustments to default growth. Let databases grow by chunks wisely chosen in megabytes.
  9. Tailor your degree of parallellism and Cost treshold for parallellism.
  10. As an addendum, consider using volume maintenance tasks, lock pages in memory.

Parameter sniffing solved with new Parameter Sensitive Plan Optimization feature

If you’re someone that works a lot with Microsoft SQL Server, there’s no doubt that you’ve had issues with an issue called “Parameter sniffing” before. Up until now, you had...

Creating maps with R and Power BI

The possibilities are infinite when it comes to creating custom visuals in Power BI. As long as you have creativity and knowledge about the right programming language, you can let...

Sending monitoring alerts through Telegram

What if you could get the ease of phone notifications for whatever monitoring alerts you need? Then we have a solution for you with the app Telegram. Some of you...

Send mails with Azure Elastic Database Jobs

The DatabaseMail feature in SQL Server and Managed Instance is widely used by many professionals. But what if you want a similar functionality in Azure SQL Database? There are options,...

Sorting matrices in Power BI

Recently I worked on a Power BI project for a client. They had a SharePoint site where they regularly published articles and wanted to pour view data into a report...

The world of data is evolving

The data landscape has changed dramatically over recent years. In the past, we mainly heard that we needed to do as much as possible “cloud-only”—but this trend has become more...