Monday, 31 December 2012

Happy New Year

I’m not working too hard today, so this is just a short post to wish all my readers a very happy and prosperous New Year

Happy New Year


Learn more about SQL Server Virtualization on 2013 then enrol on one of these Learning Tree courses

London: SQL Server Virtualisation and Consolidation

Toronto: SQL Server Virtualization and Consolidation

New York: SQL Sever Virtualization and Consolidation

December Top 4 Popular Posts

It is Monday today but its no ordinary Monday. Today is New Years Eve, its the end of December and its the last day of the year. This post is looking back at the top 4 popular posts on the blog for December 2012

circle, ball, pool, number, four

  1. SP_Change_Users_login
  2. Bulk Insert Permissions
  3. DB_Executor Role
  4. VMFS LUN Resizing Options in vSphere

So there has been some change in the top 4 posts this month.

Going into January I think the following posts have potential to be popular, I also have some other new material planned that might make it into the top 4 too

 


Learn more about SQL Server Virtualization on 2013 then enrol on one of these Learning Tree courses

London: SQL Server Virtualisation and Consolidation

Toronto: SQL Server Virtualization and Consolidation

New York: SQL Sever Virtualization and Consolidation

Friday, 28 December 2012

My RSS Reader…The Great Clean Up

If you blog and call yourself a blogger then you probably have a pretty full RSS reader. Mine has been added to considerably over the years. Well I signed into my Google reader account today and I realised that there is a lot of blogs that either I don’t read anymore or that the blog itself  has made its way to blogger heaven and is no longer being published too. So as we approach the end of the year I am going to clean up this list, mainly to make it more readable and also to allow me to add new blogs, that maybe I have not yet read to my reader in 2013.

Clean up my reader

If a blog hasn’t published a post in the last 3 months I’m going to unsubscribe. If I also have more than say 10 unread posts then I’m probably not reading them either so they will be culled too. I’ll backup my list before I unsubscribe so they can be quickly added back if I miss them too much.


Learn more about SQL Server Virtualization on 2013 then enrol on one of these Learning Tree courses

London: SQL Server Virtualisation and Consolidation

Toronto: SQL Server Virtualization and Consolidation

New York: SQL Sever Virtualization and Consolidation

SQL Server Cumulative Update

Microsoft today announced the latest round of SQL Server Cumulative Updates

SQL Server 2012 CU 5 – You can get more information here

SQL Server 2008 SP2 CU 4 – You can get more information here

SQL Server 2008 SP1 CU10 – You can get more information here

This might give you something to fix over the New Year holidays Smile


Learn more about SQL Server Virtualization on 2013 then enrol on one of these Learning Tree courses

London: SQL Server Virtualisation and Consolidation

Toronto: SQL Server Virtualization and Consolidation

New York: SQL Sever Virtualization and Consolidation

Closing the Results Window in SSMS

This is a guest post by David Postlethwaite.

I’ve been wondering how to do this for years. At SQL Bits and SQL Saturday the presenters make the results window disappear with a keyboard click but I could never work it out.

Well today I was working on a query and got fed up with losing half the screen to the results window . So I finally found it

It’s Ctrl+R.

But I expect you all know that already?


Learn more about SQL Server Virtualization on 2013 then enrol on one of these Learning Tree courses

London: SQL Server Virtualisation and Consolidation

Toronto: SQL Server Virtualization and Consolidation

New York: SQL Sever Virtualization and Consolidation

Monday, 24 December 2012

Merry Christmas from gethynellis.com

This is a very short post on Christmas Eve to wish all my readers a very Merry Christmas!

I’m going to be working very minimally over the Christmas period, I will be online from time to time but I have nothing strenuous that I need to achieve and I will be starting back again on January 2nd 2013.

So for now have a very merry Christmas


Learn more about SQL Server Virtualization on 2013 then enrol on one of these Learning Tree courses

London: SQL Server Virtualisation and Consolidation

Toronto: SQL Server Virtualization and Consolidation

New York: SQL Sever Virtualization and Consolidation

Wednesday, 19 December 2012

SQL Server Training in 2013–SQL Server Virtualisation and Consolidation

