Infrastructure at your Service

Tag

PowerShell Archives - Blog dbi services

Daniel Westermann

Publishing a PowerShell script to AWS Lambda

By | AWS | No Comments

I’ve done some Lambda functions with Python in the past and it was quite easy to publish that to Lambda (by just uploading a zip file with all my code and dependencies). You might ask yourself why I want to do that with PowerShell but the reason is quite simple: There was a requirement at a customer to automatically collect all the KBs that are installed in the AWS Windows WorkSpaces for compliance reasons. Doing…

Read More
Steven Naudet

How to create an Azure SQL Database using Azure PowerShell

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

In this blog post, I’ll go through the steps to create an Azure SQL Database using Azure PowerShell. Introduction to Azure SQL Database The SQL database services provided by Microsoft on the cloud are now grouped under the name of Azure SQL. The Azure SQL family contains services that I will briefly summarize; Azure SQL Database – DBaaS (Database-as-a-Service) Azure SQL Managed Instance – PaaS (Platform-as-a-Service) SQL Server on Azure VMs – IaaS (Infrastructure-as-a-Service) In…

Read More
Steven Naudet

SQL Server: Synchronize logins on AlwaysOn replicas with dbatools

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

The SQL Server environment  I worked with today has dozens of SQL Server instances using AlwaysOn Availability Groups for High Availability. When a login is created on the Primary replica of an Availability Group it is not synchronized automatically on secondary replicas. This might cause some issues after a failover (Failed logins). Since this is not done automatically by SQL Server out of the box the DBA has to perform this task. To avoid doing…

Read More
Stéphane Savorgnano

How to run Avamar backup on SQL Agent Job with PowerShell

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

By one of our customer we use Avamar for the backup and restore solution. I was asked by this customer to find a solution to run Avamar backups for a group of databases on a specified instance. In fact, we currently try a database clone solution on some instances and clone’s databases must not be backed up, but the rest of the databases must be. After some discussions with my colleague I decided to use…

Read More
Steven Naudet

SQL Server: Quickly clean backup history with dbatools

By | Database Administration & Monitoring | No Comments

I just had to restore a database in production for my customer. Before doing the restore I have the habit to query the msdb.dbo.backupset table to get an overview of the last backups. When running my query, I felt it was taking longer than usual. So out of curiosity, I looked at the SSMS standard report “Disk Usage by Top Tables”. Here is the output. This instance contains dozens of databases in Always On Availability…

Read More
Nathan Courtine

Restore S3 Object with AWSPOWERSHELL

By | Cloud | No Comments

AWS S3 offers different Storage Classes, allowing to optimize cost among others. For instance, some classes are used for archiving purposes: S3 Glacier and S3 Glacier Deep Archive. It means the storage cost is the lowest you can obtain, but your data is not available immediately and the access cost is increased. In the case of S3 archive classes, retrieving the data is not cost-effective because this is clearly not what it is aimed for….

Read More
Christophe Cosme

SQL Server – Collecting last backup information in an AlwaysOn environment

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

Introduction Sometimes you face interesting challenges with unusual environment. One of my customer needed a automated and flexible backup solution. Said like that nothing very complex you will say. But if I mention that some databases were 60TB big with more than 30 filegroups and around 600 database data files each and moreover synchronized in an AlwayOn availability group, it is not the same story and you can easily imagine that working with standard backup…

Read More
Microsoft Team

How To Deploy Office Web Apps Server 2013

By | Application integration & Middleware, Entreprise content management | No Comments

The 4 Steps Of Office Web Apps Server 2013 Installation Office Web Apps provides browser-based versions of Excel, One Note, Word and PowerPoint. It also helps users who access files through SharePoint 2013. The objective of this topic is to define the steps to install office web apps 2013, create the farm and the binding so that it can be used within SharePoint 2013 test environment. For this example, we have the following systems in…

Read More
Stéphane Savorgnano

Pass Summit 2017

By | Database Administration & Monitoring | No Comments

Today starts the Pass Summit 2017 taking place in Seattle. After a small fly over the Ocean, more than 10 hours… yesterday, and a nice jet lag which avoid me to sleep later than 4AM this morning, I arrived to the Convention Center in Seattle where the Pass takes place. I start this first day by the session of Itzik Ben-Gan: T-SQL Tips and Tricks. As part of the session, Itzik spoke about batch processing…

Read More
Stéphane Haby

Live from SQL Saturday Slovenia 2016!

By | Technology Survey | No Comments

After a little trip, just 1-hour flying from ZĂĽrich to Ljubljana yesterday, the SQL Saturday Slovenia 2016 begins this morning at the Faculty of Computer and Information Science of the University of Ljubljana… I needed to wake up very fast because my session was the first of the day at 9:00 AM. I also very happy to meet and to share my expertise with Slovenian and other SQL Server experts. My session was about the…

Read More