1) SQL Server 2008 R2 Reporting Services doesn’t support Windows 2003 (or R2) Itanium based servers 2) SQL-DMO support is stopped in SQL Server 2008 Express 3) Cannot enable Web Assistant with sp_configure. MS recommend using Reporting Services 4) Surface Area Configuration Tool is discontinued...
Managing a large SQL Server inventory requires an efficient management processes. Following on from DBA productivity and less is more , this post outlines the system I use to manage the DBA scripts across the database server environment 1) Develop a script library covering the essentials of DBA database...
A busy Database Server and application development environment can have – Sandbox, Dev, Test, QA, Staging, Production . Maintaining multiple environments requires consideration of various factors. Reasons for maintaining different environments Part of well audited database server system includes Segregation...
Well here it is the next version of SQL Server is getting out step by step, few months ago CTP3 and now Release Candidation 0 is available for download. The version number will be 11.0.1750.32, make a note of it. Microsoft SQL Server 2012 RC0 enables a cloud-ready information platform that will help...
SQL Server 2008 R2 service pack 1 is available for download now, after it was CTPd in the month of April 2011. The version number for this SQL2K8R2 SP1 will be: Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 As usual the Service Pack 1 files are availabel for the following editions and X86, X64 and...
SQL Server 2008 R2 service pack 1 contains all the cumulative update pack releases since RTM release. This means SP1 CTP consist the CU Package releases from 1 to 6, as CU7 has released on April 18th 2011. So before you test the SQL2008R2SP1 CTP, I would encourage to go through the release notes that...
Here is the announcement about SQL Server 2005 Service Pack 4 RTM which has been CTP for a month or so to test and apply on your current 2005 production estate. Before downloading make sure to go through .... read more ...
BOL - Book OnLine is a primary resource to get to know about the product in addition to the numerous blogs & resources on the web. As a best practice I always update my local copies of SQL Server Books Online for versions 2008, 2008 R2 & Denali (CTP). Though I still maintain books online for...
As promised SQL Server release services has done it again, a great job in releasing SQL Server 2008 Service Pack 2 . Continung from SQL-2008-CU10 blog post here, it is recommended (I say MUST) to go through the SP2 release notes the download link confirms on : Service Pack 2 contains updates for SQL...
In continuation to the SQL2K8R2 Service Pack1 post I got few emails asking why there are 2 additional files ( SQLManagementStudio_x64_ENU.exe & SQLManagementStudio_x86_ENU.exe) included in the SP1 download page. ....read more....