As we approach a new year many of you will be looking at your SQL Server Training needs for 2013. During 2012 I was fortunate enough to author another course for Learning Tree – this course focuses on running SQL Server in a virtual environment. It is titled 2109 SQL Server Virtualisation and  Consolidation.

As I discussed in my previous post 2012 was a release year for SQL Server 2012 and the chances are that you may be planning on migrating too it in 2013. You might also be considering running SQL Server in a virtual environment. More and more firms are adopting a virtual first approach to new server builds there might be a need for you to run SQL Server in a virtual environment. SQL Server can run perfectly well on a virtual platform if things are set and configured correctly and in the course 2109 SQL Server virtualisation and consolidation we will discuss how to do this.

If you would like to attend this course then very likely it will be at a location near you in 2013. If not you can attend online so you can join the class from the comfort of your own office or home.

France – Clichy Cedex starting 6th March

UK – London starting 13th march **

Canada – Toronto Starting 26th March

USA – New York starting 3 April

Book your place today

** denotes courses that I will be delivering the course. If I’m not teaching then it will be delivered by one of Learning Tree’s other great SQL Server instructors

Check out my SQL Server Training page for more details on the courses that I teach

Monday, 17 December 2012

SQL Server Training in 2013–SQL Server 2012 New Features

As we approach the end of 2012 – The release year for SQL Server 2012 many of you as we approach 2013 will have version upgrades, hardware refreshed and the real possibility of SQL Server 2012 being run in your production environment. So you might be after some SQL Server Training in SQL Server 2012 to prepare for a version upgrade. As part of my work with Learning Tree I have been lucky enough to be the author of Learning Tree’s 2105 SQL Server DBA skills upgrade course. This course focuses on the new features that would be of interest to the DBA. The SQL Server 2012 DBA skills upgrade class covers

  • Techniques that can be used to upgrade or migrate to SQL Server 2012 including techniques to minimise downtime.
  • There are some new security features in SQL Server 2012 that could be important to the DBA. User defined server roles and some enhancements to SQL Server auditing to name a few.
  • Column Store indexes can be useful in decision support environments, extended events now has its own GUI interface and extended events is definitely a tool the SQL Server DBA will need going forward.
  • We finish up with a look at the changes in high availability – AlwaysOn Availability Groups is a feature that is talked about a lot. You learn how to build and AlwaysOn Availability group from the ground up

This 3 day class is available to attend in class and online, in 2013 it will be running at the following locations on the following dates

UK 20th March – London

USA 26th March – Rockville

Canada 26th March – Ottawa

Check out my SQL Server Training page for information on the course I teach for Learning Tree

Thursday, 13 December 2012

SQL Server Training–New York New York!

For those that read my blog regularly you will know that I over the last couple of years I have been able travel quite extensively delivering  SQL Server Training with Learning Tree. At the start of December I travelled to New York to deliver more SQL Server Training the course was SQL Server Virtualisation and Consolidation in Learning Tree’s New York education centre. I will be visiting New York for a sight-seeing trip later next year but I did manage to get to see some of the sites.

When I first arrived New York I was slightly taken back by what I found. With Hurricane Sandy a very painful recent memory it was obvious, even several weeks on, how much damage and destruction it had caused and it was still having a huge impact on businesses in the city. There were still entire buildings closed and many that were open still pumping out water from their basements. It was still a 24 hour operation but things were but surely slowly getting back to normal.

New York Sandbags

I was staying at the south tip of Manhattan just off Wall Street and a stones throw from the Staten Island Ferry terminal. The image on the right below is in fact the Statue of Liberty it was just taken with my iPhone and the camera is not the greatest.

Staten Island FerryStatue of Liberty

I did get out and about and see a little bit of New York City whilst I was in town. I got some Christmas shopping done in Time Square and drove past Madison Square Gardens.

Madison_square_gardenTime Square

Still it was a work trip and I spent the week teaching SQL Server Virtualisation and Consolidation at Learning Tree’s New York education centre which went very well

Classroom

Tuesday, 11 December 2012

SQL Server Disaster Recovery

