Steve Simon

Grab your pick and shovel and let’s mine!! Creating productive and informative mining reports!

by

Introduction

In a past chat back in January 2015, we started looking at the fantastic suite of data mining tools that Microsoft has to offer. At that time, we discussed the concept of a data mining model, creating the model, testing the data and running an ad-hoc DMX query. For those folks that may have missed this article, the link may be found immediately below;

Read more »
Steve Simon

BI at its very best!!! Revenue projection to keep us on course

by

A few days ago I received an interesting challenge from one of our clients. The lady was attempting to estimate her potential monthly revenue recognition for the fiscal year beginning January 1, 2015 through December 31, 2015. The lady named Linda sells goods and services (each class yielding differing sales margins).

In the first portion of this two part discussion, we shall be looking at the revenue projections for goods.

Read more »
Daniel Calbimonte

How to use PowerShell to create a SQL Virtual Machine in Azure

by

Introduction

The first time that you create your VM in Azure manually using the UI is a very pleasant experience. However, when you have hundred and sometimes thousands of computers it is extremely exhausting and boring to create and configure it.

With PowerShell, it is possible to automate several administrative tasks and create scripts to automatically create VMs, enable ports, download and create remote desktop files, administer services, etc.

In this new chapter, we will show how to create a Virtual Machine in Azure with SQL Server installed using PowerShell.

Read more »
Steve Simon

BI at its very best!!! Working with rolling averages

by

Introduction

A few days ago I received an email from a gentleman in the health care industry. He had read an article that I had previously published a few years back on a well know SQL Server website. Based upon the original article, he requested a few ideas on how to expand the sample code to do a rolling three month revenue summary, in addition to a rolling three month revenue average.

In today’s get together, we shall be looking at doing just this!

Read more »
Daniel Calbimonte

How to work migrate backups, files and scripts to/from the cloud using the command line

by

Introduction

Sometimes we need to move our local files, SQL scripts, backups from our local machine to Azure or vice versa. This can be done manually by accessing to Azure and using a browser, but there are other methods to automatically do this. This article describes the Microsoft Azure Storage Tool. This is a command line tool used to upload data to Azure from a local machine or to download data from Azure to our local machine. The article will describe step by step how to work with this tool.

Read more »
Murilo Miranda

AlwaysOn Availability Groups – How to setup AG between a clustered and standalone instance (Part 3)

by

We have already configured our Availability Group, now we need to make it flexible and accessible. It’s time to check on how to create a listener in order to make a single access point for you AG!

In continuation to our previous article, we are going to pass to another phase of this setup, as we already have our database in sync and safe, or highly available, depending of the chosen mode/architecture.

Read more »
Derik Hammer

Multiple Server Management – Finding the Database Server

by

Every organization has at least one of those guys. You are the guy if you have been with the company long enough that you are very familiar with all of the servers in multiple environments. You can easily translate the SharePoint server into its server name, CL-DB-001-B\SP_2010 and you know all of the DNS aliases pointing to that server as well. Your super power also makes you a magnet for everyone in IT to come and ask you where this database is and what is on that server.

Read more »
Daniel Calbimonte

How to work handle SQL Azure Databases with PowerShell

by

Introduction

PowerShell is a shell used specially to automate administrative tasks.

It is an incredible tool used to programmatically automate tasks like SQL Server tasks, Exchange tasks, Windows tasks, etc. It is very useful to integrate different Microsoft and sometimes non-Microsoft programs.

In this new tutorial, we will show how to install PowerShell for Azure and then how to use it. We will create some databases, edit database properties and retrieve database information using PowerShell.

Read more »
Page 1 of 1812345...10...Last »