Cloud, Database management, SQL Server, Technology Survey Striim, first step 04.04.2022 by Stéphane Savorgnano In this blog-post I will discuss about my first test with Striim. Striim is a data integration platform which can ingest real-time data from a variety of sources (SQL Server, Oracle, Kafka, Hadoop…) and quickly deliver it to Cloud(…)
Business Intelligence, Development & Performance, SQL Server SSDT offline installation for Visual Studio 2019 25.03.2022 by Christophe Cosme Introduction Before Visual Studio 2019, you were able to install the SSDT with the offline installer. You were able to install it as a standalone Visual Studio for SSDT or for an already installed Visual Studio 2017. It was(…)
Database Administration & Monitoring, Database management, SQL Server How to solve Stored Procedure parameter sniffing problems 11.03.2022 by Stéphane Savorgnano Since Tuesday, I have the chance to follow the SQLBits 2022 conference. Sadly, I have to do it remotely this year but I promise next time I will come in-person 😉 SQLBits is one of the largest(…)
SQL Server SQLBits 2022 – Levelling up my Performance Tuning skills 10.03.2022 by Steven Naudet As a consultant at dbi services, I am lucky enough to have time dedicated to training and conferences. This week I have the chance to attend one of the most important conferences for Data professionals: SQLBits 2022.
Cloud, Database Administration & Monitoring, MariaDB, MySQL, Oracle What I really like about Percona PMM 14.01.2022 by Elisa Usai Percona Monitoring and Management tool (PMM) is an Open Source product which was developed to help DBAs and developers to monitor and manage MySQL, PostgreSQL and MongoDB performances. In this blog post, we will see that we(…)
Database Administration & Monitoring, Database management, SQL Server SQL Server: msdb too big with the table dbo.sysmaintplan_logdetail 28.12.2021 by Stéphane Haby Today, I was by a new customer and the I see that the msdb data file was over 4GB. A little too big… To see which table are so big, in SSMS, I select the msdb database, right-click, go in(…)
Database Administration & Monitoring, Database management, SQL Server SQL Server: Cannot execute as the database principal “dbo” does not exist 27.12.2021 by Stéphane Haby By a customer this month, I see a very big big ErrorLog file (more than 1,5GB). When I open the file, every 5 seconds, the following message is added: The activated proc ‘[dbo].[IdentityServerNotificationCleanup]’ running on queue ‘<database>.dbo.IdentityServerNotificationsQueue’(…)
Database Administration & Monitoring, Database management, Development & Performance, SQL Server SQL Server: how to have the number of core-based licenses used on my environment? 08.12.2021 by Stéphane Haby This week, a customer asks me to find out how many SQL Server Standard licenses are used in their environment. The licensing is core based and to not be used for Sserver + Cals licenses. To have an idea,(…)
Database Administration & Monitoring, Database management, SQL Server SQL Server – Granting SQL Server permission to service SID 22.11.2021 by Christophe Cosme Introduction We know that SQL Server itself is using it own SID NT SERVICEMSSQL$ and NT SERVICESQLAGENT$ to grant permission to the database engine and the SQL agent services. But the same method can be used for other application(…)
Database Administration & Monitoring, Database management, SQL Server SQL Server database design – Moving table to new filegroups 15.11.2021 by Christophe Cosme Introduction A database is very often created without thinking of its growing and in the most cases that is not really an issue until the data volume is not increasing a lot. And most of the time when a high(…)