I was reading a blog post by Steve Jones on Monday and I started to write a comment on his blog, as it turned out it that comment turned into this post. Now this week is SQL Server disaster recovery week over on sqlservercentral.com so I thought I’d get involved with a post of my own. Steve’s post was titled ‘Grace Under Pressure’ and Steve talked about a power failure in a server room at a large company he used to work at. Steve was in the data centre at the time of the power outage, along with a Senior Executive, the Senior Executive didn’t seem to handle the situation all that well and definitely didn’t make it an environment whereby the system administrators and DBAs could go about their business, and let’s face it, a quite stressful business of recovering production servers that have unexpectedly lost power.

No doubt the root cause analysis of the issue revealed that the power outage was a direct result of the Senior Executive being in the data centre :-)

Joking aside I have experienced first-hand those types of disasters that Steve talked about in his post

Power Outages to server rooms
Server room flooding
SAN disk issues that caused a filer crash and took several servers with it

I have been very fortunate in my career, many years ago, my first full time DBA gig was a great job and I got to work with a lot of great people. The company  was good enough to fund training courses and more importantly gave me a great deal of experience working with SQL Server and also the opportunity to learn from a great team of people. I got a taste of a first real disaster during my time here, I experienced lost power to a server room and it caused chaos.

Some of the simple things can help in this situation and because of the training and guidance I had received from some great people that used to work there when disaster did strike I was prepared with the following:

  • We had a fully documented run-book for each production server. This detailed everything from SQL Server versions, databases installed on the server. When the backups were scheduled to run, the location of the backups (On server and off server) and more importantly what needed to be done to recover the databases on the server
  • We were expected to test recovery scenarios regularly and ensure the documentation was up to date as a result. Recovering a database is stressful enough, and recovering a production server is not the first time you should be experiencing a server recovery. If you have practiced database restores, recovering from server crashes when you come to do it for real you have experience of doing it and a nice document to help you on your way
     
  • Local copies of SQL Server books-online installed. With SQL Server 2012 the help files need a little more to install locally. A client of mine didn’t think installing BOL locally was important as you get that off the internet. This is great when things are well and you can get to the internet. If you experience one of the disaster I listed above the internet might not available to you. I would recommend you download and install local copy of the SQL Server documentation you never know when you might need it.

I was also fortunate to have a really great manager who ‘kept the wolves from the door’ dealing with the business dealing with high ranking people keeping them informed but more importantly keeping them off the back of the people trying to fix things. He knew they were stressed as the business was suffering, he also knew that if they interfered it would likely to take much longer to fix. It’s like a vicious circle, things take longer to fix, senior people get more irate and round and round the circle goes.

I visited New York last week, more about that in another post, and it was apparent that the hurricane/storm that hit a few weeks back was still having a severe impact on homes and business in NYC. There are still building closed, some are still flooded and being pumped out. The phones lines are still available for some; you have to pay cash in some bars and restaurants. No doubt the storm is still costing the NYC economy.


IT disasters can happen to anyone, to handle them with grace you need to be practiced, prepared, have a plan and work as a team with no infighting, finger pointing or assigning blame to fix the issue as quickly and efficiently as possible.


For more information on SQL Server disaster recovery planning and other services we offer visit SQL Server Consulting page

Monday, 10 December 2012

SQL Server Books–Query Tuning

Last week I was delivering a SQL Server Training course for learning tree. The course was 2109 SQL Server Virtualization and Consolidation: Hands-On. As part of the course the class discussion moved onto the importance tuning your queries ensuring they make efficient use of the servers resources. One of the group asked if I would recommend a book on SQL Server query performance tuning.

I told the class that I liked Grant Fritchey’s book SQL Server Query Performance Tuningbook. I haven’t read the 2012 version of the book yet but the SQL Server 2008 version is excellent and I’m sure the SQL Server 2012 version will be just as good.

If you were at the class last week here’s the link I promised you.


Visit my SQL Server Consulting page for more information my SQL Server Consulting services.

Visit my SQL Server Training page for more information on SQL Server Training courses that I teach through Learning Tree.

Sunday, 9 December 2012

