Monday, 7 December 2015

Powerful SQL Queries for SQL Server

New Year, new powerful SQL queries!

Start the New Year off with some great Transact-SQL training and join me for Learning Tree's Powerful  SQL Queries for SQL Server  one day online training course running on the 14th January.

You will learn:

• Maximize the potential of SQL to formulate complex queries
• Apply joins and sub queries.
• Select the most efficient solution to complex SQL problems
• Identify and avoid common error situations
• Ensure that correct queries continue to work correctly in the future
• Produce test data for thorough and complete testing

If you would like to enrol click here

Tuesday, 22 September 2015

Most Read: My Top 5 SQL Server Articles and Blogs

There has been some really useful blogs and articles posted over the last week or so, this is my top 5 in no particular order

Some interesting reading there.

Get your free copy of David Postlewaites eBook Putting your Head in the Cloud: An Introduction to Azure SQL Database

Saturday, 19 September 2015

Free SQL Azure eBook

As this blog post is being published David will be delivering his “Putting his Head in the Cloud – Working with SQL Azure” talk at SQL Saturday in Denmark.

In preparation for his talk David has and over the last six to seven months been working on an eBook which he has decided to release at the same time he is delivering his talk.

If you are attending David’s sessionand would like a copy even if you are not attending his session and would like a copy anyway you can download using the Free SQL Azure eBook link.

Monday, 7 September 2015

SQL Saturday #413 Denmark 2015

David Postlethwaite will be giving his SQL Azure “Putting your head in the clouds – Working with SQL Azure” at SQL Saturday Denmark on the 19th of September

The abstract for David’s session is

“You've learnt the basics of cloud computing and taken a tour of Microsoft Azure. It's now time to take a deeper look at using SQL Azure.
In this presentation we will have wall to wall demos on creating, configuring, connecting, using,  securing, monitoring, uploading, scheduling  and syncing your SQL Azure database.
By the end of this sessions you will some way to becoming an Azure Jedi”

If you are planning on attending why not pop into David session at 2:45pm in room 5 and learn Azure from David

Wednesday, 5 August 2015

Kerberos Configuration Manager for SQL Server v3

By David Postlethwaite

I’m speaking about Kerberos for the SQL DBA at SQL Saturdays in Oslo, Gothenburg and Utrecht in September 2015.
Kerberos is one of those things that can drive you nuts and it’s easy to get it wrong.

If you are not aware Microsoft have produced a program to help SQL Server DBAs called Kerberos Configuration Manager (KCM). This is an excellent tool to help you to configure and check your SPNs for a SQL Server instance.

During my preparations for SQL Saturday I have come across a problem with it. I’ve been using KCM version 2 for the last year but this didn’t support SQL 2014 instances so I upgraded to version 3. This is much improved - as well as recognising SQL 2014 it now supports Analysis Services as well.
However I hit a problem with v3. It works fine on a Windows server with SQL 2014 installed, here it will recognise any older instance installed on that server as well but if you have a server with only an older version of SQL (in my case just SQL 2012) then it won’t recognise that instance and displays an error saying no SQL Server found.
Looking in the error log KCM reads the WMI to find the SQL information. With v3 it looks in root\Microsoft\SqlServer\ComputerManagement12 . This will only exist if SQL 2014 has been installed and this explains why it couldn’t find my SQL 2012 instance.

I uninstalled v3 and reinstalled v2 and that found my SQL 2012 server without issue.

Looking at the logs v2 looks in root\Microsoft\SqlServer\ComputerManagement11. I suspect that if you only have a SQL 2008 or 2005  instance it won’t work for you either.

I’d be interested to hear from anyone who has also encountered this problem and if they have found a fix.

Thursday, 28 May 2015

Microsoft Azure SQL Databases – Power and Performance

By David Postlethwaite
On the Database Scale page we can decide on the performance level that we want our database to have.
There are three performance levels Basic, Standard and Premium
  • Basic is best suited for a small size database, supporting one single operation at a time such as for development or testing, or small scale infrequently used applications.
  • Standard is the best option for most cloud applications, supporting multiple concurrent queries such as workgroup or web applications.
  • Premium is designed for high transactional volume, supporting a large number of concurrent users and requiring the highest level of business continuity such as mission critical applications.

