Skip to main content

Posts

Showing posts from 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 YearLearn more about SQL Server Virtualization on 2013 then enrol on one of these Learning Tree courses London: SQL Server Virtualisation and ConsolidationToronto: SQL Server Virtualization and ConsolidationNew 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 2012SP_Change_Users_loginBulk Insert PermissionsDB_Executor RoleVMFS LUN Resizing Options in vSphereSo 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 tooConfigure Hyper-V on VMware Workstation VMLearn more about SQL Server Virtualization on 2013 then enrol on one of these Learning Tree courses London: SQL Server Virtualisation and ConsolidationToronto: SQL Server Virtualization and ConsolidationNew York: SQL Sever Virtualization and Consolidation

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.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 Conso…

SQL Server Cumulative Update

Microsoft today announced the latest round of SQL Server Cumulative UpdatesSQL Server 2012 CU 5 – You can get more information hereSQL Server 2008 SP2 CU 4 – You can get more information hereSQL Server 2008 SP1 CU10 – You can get more information hereThis might give you something to fix over the New Year holidays Learn more about SQL Server Virtualization on 2013 then enrol on one of these Learning Tree courses London: SQL Server Virtualisation and ConsolidationToronto: SQL Server Virtualization and ConsolidationNew 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 itIt’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 ConsolidationToronto: SQL Server Virtualization and ConsolidationNew York: SQL Sever Virtualization and Consolidation

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 coursesLondon: SQL Server Virtualisation and ConsolidationToronto: SQL Server Virtualization and ConsolidationNew York: SQL Sever Virtualization and Consolidation

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 …

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…

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.I was staying at the south tip of M…

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

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.

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

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…

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 weredb_executor rolesp_change_users_login and SQL Server 2008Bulk Insert PermissionsChicago: The travels of a SQL Server ConsultantAside 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 soonConfigure Hyper-V on VMware Workstation VMEnable Hyper-V on W…