Articles tagged

18 October 2017
18 October 2017

Automating Azure: Creating an On-Demand HDInsight Cluster

This article pulls together the concepts from two previous articles to demonstrate a way to automate the “on-demand” creation and deletion of an HDInsight cluster. This not only serves as a demonstration of the power of automating Azure provisioning, but is a practical solution for the user who only occasionally requires the power of HDInsight for scalable computations.… Read more
18 October 2017
18 October 2017

Automating Azure: How to Deploy a Temporary Virtual Machine Resource

Because Azure is designed from the ground-up to allow automated provisioning, It provides a number of interesting opportunities for use. With a .NET language such as C#, it is possible to create a very flexible 'on-demand' infrastructure in Azure, using Azure Resource Manager templates, that allows users to economically deploy the resources they need just for the interval of time that they are required, and then destroy them. … Read more
05 October 2017
05 October 2017

SQL Server Coming in on Another Platform

Why release SQL Server as a Linux, as well as Windows, application? It baffled many DBAs when it was announced, though most shrugged and decided that it must be part of Microsoft’s long-term wrestling match with Oracle. When Microsoft previewed an early version of the Linux SQL Server on Ubuntu and Red-Hat, with ‘core relational … Read more
04 October 2017
04 October 2017

How Can DevOps Concepts Provide Value in Digital Transformation Projects?

For some of us, DevOps means startups, cloud, fast-moving social media applications and Extreme Programming (XP). What about large corporate IT initiatives, Digital Transformation projects, and business process re-engineering? Can DevOps be relevant and appropriate? Mohammad Rizvi argues from experience that it most certainly can be.… Read more
27 June 2017
27 June 2017

Automating the Synchronization of RDS SQL Server Agent Jobs in a Multi-AZ Environment

Although Azure is the obvious Cloud service to host SQL Server, Amazon Relational Database Service (RDS) for SQL Server is a good choice when your organisation uses AWS. RDS deals with maintenance and monitoring, and supports the use of PowerShell to automate routine tasks. What if a script needs to be triggered by an unscheduled event? Even in this case, RDS can be configured to run scripts to react when something like a failover happens. Laerte Junior shows how easy it is to set up Lambda functions and some PowerShell scripts to automatically synchronise agent jobs after a failover.… Read more
19 May 2017
19 May 2017

Continuous Database Deployment with Confidence

To achieve gains from Database Lifecycle Management in general, and in Continuous Deployment in particular, it pays to aim for lightweight but consistent techniques and processes, refining them iteratively in the light of experience. Edward Elliott describes a Test-driven development process for developing SQL Server databases that worked for CD, based on a series of steps. Though the tools for CD may be necessary, they are not sufficient, without an effective structured process.… Read more
10 May 2017
10 May 2017

Working with Windows Containers and Docker: Into your Stride

So far, in this series, Nicolas has shown how to get simple container instances up and running with just some basic background information. Now we need to understand the differences between Linux containers, Windows Server containers and Hyper-V containers. We can then define, create and run multi-container Docker applications, and port existing Windows Container VMs to Docker.… Read more
15 October 2013
15 October 2013

SQL Server SQLCMD Basics

Sqlcmd makes many SQL Server tasks, such as automating test runs and maintenance tasks, easier and quicker. The sqlcmd command-line utility is valuable to any database developer or DBA as the prime means of executing batches of SQL Statements to SQL servers, and saving results to file. Rob Sheldon gives you the basic facts about this great utility… Read more
12 April 2011
12 April 2011

VMware Lab setup – A virtualized lab for testing HA and DRS

VMWare VSphere is a virtualisation technology that is best learned by setting up, on a single PC, a VSphere cluster as a virtualisation lab. Once you have it, it will then be a useful tool in many ways. This doesn't need to be an expensive exercise, but can be daunting if you don't have a simple guide to talk you through the process. Here, Sean provides that simple guide … Read more
11 March 2011
11 March 2011

An Introduction to PowerShell Modules

For PowerShell to provide specialised scripting, especially for administering server technologies, it can have the range of Cmdlets available to it extended by means of Snapins. With version 2 there is an easier and better method of extending PowerShell: the Module. These can be distributed with the application to be administered, and a wide range of Cmdlets are now available to the PowerShell user. PowerShell has grown up.… Read more