There used to be two types called Web and Business they have now been retired but you’ll still find them mentioned in the documentation and it is still possible through SSMS to create a web level database. (Upgrade SSMS 2014 to CU5 to get the latest) They are due to be removed in September 2015.
Unlike your traditional on premises database server you cannot choose the number of CPUs, amount of memory or disc configuration with SQL Azure DB.
Each Service tier has different Power levels which are measured in Database Throughput Units or DTUs. A DTU represents the power of the database engine as a mix of CPU, memory and read and write rates.
Micrsoft Azure SQL Databases - Service Tiers
The table below show you the power levels available for each tier. Expect these to increase over the coming months and years.
The idea of a DTU is to show relative power that there is between the different levels So S1 will give you 4 times the power of Basic and P1 is 10 times more powerful than S0.
To give you some idea of what you might expect from each level Microsoft have published a benchmark transaction rate.
Bennch Mark Transaction Rate
You decide on the power level you think you require and then monitor and tune the database as required. It is very easy to change from one tier to another if you decide you need more or less power but changing the level will cause the database to stop and restart. Remember, each server can have a maximum of 150 databases and a maximum of 2000 DTUs

Visit our SQL Server and Azure Consulting page

Tuesday, 26 May 2015

Microsoft Azure SQL Database – Dashboard

By David Postlethwaite

Once you have created your database you can now start to manage and configure it.

There are six menus for a SQL Azure Database: -

  • Dashboard
  • Monitor
  • Scale
  • Configure
  • GEO-Replication
  • Auditing and Security
The Dashboard

Microsoft Azure SQL Database - Dashboard

The Dashboard gives an overview of the state of your Azure database. The most useful section is down the right hand side under “Quick Glance” where you can find your connections strings, manage the IP security, server name, status, collation and edition.


Microsoft Azure SQL Databases – Monitoring


The Database monitor screen allows us to see the performance of your database. There are various indicators that you can manage. By default there are four metrics:- deadlocks, failed and successful connections and storage size but  we can add more metrics from the Add Metrics button on  the grey bar at the bottom.

Microsoft Azure SQL Database Metrics

We can also add alerts to warn us when these metrics go over a certain threshold


Thursday, 21 May 2015

Creating an Azure SQL Database

By David Postlethwaite

Once you have logged in to the Azure Management Portal you can start to  create an Azure SQL Database.
Azure SQL Database is an example of Platform as a Service (PaaS), we don’t have to build a Windows server or install the SQL software or configure the SQL instance. We don’t have to worry about software upgrades or the disc configuration Microsoft have done all of that for us. Azure simply provides us with a platform where we can place our data.Once we have created a database we can connect to it from our pc using SQL Server Management Studio or connect our applications to the database by using ADO or ODBC.

From the management console click on the database icon image   on the left hand side of the screen then select +New from the grey section at the bottom.


We have the option of quick create, custom create or import.
Quick Create just asks for a database name and a server put it on and it then creates a standard database. You can then configure the size and performance level afterwards from the Management Portal.
Otherwise use Custom Create so you can also configure the size and performance level at the same time.


It usually takes less than a minute for the system to create the database for you.
The import option allows you can load a special type of backup file called a BACPAC file from Azure blob storage which we will discuss in a later article.
An Azure SQL database must be placed on an Azure SQL server. This server is simply a container to place your databases. There is very little that can be configured for a server other than its location. Importantly an Azure SQL server can host a maximum of 150 databases and has a maximum amount of power available to it (2000 DTUs which we’ll discuss in a later article)

Tuesday, 19 May 2015

Getting Started with Microsoft Azure

By David Postlethwaite

The URL for Microsoft Azure is

Make sure you have an up to date browser because parts of this web site don’t work properly with Internet Explorer 8.The web site is full of articles, blogs and videos on Azure to help you get started and also plenty of Free Trial links to encourage you to have a go. You will require a Microsoft Live account to use Microsoft Azure, if you have an MSDN subscription then you have between €45and €100 per month credit on Azure for development and testing.If you use all your credit your service will be disabled for that month (as I have found out) or you can opt to pay for the extra usage.