SQL Server Consulting Blog–Sunday Stats

I’m going to continue with my series of posts on analysing how well my SQL Server Consulting blog has done in terms of traffic this week, I’m doing this just as a way of document how well or not so well the blog is doing in terms of performance, traffic and rankings in the search engines.

The number of blog posts published  was reduced this week on my  SQL Server Consulting blog but in terms of visitors and page views there has been a nice steady increase in traffic. Especially later in the week.There has also been a shift in the ‘popular posts’ figures with some posts dropping and some changing positions.

I have also noticed an increase in what Google terms SPAM comments on certain posts this week.Basically people are leaving comments on older posts, usually saying nice things that include a link back to their site, which would create links back to their site (Backlinks) that would help improve their search engine page ranking (SERP) Maybe there is some correlation between these comments and the traffic increase. Hopefully though having read a few pieces on SEO (The good type, not the bad) that the blog is appearing higher and with more frequency with the search words that I would like to be found with. I guess this series will help determine if this is true

The top four most viewed posts on my SQL Server Consulting blog this week are

When we compare to last week blogs stats we can see there have been some changes in what posts were the most popular and as predicted my Configure Hyper-V on VMware Workstation VM post has crept into the top four posts

Last week was pretty busy for me, I spent the week delivering some SQL Server Training in New York City I was delivering Learning Tree’s 2109 SQL Server Virtualization and Consolidation: Hands-On course. There will be more on that in a future post but that did mean that I didn’t keep up with my blog reading so I have no posts to recommend this week.


Visit my SQL Server Consulting page for more information on the consulting services that we offer.

Visit my SQL Server Training page for more information on the SQL Server Training courses I teach through Learning Tree

Monday, 3 December 2012

SQL Server Training in 2013

Unbelievably it is December already and 2013 is fast approaching. With the Christmas break fast approaching now is the time to start thinking about your SQL Server training needs for start the new year.

If you are based in Europe and fancy a trip to Sweden in early January I am scheduled to be deliver SQL Server Virtualisation and Consolidation for Learning Tree in their Stockholm education centre. Book fast though as I’m not sure how long registration will remain open. You can use the link above to Register for this event. The event is scheduled to run between the 9th and 11th of January 2013.

I will be delivering this event in London during March 2013. So if your organisation is running or planning on running SQL Server in a virtual environment then this is the course for you. I will be delivering SQL Server Virtualisation and Consolidation in Learning Tree’s London Education Centre between 13-15th March 2013. You can book your spot on this course using this SQL Server Virtualisation and Consolidation link


Check out the other Learning Tree classes that I teach on my SQL Server Training page.

Saturday, 1 December 2012

SQL Server Consulting Blog–Saturday Stats 1st Dec 2012

This post is little experiment I’m trying out this weekend. The SQL Server Consulting blog has been up and running since 2009  when it replaced my old website as my main publishing medium. Since that time traffic has steadily grown and one thing that' I’ve noticed recently is how different posts can vary in the number of page views they get each week. The top 4 most read blog post this past week were

Aside from the last post that was published last week and the only none technical post these are older posts, older than a year old. Now When I write a similar post maybe next week it will be interesting to see if there are any changes to this top 4 in terms of the traffic that they attract.

These are two posts on SQL Server virtualisation  that I think will make it into the rankings at some point soon

And to finish up the three blog posts from the SQL Server blog sphere I have enjoyed reading  this week.

You have been reading SQL Server Consulting Blog–Saturday Stats on www.gethynellis.com


Visit my SQL Server Consulting page for more information on the consulting services that we offer

Visit my SQL Server Training page for more information on the SQL Server Training courses I teach through Learning Tree

Thursday, 29 November 2012

Chicago: The Travels of a SQL Server Consultant

As regular readers of my blog will now as part of role as a SQL Server consultant and SQL Server trainer I get to travel a fair bit. Well last week I was off on my travels again on a multi-stop tour of the mid-west USA. Taking in Chicago, Milwaukee, Green Bay and Chassell way up in the Upper Peninsular (UP) in Northern Michigan.

South Chicago from Willis Tower

