Infrastructure at your Service

Tag

Microsoft Archives - Blog dbi services

Stéphane Haby

SQL Server: Replace the old SCOM login by the new one

By | Database Administration & Monitoring, Database management, SQL Server | No Comments

It’s every time hard to replace a login who as role and permissions in every database like the service account for SCOM. In the previous version of Scom, you create a service account (dbi\scom) to access the SQL Server and check the health of the databases. Now it’s possible to use the System Center Operations Manager Health Service (NT SERVICE\HealthService). To do this change on all SQL Servers, I write a script. I create the…

Read More
Stéphane Haby

Copy or Migrate a SSISDB environment 2.0

By | Database Administration & Monitoring, Database management, SQL Server | No Comments

Based on the blog “Copy or Migrate a SSISDB environment” of my colleague Christophe, I create a new one named 2.0. In the precedent script, you need to give the folder name and environment name and he generates all environment variables for these 2 parameters. In my case, I need to generate all folders and what are in these folders. The 2.0 script will generate the creation of the folder and the environment name if…

Read More
Stéphane Haby

First steps on Kusto Query Language (KQL)

By | Database Administration & Monitoring, Database management, Development & Performance, SQL Server | No Comments

Do you know this query language?  No, it’s time to explain you and see what it is.   “A Kusto query is a read-only request to process data and return results.” dixit Microsoft Documentation here The KQL is very simple to understand and use. I can do it then you can also do it! 😛 The first thing to know is how to call the information on a table. In this case you  need to…

Read More
Karsten Lenz

Microsoft Flexible Server for PostgreSQL

By | Postgres | No Comments

This Blog is about some findings on Microsoft’s new Flexible Server offering for PostgreSQL which is in Customer Preview at the moment. Findings about the infrastructure The Microsoft Flexible Server for PostgreSQL is using Ubuntu as OS infrastructure, I think it is worth to be noticed that Microsoft’s new offering is switching from Windows to Linux. postgres=> select version(); version —————————————————————————————————————– PostgreSQL 12.5 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.12) 5.4.0 20160609, 64-bit Ubuntu upgrade…

Read More
Stéphane Haby

SQL Server tips: How to migrate database-users in another domain without touching permissions

By | Database Administration & Monitoring, SQL Server | One Comment

By a customer, I must migrate a database from a domain to another. The goal is to keep the database-user permissions, take the new SID from the windows login of the new domain and change the database-user name. In my blog, I will do it with two dbi’s domains: – dbiservicech: The old domain – dbiservicecorp: The new domain I have two Windows groups dbiservicech\dbi-owner and dbiservicech\dbi-reader in my database test-dbi. I create two new…

Read More
Olivier Spiesser

Microsoft Teams, Power Automate and Planner

By | Database Administration & Monitoring | No Comments

As we moved to Teams at dbi and one of our customers, automating tasks was a strong need. One of the tasks that could be automated is the creation of tasks in Microsoft Planner which does not support recurring tasks. Every 4 weeks, we are patching the environment. For everyone awareness and follow up, we need to publish these dates in the planning. As the pace of these tasks is known, it is a bit…

Read More
Stéphane Haby

SQL Server Tool: MSSQL-CLI

By | Database Administration & Monitoring, Database management, SQL Server | No Comments

MSSQL-CLI is a useful new command line tool. Not so new because this tool exist since 2018 but a little bit unknow. You find this tool on GitHub here. One of the big advantage is the number of platforms available, Windows of course but also macOS, Ubuntu, Debian, CentOs, Red Hat, OpenSuse, Suse Enterprise and Fedora. This interactive command-line query tool has many advantages like the full IntelliSense support, the auto-complete, the syntax highlighting, the…

Read More
Stéphane Haby

SQL Server Temporal Table – How to store a history table in another file?

By | Database Administration & Monitoring, Database management, SQL Server | 2 Comments

Few days ago, a customer asks me if it is possible to move the history table to slower but cheaper storage. The question behind this is whether it is possible to create a history table on a separate filegroup and file. Few years ago, I write a serie of blogs about temporal table here. I will take the same example to try to set up a filegroup specific to a history table. In my sample,…

Read More
Stéphane Haby

SQL server security pre-conference @SQL Pass Summit 2018 in Seattle

By | Database Administration & Monitoring, SQL Server, Technology Survey | No Comments

After long hours of flights, Christophe Cosme and I finally arrived in Seattle at the SQL PASS Summit 2018. We picked up our badge and bag and now we are ready to begin… This first day for me started with the pre-conference about SQL Server Security with Denny Cherry. Many topics were discussed like: Network Designs (such as public IP vs. Private IP) Firewall configurations (such as Network Design between Public network, Internal network and…

Read More
Stéphane Haby

SQL Server Tips: How many different datetime are in my column and what the delta?

By | Database management, Development & Performance, SQL Server | No Comments

Few months ago, a customer asks me for finding in a column, how many rows exist with the same date & time and the delta between them. The column default value  is based on the function CURRENT_TIMESTAMP and used as key as well. This is obviously a very bad idea but let’s go ahead… This anti pattern may lead to a lot of duplicate keys and the customer wanted to get a picture of the…

Read More