If you don’t have an MSDN account you can create a trial account, which does require a credit card number for ID purposes, which you can try for a month.
Microsoft says they won’t take any money at the end of the trial they will just disable your services unless you choose to start paying.
(There is a new interface at (still under preview as of April 2015) but personally I don’t like it)

Once you have an account you can login by clicking on “My Account” at the top of the screen
Then click on the “Management Portal” image. When you have logged in you will be presented with the main Azure screen - the Windows Azure Management Portal

The management portal is where you manage and create the different Azure services.
On the left is a list of the different services available – web site, virtual machine, SQL database, storage and many others, in the centre is the list of services that have been previously created and at the top is your credit status and a globe that allows you to change language.

One important bit that is easily missed is the grey area at the bottom. When making a change always check this area because this is where the Save button appears.

Thursday, 14 May 2015

Putting Your Head in the Clouds - Microsoft Azure

By David Postlethwaite
Microsoft Azure

Let’s take a look at the Microsoft Cloud offering. Originally called Windows Azure it was renamed in March 2014 to Microsoft Azure to reflect Microsoft now offering more than just Windows. At the time of writing Azure is available in 141 countries, including China, and supports 10 languages and 19 currencies. Microsoft has divided the world into regions.  There are currently 17 regions with more due to come online in India, Germany and South Korea soon.

image (The more observant will notice there aren’t 17 blobs on this image. Microsoft don’t show the two Chinese data centres)
There are currently two regions in Europe.
North Europe in Dublin, Ireland
West Europe in Amsterdam, The Netherlands (even though Dublin is further west than Amsterdam)
There are plans to build new data centres in Germany but no date has been published yet. Germany has much more stringent data protection laws than the rest of Europe which will make it more difficult for the NSA to get hold of data held there.
You can choose to place your cloud service in any data centre in the world (though Australia is currently limited to customers based in Australia and New Zealand) but putting your data or applications on the other side of the world may affect your customers’ performance if they are all based in Europe.
You’ll see that there are no data centres in Africa. South Africa recently was allowed to start using Azure but their nearest data centre is so far away that performance is almost unusable.
Microsoft Azure Data Centers
Microsoft has gone into the Cloud in a big way. They have spent billions of dollars on it and the data centres are huge as can be seen in this phot of the Dublin Data Centre.
The Dublin Data Centre, which was the first mega data centre built outside the USA, is now 581,000 square feet (54,000 square metres). That’s equivalent to 4 football pitches. In 2014 Microsoft announced plans to spend $1billion on a new data centre in Iowa, USA that will be more than 1.2 million square feet. (110,000 square meters)
Inside the Azure Data Centres

In a data centre the servers are housed in standard 40 foot shipping containers. Each container holds anywhere between 1,800 and 2,500 servers.
The shipping containers arrive fully built so all the onsite engineers have to do is plug them in using a  standard connector that provides power, cooling and network access. The servers remain inside their shipping containers inside the facility, where they are placed side by side and stacked two high.
The Dublin data centre has a room for over 100 containers giving a capacity of over 220,000 servers. A new container arriving at the data centre can be installed in just a few hours. That’s 2,500 servers installed and ready in less than a day.
photo credit: 4 Shipping Containers Stacked via photopin (license)
Power Usage Effectiveness PUE

One of the major benefits of this design is reduced energy consumption.  The Power Usage Effectiveness or PUE is an industry measure of the amount of energy needed to cool a computer compared to the amount of energy needed to run the computer.
PUE = Total Facility Energy/ IT Equipment Energy
The data centre for your company probably has a PUE of around 2.0. In other words it takes as much energy to cool your data centre as it does to run the computers within it. The Dublin centre has a PUE of 1.25. It achieves this by using a cooling system that uses outside air to cool the data centre and a server design that allows the servers to operate at much warmer operating temperatures than normal. (Microsoft says it runs its server rooms at temperatures of up to 35 Celsius, much warmer than most data centres, which typically run around 21 Celsius.)

Tuesday, 12 May 2015

Putting Your Head in the Clouds 3 – Cloud Service Offerings

