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 [' + [...]
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 [...]
More to write about this one…
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.
.NET framework (3.5 and 4.0) Windows Powershell Network software (TCP/IP) Internet Explorer [...]
Continuing with supporting Red Gate SQL Source Control, we ran into another issue with the most current release of the software – SQL Source Control 184.108.40.20608. 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 [...]
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 [...]
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 [...]
We ran into an issue at work where a SQL Server query was slow when the VM in which the SQL Server was running in had more than 1 vCore. I had posted the question on dba.se and was able to piece together an answer so I wanted to keep a record of that here [...]
Somewhat related to my previous post, I was now tasked with moving scheduled jobs from the old Microsoft SQL Server to a new Microsoft SQL Server. To do this, we generated a script within MS SQL Server Management Studio. I came up with a few issues while trying to run the scripts on the new [...]
Deployed a new test server to replace an aging development server. Aside from the set up and other technical requirements, we needed to move the data from the old MSSQL server to the new MSSQL server. Quick steps to do so:
1. Make note of current location of database files.
April 2014 M T W T F S S « Mar 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Tags70-462 AJAX ASP Blackberry Bluetooth CDONTS CentOS check_http Chrome Cisco configuration CRM filezilla ftp GMail Google Google Apps gzip http iis jive linux Microsoft MSXML multi-boot mysql nagios orphaned users Outlook permissions programming redgate sbs SQL Server sql source control vCenter virtualization VMware vSphere vSphere Client WDS Windows 7 windows 2008 r2 windows server 2003 WordPress