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.
Group of computer programmers working in the office. Focus is on blond woman showing something to her colleague on PC.
  • Kohera, Power BI
Updating your Azure SQL server OAuth2 credentials in Power BI via PowerShell for automation purposes
The better way to update OAuth2 credentials in Power BI is by automating the process of updating Azure SQL Server...
Read more
2401-under-memory-pressure-featured-image
  • Kohera
Under (memory) pressure
A few weeks ago, a client asked me if they were experiencing memory pressure and how they could monitor it...
Read more
2402-fabric-lakehouse-featured-image
  • Fabric
Managing files from other devices in a Fabric Lakehouse using the Python Azure SDK
In this blogpost, you’ll see how to manage files in OneLake programmatically using the Python Azure SDK. Very little coding...
Read more
2319-blog-database-specific-security-featured-image
  • SQL Server
Database specific security in SQL Server
There are many different ways to secure your database. In this blog post we will give most of them a...
Read more
kohera-2312-blog-sql-server-level-security-featured-image
  • SQL Server
SQL Server security made easy on the server level
In this blog, we’re going to look at the options we have for server level security. In SQL Server we...
Read more
blog-security_1
  • Kohera, SQL Server
Microsoft SQL Server history
Since its inception in 1989, Microsoft SQL Server is a critical component of many organizations' data infrastructure. As data has...
Read more
koherasymbol.svg

© 2023 Kohera

Crafted by  logo van uncoded

koherasymbol.svg

© 2022 Kohera

Crafted by