So we landed in Chicago late on Friday and took in some of the sights on Saturday. We ventured up Willis Tower (formerly Sears tower) to the Sky Deck. This is the tallest building in the USA and until the late 1990s it was the tallest building in the world. It is currently the 7th tallest building in the world.

North Chicago from Willis Tower

From the Sky deck you get some great views of the city the dark tall building in the centre of the photo is ‘Big John’ or the John Hancock Centre.

Willis Tower SkyDeck

The Willis tower also has  glass ledge that you can walk out onto and get some great views of the city (And get your picture taken). As you are walking on a glass ledge you can see the 103 storey straight down to the street. This was no issue for me but Mrs Ellis, who is not a fan of heights, declined the chance to stand on the ledge

Art Institute of Chicago

In the afternoon we visited Art Institute of Chicago. There are some great works of art in this building and Mrs Ellis and myself had a great time wondering around here.

Chicago Skyline at Night

After we left  the art gallery it was starting to get dark and as it was the Saturday before Thanksgiving it was the evening of the traditional Christmas parade on the Magnificent Mile. (Michigan Avenue). This is the event where they turn on the Christmas lights in Chicago’s main shopping district. Lisa and I walked up Michigan Avenue, the street was closed to traffic and there were 1000s of people lining the streets waiting for the parade to start. We decided that it was a bit cold and a bit busy for us to hang around on the street so we decided to head up the John Hancock Centre to see the city lights. We have been up to the observatory before but that was a few years back and since then they have added a cafe bar to this level. We had a few drinks enjoyed the view and headed on back to the hotel.

Rhys Farm

Monday we picked up our car and headed North our destination Chassell Michigan. Chassell is sat on Lake Superior, at the very north of Michigan. My good friend Rhys and his family live up there and we were paying them a visit and spending Thanksgiving with them. Rhys and I grew up together in South Wales and since he moved to the USA nearly ten years ago I have visited him and his family several times over the years. Chassell is small town just outside Houghton and Hancock. There was no snow on the ground when we got there so after we had taken his eldest to school on Tuesday morning we grabbed some breakfast and headed back to his farm. We took the pooch whose name is Hunter out for a walk as he showed me around his 80 acre estate. We had a great time at Thanksgiving watching some American Football and we also  hit the sales too

Rhys Farm in the Snow

The night of Thanksgiving we had a about 6 inches of Snow. This was the first real snow of the winter and since we returned home they have had a lot more snow.

Chevvy Tahoe

The snow wasn’t a problem though as we’d hired a Chevy Tahoe in Chicago and this was more than equipped for the conditions we were facing.

Cheesecake Factory Milwaukee

On Saturday we headed back down south spending the night in Green Bay before completing the trip back to O’Hare airport so we could fly home. On Sunday on our way to the airport we stopped just outside Milwaukee so we get some cheesecake from the Cheesecake Factory. If you love cheesecake you will love this place.

Mid-west USA

We visited some cool places on our little trip, we drove about 1000 miles in total and more importantly we got to see our friends who we don’t see enough of but he does live 5000 miles away so its not an easy commute. We had a great time. I love Chicago and no doubt I’ll be back some time soon. Still back to normal this week with SQL Server Consulting assignments to take care of back at home.


Visit my SQL Server Consulting page for more information my SQL Server Consulting services.

Visit my SQL Server Training page for more information on SQL Server Training courses that I teach through Learning Tree.

Thursday, 22 November 2012

Newsletter

Back in the old days before this blog when I was publishing a website instead that has long been consigned to the website dustbin I had a newsletter. It had a few subscribers and was generally well received, since I moved to the blog platform back in 2009 I let the newsletter go along with the website, but as was approach the end of 2012 I have decided to start it again. I will publish a newsletter roughly monthly with keeping you informed with all the goings on here at gethynellis.com

If you’d like to join you can fill in this form below

Subscribe to my mailing list

* indicates required
Email Format

 

Or you can visit the Newsletter page

Wednesday, 21 November 2012

Top 3 Books on Writing Transact-SQL (TSQL)

