Infrastructure at your Service

Tag

PowerShell Archives - Blog dbi services

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
Nathan Courtine

Manage Azure in PowerShell (RM)

By | Database Administration & Monitoring, Hardware & Storage, Operation systems | No Comments

Azure offers two deployment models for cloud components: Resource Manager (RM) and Classic deployment model. Newer and more easier to manage, Microsoft recommends to use the Resource Manager. Even if these two models can exist at the same time in Azure, they are different and managed differently: in PowerShell cmdlets are specific to RM. In order to be able to communicate with Azure from On-Premises in PowerShell, you need to download and install the Azure…

Read More
Nathan Courtine

Generate Azure VM with Resource Manager deployment in PowerShell

By | Database Administration & Monitoring, Hardware & Storage, Operation systems | No Comments

Recently, there is a new way to manage the Azure infrastructure with Resource Manager. It brings many advantages regarding the classic deployment. The differences between these two deployments will not be covered in this blog because it is not the initial goal, and it already exists a very good Microsoft topic on this subject. In this blog, we will generate a new Windows Azure Virtual Machine using Resource Manager deployment with PowerShell from On-Premise. Remember,…

Read More
Stéphane Haby

SQL Server 2016: New SQL PowerShell CMDLETs for ErrorLog

By | Database Administration & Monitoring | No Comments

With the latest release of SQL Server Management Studio(SSMS) 2016 (13.0.15500.91), downloadable here, was introduced new CMDLETs for Always Encrypted, SQL Agent and the  ErrorLog. In this article, I will present you the 2 new CMDLETs for the Error Logs: Get-SqlErrorLog: Retrieves the SQL Server Logs. Set-SqlErrorLog: Sets or resets the maximum number of error log files before recycling. My first step is to search all commands with “Sql”: Get-Command | Select Name |Where-Object {$_.Name…

Read More
Stéphane Haby

Set the SQL Native Client Default Port with PowerShell

By | Database Administration & Monitoring | No Comments

I written an article about “SQL Server 2012: Configuring your TCP Port via PowerShell” and I received a question from PaulJ: “How do you set the port for the SQL Native Client 11.0 Configuration (32bit) – as seen in the SQL Configuration Manager?” This is a very good question and I decide to write this blog as an answer to this question. The first step is always the same, initialization of my object: [reflection.assembly]::LoadWithPartialName(“Microsoft.SqlServer.SqlWmiManagement”) |…

Read More