SQL Server Blog

SQL Server 2012 Edition Comparison

March 26th, 2012

With the release of SQL Server 2012 there has been a slight change in the edition available. The removal of the Datacenter edition, but the inclusion of the Business Intelligence Edition. To find out more about these changes compare the available editions.

Read More

SQL Server 2012 Supported Features

March 25th, 2012

With the imminent release of SQL Server 2012, you may be looking at some new implementations or Upgrades and are looking to find out what features are supported in the various editions of SQL Server 2012.

Read More

HP Enterprise DBC Appliance

March 18th, 2012

HP and Microsoft have partnered together to build this consolidation appliance that has been optimized specifically for SQL Server 2008 R2. This appliance provides for your one stop private cloud.

Read More

SQL Server 2012 – Release

March 7th, 2012

Microsoft at the SQL Server 2012 Virtual Launch has announced that SQL Server 2012 will have general availability as of April 1 2012. Read more of the press release from this blog.

Read More

SQL Server 2012 Licensing – Have you got yours

March 3rd, 2012

SQL Server 2012 official Virtual Launch is set for March 7. You can register for this event now. At this event it is likely that a release date for the product will be announced. Who know’s. Will have to be there to find out.

Read More

SQL Server 2008 R2 In-place Upgrade

March 1st, 2012

Upgrading SQL Server versions to SQL Server 2008 R2 can be achieved in a couple of different ways. In-place Upgrade, Side by Side Installations or New Installations on new hardware. In this blog I am taking you through an in-place upgrade to SQL Server 2008 R2.

Read More

Pass SQLSaturday Australia

February 28th, 2012

SQLPass is bringing the popular northern hemisphere SQLSaturday downunder for a tour. Book this into your calendar to pick up some good information on a range of SQL topics. SQLSaturday will be presenting at various Australian and New Zealand cities.

Read More

Setting FavIcon for your DNN Portal

February 26th, 2012

Setting your FavIcon.ico file for your DNN site can improve the professional appearance of your site. Creating your own Icon is very simple, but changing the setting in your DNN admin settings may not work depending on the version of DNN you are running. This blog will take you through how to change your FavIcon.ico in DNN 6.

Read More

SQL Server Data Tools

February 22nd, 2012

SQL Server Development Tool is the new combined BIDS and VS Development tools that are available for download and installation to help your Database Development.

Read More

SQL Server Instance Database Sizing’s

January 25th, 2012

Quickly and easily reporting on all DB's in your SQL Instances on space usage is a requirement that is not that easy to achieve for multiple databases. It can be made simpler with the use of the .sql script that I have created that is available for download.

Read More

Error 18456 – Login Failed for User.

January 18th, 2012

Error 18456 is the generic error message for Login Failures in SQL Server. Depending on your situation this could be a simple misspelled password or the windows account does not have permission to the Instance and/or database. However I am not looking at those simple issues around this SQL Server error message. 

Error: 18456, Severity 14, State 38. Login failed for user 'DomainServiceAccountName'.  Reason : failed to open the explicitly specified database.

Read More

CXPacket Wait Type Count Investigation

January 10th, 2012

High CXPacket Wait counts in an OLTP environment can be used as an indication towards performance issues relating to Query Parallelism in your environment due to having multiple cores available. 

Read More
Blog

Hi, I'm Warwick Rudd, I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting.
In my blog I will look at all things SQL Server as well as some things outside of the SQL Server relm but hopefully you will find them helpful and interesting.

Search