This weeks blog posts have been focusing on books that I have read, like and recommend for learning SQL Server 2008. I’m often asked what books do I recommend for learning SQL Server 2008 and I nearly always reply with a question “What area of SQL Server do you want to learn about?”

This post is dedicated to the book I like that have a Transact-SQL or TSQL (as is it commonly referred) theme.

  1. Inside Microsoft SQL Server 2008: T-SQL Programming (Pro-Developer)
  2. SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach
  3. Microsoft SQL Server 2008 T-SQL Fundamentals (PRO-Developer)

If you have book on TSQL that is not listed here and you think it should be please let me know by leaving a comment below

Tuesday, 20 November 2012

Top 5 Books on SQL Server 2008 Business Intelligence

Carrying on with book week and answering the question I’m often asked about what books I;d recommend to learn about SQL Server 2008 – This post is dedicate to the business intelligence stack.

  1. Microsoft SQL Server 2008 Reporting Services Step by Step
  2. Professional Microsoft SQL Server 2012 Reporting Services
  3. Delivering Business Intelligence with Microsoft SQL Server 2008
  4. Professional Microsoft SQL Server 2008 Integration Services (Wrox Programmer to Programmer)
  5. Microsoft SQL Server 2012 Integration Services Inside Out

As you can see there is not a lot of Analysis Services books in the list, there are few reasons for this, but if you do have an Analysis Services book, or any other business intelligence book for that matter then please let me know in the comments

Monday, 19 November 2012

Top 5 SQL Server 2008 DBA Books

I’m often asked about what books I would recommend for learning more about SQL Server 2008 and I always respond with another question, what areas of SQL Server do you want to learn about?

So this post is my top 5 SQL Server 2008 database administration books

  1. Microsoft SQL Server 2008 Internals (Pro - Developer)
  2. Professional SQL Server 2008 Internals and Troubleshooting
  3. Microsoft SQL Server 2008 R2 Unleashed
  4. Microsoft SQL Server 2008 Bible
  5. Professional Microsoft SQL Server 2012 Administration

If you have a book that you like or would recommend on SQL Server 2008 database administration let me know in the comments below.

Friday, 16 November 2012

Develop a High Availability/Disaster Recovery Strategy

Develop a High Availability/Disaster Recovery Strategy – Protecting your company’s most valuable asset and keeping that asset available is a very important task for most companies. We can help you put in place a solid reliable backup strategy and implement SQL Server High Availability Features to protect your data and make it available when you need it the most.

  • How much data can you afford to lose?
  • How frequently do you backup your databases?
  • Do you keep copies of you backup’s offsite?
  • Do you make use of any of the SQL Server HA FEATURES?
  • Clustering
  • AlwaysOn Availability Groups
  • Log Shipping


Contact us for help on developing a high availability and disaster recovery strategy.

Check out our SQL Server consulting page for a full list of details.

Thursday, 15 November 2012

SQL Server Version Upgrade

SQL Server Version Upgrade - You have SQL Server running nicely with no issues or problems. The trouble is its SQL Server 2005 and you know you need to consider migrating or upgrading to a later version of SQL Server but you don’t know where to begin? We can help, having undertaken many SQL Server upgrades (2000 --> 2005, 2005-->2008 and 2008--> 2012) we have a wealth of knowledge that can help you upgrade the to the latest and greatest version of SQL Server.

Contact us for more information on our SQL Server version upgrade service

Check out our SQL Server consultancy page for a full list of details.

Wednesday, 14 November 2012

SQL Server Virtualisation


SQL Server Virtualisation - Lots of companies and organisations are adopting a virtualisation first approach to the installation of new servers in their data centres. This can and will include SQL Server. Many DBAs perceive virtualisation as a bad thing for their SQL Servers fearing that performance and reliability will suffer. We can help and assist you when virtualising SQL Server. Ensure that the virtual environment is setup and configured so that SQL Server performance will not suffer and your SQL Servers will run happily on a virtual environment. We can help you convert (migrate) your existing physical servers to virtual machines.

Contact us for more information on SQL Server virtualisation

Check out our SQL Server consultancy page for a full list of details.

Tuesday, 13 November 2012

Site Update – Performance Tuning

