Archive | March, 2012

Evolution of T-SQL between SQL 2005 & 2008 versions

Ever wondered what has changed under the hood between versions of Microsoft SQL Server? Well, then this post is for you! What’s new in SQL 2008 Programmability Enhancements (Database Engine) What got deprecated in SQL 2008 Deprecated Database Engine Features in SQL Server 2008 What was discontinued in SQL 2008 Discontinued Database Engine Functionality in […]

Comments Off Continue Reading →

**UPDATE:** HOW TO: Move SQL Server transaction log files to a different location via TSQL and SSMS

This is to correct some information that I had put out there in this article. From reading books online, it appears that my information was intended only for SQL Server 2005 databases. Talking with Robert Davis (Blog | Twitter) at work, I was advised that my earlier article was in correct and sure enough when I […]

1 Comment Continue Reading →

HOW TO FIX: Clock Drift Automatically with Task Scheduler (Not joined to Domain)

In one of my earlier post I talked about fixing Clock drift for a virtual machine that is not joined to a domain. It is located here. The issue that I was running into was that my clock for some reason would get set back about a day and that would mess up my time […]

2 Comments Continue Reading →

Had an amazing time at SQL Saturday in Vancouver!

If you have never been to a SQL Saturday event, I highly suggest that you do! You can find an upcoming event here and following this event on twitter #sqlsat114  As stated earlier in one of my posts this SQL community is really one of the bright spots in the IT field. I was so happy […]

Comments Off Continue Reading →

Fixed an issue *installing* SQL Server 2008r2

As you will remember, I had an issue trying to *remove* SQL Server 2008r2 as noted here. What I failed to tell you was what my REAL issue was… I could not successfully install SQL Server 2008r2 and I kept getting this error: So I used my tip again to remove the new installation that […]

Comments Off Continue Reading →

Fixed an issue *removing* SQL Server 2008r2

I had an issue tonight where I was unable to remove Microsoft SQL Server 2008r2. The setup was just hanging at this step SqlEngineConfigAction_remove_validation_Cpu64. I first tried to remove it by Add/Remove Programs and then tried it by the command line: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2>setup.exe /ACTION=uninstall /FEATURES=SQL,AS,BOL,SSMS/INSTANCENAME=MSSQLSERVER Neither action would work and it was […]

1 Comment Continue Reading →

HOW TO FIX: Clock Drift in Cloud Environments (not joined to AD domain)

This is really an outdated bit of information, please see the better method to resolve clock drift in this post by me. I have been slammed lately with moving from one place to another and taking on a new job, so I was not actively monitoring my web server that hosts this site. I checked […]

2 Comments Continue Reading →

Wow! Amazon EC2 is lowering prices again…

Sorry all, that I missed this earlier and I meant to post this on Thursday, but I got tied up with work. This news listed below from Amazon’s web site is really good news. Last month, I was hosting this site on EC2 and since I wanted to run Windows 2008 R2 (which is 64 […]

2 Comments Continue Reading →
Copy Protected by Chetans WP-Copyprotect.