Monthly Archives: November 2011

SQL Server 2012 Editions – Business Intelligence Edition

Microsoft is  coming up with new edition every time from last two product releases. This time, SQL Server 2012 will also be coming in  Business Intelligence Edition. SQL Server 2012 Editions SQL Server 2012 Enterprise Edition SQL Server 2012 Business Intelligence Edition SQL Server 2012 Standard Edition SQL Server 2012 Web Edition SQL Server 2012 [...]

Cumulative Update 2 for SQL Server 2008 Service Pack 3

Microsoft has recently released SQL Server 2008 Service Pack 3 Cumulative Update 2 on November 22, 2011. This update has fixed the issues, which has been reported after SQL Server 2008 SP 3. Once you install this cumulative update this will update your SQL Server Version to 10.00.5768.00 Below are the major bugs that have [...]

ODBC Driver for Linux

Microsoft today (11/28/2011) released a 64-bit SQL Server Open Database Connectivity (ODBC) driver for Red Hat Enterprise Linux 5. But a 32-bit version is planned for an unspecified future release, according to an MSDN FAQ page. This ODBC drivers for Linux will allow native C and C++ applications to leverage the standard ODBC API and [...]

SQL Server Reporting Service – Find out a report schedule job name

Currently I was working with one of my developer and he asked me to run a report once again so that subscribers to that reports will get the updated report. I said, if I execute a report, I mean to say, if I open a report Server url and click on required report, I will [...]

Product KEY for SQL Server 2008 R2

Microsoft SQL Server 2008 Product keys contain 25 characters that are typically divided into group of 5. like this.. From where we can get Product KEY for SQL Server 2008? Normally you can get Product KEY for SQL Server 2008  in paper license which you have received from Microsoft or you can locate your media [...]

SQL Script to find Current Running Jobs and elapsed time

I do get a call from developers to check weather a any job is running on the server or not ? Mostly on Sunday morning they want to check that all data import / exports jobs finishes on time. So they wanted me to know what all the jobs are currently executing. We can find [...]

BYE BYE OLE DB

Microsoft is going to end support for OLEDB. SQL Server 2012 will be the last version of Microsoft Database which will support OLEDB. Microsoft encourage you to adopt ODBC in the development of your new and future versions of your application. If you use SQL Server as your RDBMS, we encourage you to use SqlClient [...]