By David Postlethwaite
Cloud Service Models
There are three main service models in the cloud. You will see these buzz words being used a lot in cloud discussions:
  • IaaS   - Infrastructure as a Service
  • PaaS  Platform as a Service
  • SaaS  Software as a Service
To get a better understanding what these mean take a look at this diagram which shows the typical layers of an IT Solution
Starting from network to application
IaaS - Infrastructure as a Service
Think of Infrastructure as a Service as Hardware to Rent. Instead of purchasing network equipment, storage space or servers you use the cloud provider’s infrastructure.
This means the cloud provider owns and maintains the housing, running and maintaining of all the hardware, not you. You will need to install the operating system and database software but you don’t have to worry about maintaining the hardware. And the cloud provider will have mechanisms in place to ensure that your hardware continues to work in the event of a failure
PaaS - Platform as a Service
Platform as a Service can be thought of as Servers to Rent. Here the cloud provider supplies you with hardware, operating system and database server. You simply place your data in the database server and connect your application to it. You do not have to worry about patching, upgrades, failover and backups. The Cloud provider will manage all that for you. With both IaaS and PaaS you have the flexibility to use more or less storage or processing power as and when you require it.
This is attractive to business which might otherwise have to maintain large amounts of storage space just for occasional peak times.
SaaS Software as a Service
With Software as a service we go whole way and simply rent applications over the Internet from the Vendor. We don’t have to worry about hardware , operating systems or software maintenance. You only have to pay for the time that you use the application on a “pay-as-you-go” basis which is why this is sometimes called “software on demand”. As well as removing the need to buy, install and manage software on your computer, it also has the advantage of the software being accessible from anywhere with an internet connection.

Thursday, 7 May 2015

Putting Your Head in the Clouds 2 –Advantages and Disadvantages of Cloud Solutions

By David Postlethwaite

If you are thinking about using Cloud Computing then it’s worth considering the pros and cons.

Advantages of the Cloud

Why would you want to use the cloud?

Quick Setup
You can provision a fully functioning database server in just a few minutes whereas on your premises it can take weeks to order hardware then build and connect a new server.

With the cloud, you have access to unlimited capacity.
You can increase the power and size of your server in times of high demand and then reduce it when demand drops.
The classic example, often quoted, is that of a ticket agency. For most of the year traffic is fairly steady but when tickets for a major artist go on sale then demand ramps up for a few days. With a cloud service, you can simply increase the power and size of your systems for those few days then when sales are complete drop the power back down. And you only pay for that extra capacity whilst you are using it.
If this was all in your own data centre you might have to buy and maintain all that extra power and storage all year round.

Cost Efficient
Aside from saving on storage and infrastructure costs, you might no longer need to update and manage software or applications, patch servers.
As we’ve already said you also only pay for what you use.

Backup and Disaster Recovery
Most cloud providers offer comprehensive backup and recovery capabilities. Backups happen automatically for you and you don’t need to check every morning that it worked. They will have huge redundancy built into their data centre and at least one other data centre in another city or even another country to ensure your system is always available.

Because it’s all on the Internet you can access it from anywhere that has  an internet connection.

Environmentally Friendly.
The cloud provider packs a lot of computing power into their data centres which are much more power efficient than your “on premises” data centre will ever be.
Their servers are utilized to the maximum whereas, if your company is anything like the norm, you have plenty of servers that are barely ticking over.
Enable IT Innovation
You have an idea and want to give it a try. Spin up a new server or database in the cloud in a few minutes, test out your idea and when you’ve finished just delete the server. You only pay for the time you had it running.
Just think how long it would take to get a server built and available in your office.

Most Cloud companies use industrial level security software and practices, which are probably more secure and better managed than you can do in your own data centre which makes it harder for hackers to get at your data. That’s harder, but not impossible.

Disadvantages of the Cloud

And why wouldn’t you want to use the cloud

Security and Privacy
Security and privacy are the two main concerns that companies always mention when talking about the cloud.
By outsourcing your infrastructure to a third party you are giving away your data that might be sensitive and confidential.
You have to rely on the provider to maintain the security of that data.
If your data was leaked or lost your company could be fined, closed down or risk bankruptcy.