Here at gethynellis.com we offer a range of consulting services to help you manage and maintain your SQL Server environment, This weeks series of posts are highlighting these services

SQL Server Performance Tuning – We can help you improve the performance of your SQL Servers and help you answer the following questions

  • Why is my server slow?
  • How should I manage my database server to maintain performance?
  • What indexes should I create?
  • Is my code efficient?

If you are interested in our SQL Server Performance Tuning services please contact us here

Check out our consultancy page for a full list of details.

Monday, 12 November 2012

Site Update–SQL Server Health Check

Here at gethynellis.com we offer a range of consulting services to help you manage and maintain your SQL Server environment, This weeks series of posts are highlighting these services

SQL Server Health Check - Your Company is growing and developing and you have noticed that your SQL Server is not performing as fast as you’d like. You have virtualized your SQL servers and you have noticed that performance is just not right. A growing and expanding  database environment can lead to unexpected performance issues and other problems. Without a clear plan to baseline performance, and efficiently deal with the complex elements of your SQL Server infrastructure, you run the risk of being left in the dark when issues arise or missing potential opportunities to increase efficiency and save costs. Do not fret help is here, we can pinpoint your issues and provide advice on to address them.

Check out our consultancy page for a full list of details If you are interested in our SQL Server Health Check services please contact us here

Sunday, 11 November 2012

Deal of the Week

Occasionally I come across  offers and deals that may be of interest to some of my readers. When I come across a deal that is worth sharing I will post it here. It will usually be technology related but it might not always be SQL Server related.

I will be updating the Deal of the Week page with these offers too.

This weeks offer is from Amazon (UK Site)

Samsung Galaxy Note 10.1 inch Tablet - White (ARM Cortex A9 1.4GHz, 16GB, Wi-Fi, BT, Android 4.0)

Amazon are offering a cash back deal on this device too. With Christmas coming this could make a nice Christmas present if your other half/children/family/friends (delete as a appropriate) are interested in non-apple tablets.

Friday, 9 November 2012

Enable Hyper-V on Windows Server 2012

Configuring Hyper-V on a Windows Server 2012 is really simple and straight forward. Its a very similar process on Windows Server 2008 R2 too. If you want to do this on virtual machine then you need to setup the VMware Workstation so it hides the fact a hypervisor is already running from the Windows Server. See my previous post here on how to do this

Start Server Manager, under Roles and Features choose Tasks and select Add Roles and Features

image

This starts up a the Add Roles and Features wizard and hit Next

 

image

Choose a Role based installation

image

Choose the server where the role will be installed

image

Choose the hyper-v role and click Next

image

I will allow the installation to add the features needed for the hyper-v role

image

After the features have been setup we will configure a virtual switch

image

I’m going to configure hyper-v for Live Migration

image

I will accept the default settings for the location of the virtual machines, you can change this to whatever you wish.

image

Click next then click Install and the Hyper-V role will be installed. Note that this process does require the server to be restarted for the installation to complete

Thursday, 8 November 2012

GRE Solutions sponsors the Darts

This post is very much off topic so apologies if you were expecting a technology related post.

Tonight a darts exhibition will take place at the Oakfield pub in Cwmbran. Darryl Fitton the professional darts player with the BDC will be taking on the Oakfield’s finest.

If you are in the neighbourhood and fancy a beer or two come and watch….

This event is brought to you by gethynellis.com

There will be a full report here over the weekend

Configure Hyper-V on VMware Workstation VM

When working with new technology, if you are like me you might like to setup virtual machines to learn the technology and its new features. I use VMware Workstation as my virtual machine hypervisor, installed on a Windows 7 laptop. With the release of Windows Server 2012 and the improvement in Hyper-V I wanted to setup a VM with Windows Server 2012 installed and then configure the Hyper-V role. Unfortunately ‘out-of-the-box’ Windows Server 2012 (or Windows Server 2008 R2) won’t let you do this as it detects the existence of another hypervisor.

The exact error is “Hyper-V cannot be installed: A hypervisor is already running”

Hyper-v001

In order to enable hyper-v on VMware Workstation you need to make a couple of small changes to the VM settings that will hide the fact the  Windows Server 2012 server is already installed on a VM.

