Head Blocking Script, Again…

Did I mention I use this blog to keep scripts so I do not lose them? Well, I do, it is easier to find stuff on the internet than it is on my own machine. This script is not new, it is not extra special for 2014, it’s just a basic head blocker script with…

1

SQLCAT.com has left the building, but not really…

Wow, it has been entirely too long since I have posted anything.  But I can assure it has been for good reason.  I have been neck deep in Hekaton, Column Store and a few other treats in SQL 14.  However, I am going to talk about none of that today.  If you have not noticed…

0

Azure Billing per minute and No Compute Charge for a stopped IaaS VM

*Updated to account for Stopped (Deallocated) which means stopped from the portal, not just shutdown from inside the instance!!! You asked for it Microsoft did it.  Billing per minute is pretty self-explanatory, prior to June 3 all IaaS compute hours billed by the hour and for the most part rounded up, no more, now you are billed…

2

SQL 2014 Preview announced at TechED

In case you missed it this week  and I doubt you did, it was announced at TechED that SQL 2014 will be available for preview the end of this month (June).  The biggest most interesting feature for me is In Memory OLTP, of which I am happy to share the first white paper has been published…

0

New CAT White Paper Published, SQL Perf in the cloud!

It is going to be a very busy summer with all the new toys going into preview, but before I get into all of those I wanted to share a paper that was released on SQLCAT.com this week;  Performance Guidance for SQL Server in Windows Azure Virtual Machines.  Before the on-prem folks blindly ignore it…

0

Spelunking Azure, What does it Cost?

 As I mentioned in a prior post I will be spending some time on Azure, I imagine the things I run into that stump me are probably stumping to the community as well be you a SQL professional, Windows Admin or otherwise. You will know the non SQL specific topics by the title, Spelunking, it…

0

Multi-Terabyte File Storage in the Cloud using DFS!

We recently had a question come to the team about DFS(Distributed File System) in Azure. The short answer is; it works as documented, simply follow the Windows documentation for setting up a DFS Namespace. Many links for you on DFS at the bottom of this post.   The concern came up because the largest VM currently…

1

I WANT YOUR FEEDBACK ON AZURE!

It’s no secret that Microsoft has had a huge push for Azure.  Even within the CAT team the effect is noticeable.  Usually within 24 hours this blog is at least acknowledged if not read by several hundred people, and there is no doubt you are representative of a larger community. What I want form you…

4

Cloud Spelunking, Managing Azure form your Desktop via PowerShell (the Setup)

These next few posts are going to deviate from the normal SQL, but in time I  will get back to that.    It recently came to pass that I had to build a domain in the cloud and I will admit setting up the PowerShell management aspects of this task took much longer than it should…

2