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.
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.
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.
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.
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.
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.
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.
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.
With SQL Server 2012 due to be released sometime hopefully in the first half of 2012 some of us need..
SQL Pass Summit is the most comprehensive SQL Server conference you will be able to go to.
RSScripter is a great tool to help you migrate your SSRS reports from 1 environment to another. I have put together a powershell script to help speed up the process of changing values in your generated scripts.
As a DBA or Consultant, Database Maintenance is one of the most important tasks that needs to be implemented. What..
I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting. When I am not working with the SQL Server Stack I like to get away to the Snow and spend time Snowboarding.