Dependency is one of the major drawbacks of Cloud computing
Once you have gone with one cloud vendor it is difficult to migrate to another because of the huge data migration involved.

Loss of Control
Since the services run on a remote virtual environment, you have less control over the hardware and the software.
For instance the cloud provider may force upgrades onto you which may require a lot or rework to your application.

Reliability and Vulnerability
Since everything is now on the Internet the risk of the entire environment being vulnerable to hackers or Denial of Service attacks is always there.
Outage and downtime are two aspects that even the best Cloud provider can't completely guarantee.
Also with whole setup being Internet based if your office loses its Internet connection then you can’t work.
On the other hand, if you host everything “on premises” and your data centre loses its Internet connection then your customers may not be able to get to you to buy your products.

Government Interference
Microsoft Azure is compliant with the E.U. Data Protection laws so data in the European data centres will always stay in Europe.
However Microsoft and others have stated that under the USA Patriot Act the US government can request access to their data even if the data resides outside the USA bypassing EU law. 
Microsoft are currently fighting a case with the US authorities who are trying to get access to emails held in the Ireland data centre.

You will have to weigh up the advantages and disadvantages and decide what’s best for your company.

Wednesday, 6 May 2015

Putting Your Head in the Clouds 1 – An introduction to Cloud Computing

By David Postlethwaite
Although the concept of Cloud Computing and Microsoft Azure have been around for a number of years it is only relatively recently  that it has matured to the point where it is no longer just an interesting curiosity but a serious contender as a business solution.
Microsoft claim that 80% for fortune 500 companies are now using the cloud and that Microsoft Azure has more than a million servers with about 10 trillion objects hosted in its data centres. My company has started to look at the potential of the Cloud and I have spent quite a lot of time recently understanding and investigating Microsoft Azure as a solution for a small project.In February I presented some of what I’ve learned at SQL Saturday in Vienna which went down pretty well with those who came to listen. One attendee told me he had used my slides as the basis for recommending his company take a closer look The one thing I have found out is that it is changing almost weekly. New features are being added and current features are being improved. I found that one slide on restoring Azure SQL databases had become out of date that day. My talk will need updating before it appears at another SQL Saturday! So if your company hasn’t started looking at the potential of the Cloud then now is the time put your head in the cloud and take a look.
So to paraphrase a famous song based on Austria, let’s start at the very beginning.
What is the cloud?
Wikipedia states:
“The practice of using a network of remote servers hosted on the Internet to store, manage and process data, rather than a local server or a personal computer “ In a nutshell cloud computing is putting all or some of your data centre into a shared resource on the Internet rather than running it from your own premises.
The word “cloud” is often used simply as another name for "the Internet" so the phrase “cloud computing” really means "Internet-based computing," where different services such as servers, storage and applications are delivered to your company's computers through the Internet. The Cloud covers more than just sticking a SQL database on a shared server. The cloud, as you will see, is everywhere without you even realising it.
If you use gmail, Hotmail, Microsoft Mail, in fact any web mail where the mail server is not on your premises this could be classed as using the cloud.
We’ve been doing that for years long before the term cloud computing was invented.
Cloud Storage
Lots of us are using cloud storage such as Microsoft One Drive or Google Drive to back up our data on our hard disk to the Internet.
You can automatically sync your local data to the cloud disk so that you never lose it.
And you can access your cloud storage from other devices so you are not tied to just one pc or even one location.
There are masses of software that you can run directly on a web site without having to download and install it on your pc., for example Office 365, Skype or PhotoShop
I’m sure everyone here has used an application on the web, even if it’s just an online dictionary or language translator, a foreign exchange calculator or online banking
If the application runs on a web site rather than an application installed on your pc then it can be considered as part of the cloud.
Server Hosting
Server hosting is what we traditionally think of as cloud computing. Running databases or application servers from a data centre on the Internet
All the big players, Microsoft, Amazon and Google offer this as well has many small suppliers most offer a free trail and now is the time to take a look.

Tuesday, 5 May 2015

SQL Server 2016 Preview...Coming this Summer

