Recently we needed to refresh our test database and the synonyms in the test environment is different from the production environment. Instead of re-creating all the synonyms one-by-one, this task can be semi-automated. Run the following code on the old production database SET NoCount ON — optional SELECT DISTINCT ‘DROP SYNONYM [‘ + + ‘].’ + FROM Sys.Synonyms… Read more →

Microsoft Office – Reduce the file size of a picture

Pictures in office documents As pictures become commonplace in the work environment, we see it more and more in work related documents. I do believe pictures are generally a good thing as like they say, “a picture is worth a thousand words”. However, sending office documents out when they become bloated with large images is not a good thing. To… Read more →

70-462 – Plan installation – evaluate installation requirements

Software Requirements The most important thing to consider is that .NET 3.5 is installed as it is not installed by the SQL Server 2012 installation. SQL Server 2012 does require .NET 4.0, however this will be installed as part of the installation. Summary .NET framework (3.5 and 4.0) Windows Powershell Network software (TCP/IP) Internet Explorer 7 or later Hardware Requirements… Read more →

Red Gate SQL Source Control and SQL Server Management Studio 2005 Woes

Continuing with supporting Red Gate SQL Source Control, we ran into another issue with the most current release of the software – SQL Source Control When loading SQL Server Management Studio 2005, we got the following message: Failure to load Add-on This issue didn’t happen for our developers who were using SQL Server Management Studio 2008 and 2012 after… Read more →

Red Gate SQL Source Control and TFS

We currently use RedGate SQL Source Control and TFS for our source control. However, for some reason, there was some changes made somewhere which caused all our developer’s SQL Source Control to halt while continually trying to complete step 2 of 4. It displayed a message saying: Determining latest version After a thorough investigation, it was narrowed down to our… Read more →

Exam 70-462: Administering Microsoft SQL Server 2012 Databases

After reading Katie & Emil’s post regarding 70-461 and upon my completion of the exam, I decided that I will do something similar during my studies for the next exam – the 70-462. I know they have a page for 70-462 as well but I thought it would be a good experience to write something up myself to make sure… Read more →