Intel-VT or AMD-VT  should be enabled for the physical system

Edit the CPU settings of the VM and enable the Virtualize  Intel-x/EPT or AMD-V/RVI check box

Enable_HyperV

You will also need to edit the configuration file of the VM and add the following line

hypervisor.cpuid.v0 = FALSE

This option hides the fact we have hypervisor within a hypervisor and will allow the hyper-v role to installed.

You can use the above process for both Windows Server 2012 and Windows Server 2008 R2

Wednesday, 7 November 2012

SQL Server 2012 Skills Upgrade–November

There are still some places available for Learning Tree’s SQL Server 2012 Skills Upgrade course  this November. The class is being delivered by Derek Meyer – a fellow member of SQLStreet.co.uk it promises to be a great week.
 
If you are thinking of upgrading to SQL Server 2012 then this is the course for you.
 
You will learn

  • How to migrate from previous versions of SQL Server
  • How to build a High Availability Groups
  • Implement  user-defined server roles
  • Configure contained databases

You can attend in class or online you can enrol online here

Restarting and Shutting Down a Windows 2012 Server

I have been exploring Windows 2012 over the past week or so. Things look a little different to previous versions of Windows Server more on that later...This is just a short post to show how you go about shutting down or restarting a Windows 2012 server because on first glance it might not be obvious. There is a lack of a ‘Start’ or ‘Windows’ button in this version of the OS

Shutting down and restarting

  1. Open Server Manager
  2. On the left hand pane chose local server
  3. Click the tasks drop-down menu and choose Shut Down Local Server

Shutdown_1

This doesn't mean that you will be shutting down the server, you then get a screen like the one shown below where you get to choose what you want to do. Sign out, Shutdown, Restart etc

Shutdown_2

To me at least, how to do this was not immediately obvious so I thought it worthy of a post – I hope you find useful

Tuesday, 6 November 2012

Windows 2012 Week

Over the past few weeks I have been doing some work with Windows Server 2012 and learned a few little tips and tricks that I’m going to share with you this week. Hence the title of the post. Windows 2012 Week.

This week we are going to be looking at

  • How to restart and shutdown a Windows Server 2012 box
  • How to configure a VMware Workstation virtual machine so that the Hyper-V role can be enabled
  • Enabling the Hyper-V role

There will be other posts but these will make up the short series this week.

Monday, 5 November 2012

SQL Street

I’m involved with with a new venture called sqlstreet.co.uk.  SQL Street is the place to shop for database experts.
Here’s a brief list of our skills
  • SQL Server
  • Oracle
  • Business intelligence
  • SharePoint
Everyone on SQL Street is an experienced instructor,  consultant or contractor, with  over 10 years’ experience in their specialist fields.

Who are we?

  • Derek Meyer.  sqlstreet.co.uk  was Derek’s brainchild and without his efforts and hard work thus far the site would not have got off the ground.
  • Gethyn Ellis (that's me)
  • Charles Kangai  (our BI guru)
  • Russell "SharePoint" Lewis
If you have any questions or regarding the site and the services we offer then feel free to drop us an email enquiries@sqlstreet.co.uk

You will still be able to find my blog here. It’s not going anywhere but will be syndicated at sqlstreet.co.uk, so you can keep up to date there too.

Monday, 29 October 2012

Amazon Kindle Fire Released

Amazon has released the latest version of it Kindle – the Kindle Fire HD.

It seems amazon are moving away from a dedicated reading device and trying to compete with the tablet market – I’m thinking iPads etc.

With support for Gmail Twitter Facebook and other social networking and a huge selections of Films and over course books, its no doubt going to compete with the iPad and other devices, especially as its less costly than some of the other devices.

You can see the Kindle Fire HD 7", Dolby Audio, Dual-Band Wi-Fidevice here.

The Kindle Fire HD 8.9", Dolby Audio, Dual-Band Wi-Fi  version is due for release on 20th November – just in time for Christmas.

I haven’t tried this device yet but I’m hoping to soon, I will report back with a review when I have tried it and put it through its paces.