Skip to main content

Posts

Showing posts from 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

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 orderInteresting post here from BrentOzar.com looking at the statistics on the uptake of SQL Server 2014 and the reluctance of businesses to move from older versions of SQL Server. There are still plenty of SQL Server 2000 and SQL Server 2005 instances out there in the wild!Azure Active Directory Authentication is in Public Preview. Check out this MSDN blog by Mirek H SztajnoThis article from SQL Server Central and Arun Sirpal on SQL Database and Azure Blob StorageSQL Server 2016: Row-level Security Example by Rajendra Gupta  SQL And R by Casimir SaternosSome interesting reading there. Get your free copy of David Postlewaites eBook Putting your Head in the Cloud: An Introduction to Azure SQL Database

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.


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 SeptemberThe 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

Kerberos Configuration Manager for SQL Server v3

By David PostlethwaiteI’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…

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 traditi…

Microsoft Azure SQL Database – Dashboard

By David PostlethwaiteOnce 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 SecurityThe DashboardThe 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 – MonitoringThe 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.We can also add alerts to warn us when these metrics go over a certain threshold

Creating an Azure SQL Database

By David PostlethwaiteOnce 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    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 …

Getting Started with Microsoft Azure

By David PostlethwaiteThe URL for Microsoft Azure is http://azure.microsoft.com.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 https://p…

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.

(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 NS…

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 ServicePaaS  Platform as a ServiceSaaS  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 - Platf…

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

By David PostlethwaiteIf 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. Scalability
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 yo…

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 …

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
You can read the blog post here http://blogs.technet.com/b/dataplatforminsider/archive/2015/05/04/sql-server-2016-public-preview-coming-this-summer.aspx
Some the new features announced include : Always Encrypted Stretch Database Real Time Operational Analytics and In Memory OLTP
You can follow the preview release notes and details here http://www.microsoft.com/en-us/server-cloud/products/sql-server-2016/?WT.mc_id=Blog_SQL_Announce_DI

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…

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.

https://support.microsoft.com/en-us/kb/3011055 

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

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 http://www.gethynellis.com/2015/01/putting-your-head-in-cloud-beginners.htmlhttp://www.gethynellis.com/2015/01/david-postlethwaite-exciting-news.htmlIf 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 r…

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 https://www.sqlsaturday.com/374/eventhome.aspxDavid’s talk will be on cloud, this his abstractAlthough 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: BeginnerIf 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.

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 bea…

Website Updated

Over the Christmas holiday period the gethynellis.com 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.

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.

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 http://www.learningtree.co.uk/info/bootcamp-courses.htm
The SQL Server 1 day online courses include:
Writing SQL Queries with SQL Server Management Studio • Course 4550Report Development with SQL Reporting Services • Course 4556Writing SQL Queries • Course 4551Creating Analytical SQL Queries for SQL Server • Course 4552SQL Server DBA Essentials • Course 4553Introduction to SQL Server BI Tools & Strategies • Course 4554Data Migration with SQL Server Integration Services • Course 4555 Remember to check back regularly as these will be updated frequently in the ear…

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 AdministrationThere’s just a couple of days left to make the most of this deal.