It was announced yesterday at the Ignite conference that we’ll be getting a summer preview of SQL Server 2016. With it being a bank holiday in the UK … I missed it yesterday

Some the new features announced include :
Always Encrypted
Stretch Database
Real Time Operational Analytics and In Memory OLTP

You can also sign up to notified of announcements about the release

Tuesday, 28 April 2015

Windows Temporary Profile

Amongst IT related problems one that can fill this most ardent optimist with dread is when logging into your pc you get the message that you have been logged in with a temporary profile.
Well that was what happened to me Friday evening. My heart sank. Have I lost all my documents, photos, passwords, configuration settings, what about my presentations and emails?
Well I knew that my documents and photos were backed up to the cloud but all those configuration settings could be lost and that’s a lot of work to set those up again.
A quick search on the Internet brought up various solutions most of which said you’ve lost it. Well I had no intention of losing all my hard work.
So I tried the first response to any problem with a Windows pc and that’s to restart it. Twice, but with no joy.
A Chkdsk didn’t report any errors so that was a relief.
So this is what I did. I am using a domain account, I can’t guarantee it will work for a local account.
I logged on using a different administrator account.
I renamed my profile folder (under c:\users).
I started Regedit and went to
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList.

I found my profile GUID. This is straightforward because one of the values is ProfileImagepath which will match the folder you just renamed. Some people have mentioned that there may be two entries with the same GUID but one having .BAK at the end. In my case there was only one entry, with .BAK.
I delete the profile. (Always be careful doing anything in the registry!!)
Ensuring that the domain controller was running I logged back in as me. This created a new entry in the registry and a new profile folder in c:\users.
I now logged back in as the administrator.
In Windows Explorer, under folder options ensure you can see hidden, system and protected files.
In my old profile folder I can now see a file called NTUSER.DAT, this is my user registry. I copied this and the other files in the root of the old profile folder into my new profile folder overwriting the files in there.
I logged back in as me and hey presto I had a Windows profile I recognised, though with bits missing.
I logged back in as administrator and then set about copying all the other folders from my old profile to my new profile, including the hidden folder AppData.
When that had finished I logged back in as me and everything was back to normal. Hallelujah.
So far everything looks to be correct.
There may be better and easier ways and this may only work for a domain account but it got me out of a hole. I hope it may help someone else.
It has got me thinking about the fragility of my laptop, how I rely on it so much and about all my life that is stored on it and what would have happened if it had been a hard disk failure.

I used to back up my home pc to DVD and then store those at work but you can’t fit everything on a DVD these days. I have started to back up my documents and code to Microsoft cloud but there’s a lot I don’t like all my family photos, music, videos, databases, virtual machines simply because it would cost a lot and uploading gigabytes of data on Broadband would take forever

I have decided to buy an external hard disk and will be backing up everything to there on a regular basis.

Tuesday, 21 April 2015

SQL 2014 CU5

By David Postlethwaite

If you are using SQL Server 2012 or 2014 RTM you will find that SSMS offers very limited GUI support for SQL Azure databases. Right click gives you very few options and there’s no designer for tables, views or logins. You will have to brush up on your T-SQL commands to manage your Azure databases. If you are using 2014 help is at hand. Microsoft have issued SQL Server 2014 CU5 which gives similar levels of functionality to Azure databases as to On Premises database. 

I haven’t found an equivalent CU for SQL 2012. Unless anyone know different.

Thursday, 15 January 2015

Mid-Week Update

Just a short mid-week update, David Postlethwaite has been selected to speak at SQL Saturday Vienna which is being held in Vienna at the end of February(28th Feb). David’s talk is titled   Putting Your head in the Cloud– A Beginner’s Guide to SQL Azure.

There have a been couple of blog posts written on the event which also provide David’s abstract, you can read these here

If you’re thinking of going to the event do feel free to drop into David’s session and say hello. If you would like more information on the session, get in touch with David or myself, there is a contact us form available on the blog.

If you are looking for more formal SQL Server training, I will be delivering Learning Tree’s 2108 SQL Server Database Administration which is a 4 day hands-on course that will start 3rd March in London. Although this course and its labs run on SQL Server 2014, most of what the course covers will be applicable on older versions of SQL Server. If you would like to enroll on this event or if you would like more information on the course and its content you can visit the Learning Tree webpage

