Skip to main content

Posts

Showing posts from March, 2016

SQL Server 2016 Azure Virtual Machines

With the release candidates coming thick and fast for SQL Server 2016 downloading, uninstalling the previous version and installing the latest can be a little bit tedious.
A less timing consuming option to trying the latest is to use Microsoft Azure. If you have an Azure subscription you can spin up a VM using one of Microsoft’s pre-built images in a very short amount of time.
There is a cost to using Microsoft Azure but a Windows vm on the basic tier is only a few pounds per month.
If you have an MSDN subscription you receive a monthly allowance that is bundled into your subscription. This is what I use for my Azure testing work.
If you company has embraced the cloud already then you may have access to that or you may have to spend a few € or £ or whatever your currency to use. Unless of course you can get a free trial which if you are new to the cloud and Azure Microsoft are normally happy to let your trail it for free for a while.
Once you have your Azure account sign in at https://…

SQL Server News–29th March 2016

This past weekend is one of my favourite holiday weekends - the 4 day Easter weekend :-)  Although I have had to work through most of it…With the holiday and the fact I've been busy with a new system go-live this post is slightly  late as a result.

On Thursday last week the Agenda for SQLBITS 2016 was annoucned. Our very own David Postlewaite has been selected to speak on the Saturday at SQLBITs this year. Congratulations David. That Saturday is free to attend. f you would like to see David deliver his session – sign up! Its free.
Anyway news posts and other bits that have caught my attention this week include:
SQL Server From January Microsoft want you apply  cumulative updates (CUs) like you would a a service pack. CUs now get tested like service packs apparently so we should take them more regularly as and when they come out. Interesting.

Continuous Integration - this is a subject and area that I have been looking at  recently. This a good article by David Atkinson first publis…

SQLBITS 2016 Agenda has been Published

The agenda for this year’s SQLBITs has been published you can find it here  http://sqlbits.com/information/event15/Agenda.aspx?20160507Our very own David Postlethwaite has been selected to give one of his talks. Congratulations to David on getting selected to speak at the event. The event takes place in Liverpool between 4th – 7th May You will find David in the 2:30pm – 3:30pm slot on Saturday 7th May and he’s in TR8.  He  will be delivering his talk titled “A Beginner’s Guide to Cloud Computing”

Weekly Round-up 21st March 2016

Here are some of the more interesting links that I have found this week
SQL Server SQL Server 2016 RC1 has been released. https://blogs.technet.microsoft.com/dataplatforminsider/2016/03/18/sql-server-2016-release-candidate-1-now-available/?utm_source=twitterfeed&utm_medium=twitter I've not had a chance to look at RC0 in too much detail yet. Although I did notice that Microsoft have split the SQL Server client tools installation from there server features. I'll hopefully get a chance to download install and setup RC1 this week. With the release candidates coming thick and fast RTM can't be too far away.

Queries to monitor replication backlog https://www.mssqltips.com/sqlservertip/4179/queries-to-monitor-sql-server-replication-backlog/

Support for SQL Server 2005 runs out on April 12th - Less than a month from now. If you need help in upgrading to the latest version of SQL Server or perhaps the cloud is now a viable and cost effective solution for you check out our con…

SQL Server 2016 RC0–Management Studio install option has disappeared

If you are trying to install SQL Server 2016 RC0 – which I’m sure you are all doing looking at the new features that are coming our way soon and wondering how all this cloud stuff passed you by? You might be also be sat there wondering where has the option to install the client tools gone. Where has the Management Studio install option gone? Well the answer is simple. It now has a separate option in the SQL Server Installation centre As you can see from the screen shot above, there are two option for installing the client tools. Install SQL Server Management Tools and Install SQL Server Data Tools. It’s quite nice to see the client being separated from the server.

Creating a Domain Controller

The following is a short guide for promoting a Windows Server 2012 Machine to be a domain controller. This assumes that there is no existing forest or domain. My reason for doing this is to create a test enviornment using virtual machines on Oracle Virtual Box. I'm planning to setup an AlwaysOn Availability group. One of the prerequisite to creating an Always on Availability group is a Windows Server Failover Cluster (WSFC). To set up a WSFC I need a domain. Hence why I’m creating a domain controller.  In future posts we will look creating an availability group I have used Oracle Virtual box to create a server in my domain. I have used the same process previously using VMWare Workstation. I'm going to assume you have run through create Virtual Machine  wizard and generated the VM configuration. With the Windows Server ISO  mounted and you have run through the install. First you will configure the Windows Server. Set and Administrator Account and click Finish. If your usin…

SQL Server on Linux

When I started working with SQL Server many years ago, SQL Server on Linux was a regular April fool’s day joke that bloggers used to write about. With the ever changing SQL Server database engine or just data platform these days. The integration of R and Polybase planned for SQL Server 2016, allowing SQL Server users to work with and use other analytic platforms and scalable data process technology. The integration with technologies such as Hadoop  capable of handling large amounts of structured and unstructured data. It’s no surprise that what used to be an old April fool’s joke is now going be a reality. Microsoft are targeting mid 2017 for this to be available.  You can check out Scott Guthrie’s blog post here http://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux/ for more information.