The use of statistics in SQL Server is tightly embedded in the query optimizer and query processor. The creation and maintenance of statistics is usually handled by the SQL Server engine, though many DBAs and developers know that periodically we might need to update those statistics to ensure good performance of queries. SQL Server 2019 gives us more options.
This Data Saturday Event is being jointly developed by the Albuquerque Data Platform Users Group, Arizona Data Platform Users Group, and the Santa Fe Data Platform Users Groups. This event will include sessions on many Microsoft Data Platform related topics. Join us on May 15, 2021.
Learn about best practices for developing SSIS packages that you want to execute from SQL Server Agent and the steps to follow.
Our annual mental health and wellness day is slated to happen on 8th April 2022. We have a fantastic lineup,schedule as below. For more details on speakers and sessions refer to our blog post here.
SQL Server post migration step is very crucial for reconciling any data accuracy and completeness, as well as uncover performance issues with the workload.
In this article, we are going to learn the basics of SQL unit testing and how to write a SQL unit test through the tSQLt framework.
In this article, learn how to control access levels to various data and parts of Power BI reports using row-level security as well as column and object-level security.
Some advice from Steve and Sam Altman, whether you work in business or want to build one.
This article shows how to use Python to access data in SQL Server and produce a K-Means analysis with a chart.
Imagine this: you have several directories full of SQL script files, and you need to know where a certain table is used. You’d rather like the context too, so you can check the whole SQL Expression and work out why it is running so slowly.
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
WA:08218154393 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
WA:08218154393 Jl. Kauman No.25, Magersari, Krian, Kec. Krian, Kabupaten Sidoarjo, Jawa Timur 61262
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Can I set Accelerated Database Recovery on tempdb?
See possible answers