Tuesday, 13 January 2015

Putting Your head in the Cloud– A Beginner’s Guide to SQL Azure

David Postlethwaite will be speaking at this years SQL Saturday Vienna. The event will be held in Vienna on Saturday 28th February 2015.

You can read all about this specific event by visiting

David’s talk will be on cloud, this his abstract

Although Windows Azure and the concept of Cloud Computing has been around for a number of years it is still a mystery to many.
This talk takes a look at Cloud Computing – what it is, the types of Cloud available and their advantages and disadvantages.
We’ll then look at Windows Azure and specifically SQL Azure DB, to see how to create and manage SQL databases in the Cloud.

Session Level: Beginner

If you are going to be attending SQL Saturday in Vienna have an interest in the cloud why not pop along and say hello to David.

Monday, 12 January 2015

David Postlethwaite - Exciting news.

By David Postlethwaite

I have been chosen to speak at SQL Saturday in Vienna, Austria  on 28th February.
The organisers have just moved the event to a larger venue to cope with the expected demand.

My talk is entitled Putting Your head in the Cloud– A Beginner’s Guide to SQL Azure
I started looking at Windows Azure last year as an option for a project at work and also for some testing of a web site that I manage for my local carnival.
I soon realised that neither I nor my colleagues knew that much about cloud computing so I decided to put my new found knowledge into a “lunch and learn” presentation for work and now for SQL Saturday events. The talk takes a look at Cloud Computing – what it is, the types of Cloud available and their advantages and disadvantages.
It then looks at Windows Azure  and specifically SQL Azure DB and demonstrates creating, configuring and connecting to a SQL azure database.

There are 20 talks at SQL Saturday Vienna so if you fancy a weekend break in beautiful Vienna combined with a day of SQL training then take a look at
And don’t worry if you can’t speak German, many of the talks will be in English.

Tuesday, 6 January 2015

Website Updated

Over the Christmas holiday period the website has had a bit of revamp.


In terms of what has changed, some of the holding pages have been updated and also the look and feel of the site in the form of a new template. Most of this work has been carried out by David Postlethwaite, who is a regular contributor to this blog. He came up with the new template and did all teh design work. You will hopefully be able to read some more of David’s blogs as we progress through the year and David will hopefully be speaking at a variety of SQL events in 2015. Maybe we’ll see you there.

Monday, 5 January 2015

New Learning Tree 1 Day SQL Server Training

Learning Tree has recently introduced some new 1 day virtual training events There is range of courses and subjects for you to choose from and you can find out more about these by following the link on the image below.
One-Day Express Boot Camp
These are 1 day instructor led events that you will attend online and include extensive hands-on exercises and labs to enhance the technical skills. For more information on the subjects and areas covered visit
The SQL Server 1 day online courses include:
  • Writing SQL Queries with SQL Server Management Studio • Course 4550
  • Report Development with SQL Reporting Services • Course 4556
  • Writing SQL Queries • Course 4551
  • Creating Analytical SQL Queries for SQL Server • Course 4552
  • SQL Server DBA Essentials • Course 4553
  • Introduction to SQL Server BI Tools & Strategies • Course 4554
  • Data Migration with SQL Server Integration Services • Course 4555
Remember to check back regularly as these will be updated frequently in the early part of the year.
For my UK readers you get the flexibility of attending either morning or afternoon start sessions that start at either 9am or 2pm UK time.
I will be starting to teach some of these courses in April, but they are starting as early as January, so feel free to enroll on dates and times that suit.

Friday, 2 January 2015

E-Book Offer – Coming to an End

Back in December just before Christmas I wrote a post about a deal that Packt publishing has on its ebook range over the holiday period.

Until Tuesday the 6th Januray you can get can any ebook for $5…That works out about £3 in UK money.

This includes my book, Getting Started with SQL Server 2012 Administration 


There’s just a couple of days left to make the most of this deal.

Featured post

Creating a Linked Server to an Azure SQL Database

Why would you create a Linked Server to an Azure SQL Database? If you work in a hybrid environment with some databases stored on your on ...