Always On–New Feature: “Availability Group” in Denali

In Denali, there is a new feature called – Availability Group.   With this feature you can setup – Multiple Database mirroring as part of Availability Group – This is perfect for an application that uses multiple databases Multiple Secondaries Example: one for HA with Synchronous with Automatic Failover  — in Same datacenter 2nd one for…

2

SQL PASS Conference – Day 1: Highlights–CRESCENT, “Atlanta”, COLUMNSTORE in relational engine

·         CRESCENT is BIG thing!!   Great product, amazing demo, awesome! ·         Code Name “Atlanta” (www.microsoftatlanta.com) is another cool Cloud based services that is in beta 1 right now.  It’s  “Pro-active Assessment Services” – covering most of BPA ·         COLUMNSTORE (Vertipaq Technology) similar to what we have in PowerPivot that powers multi-billion rows data sorted and…

0

Common SQL Server Myths by Paul Randal

  http://www.sqlskills.com/blogs/paul/CommonSQLServerMyths.pdf This is a very good article by Paul – interesting read..  Enjoy! Similar blog post by CSS SQL Server Engineers at Microsoft – http://blogs.msdn.com/b/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.aspx  — an interesting read as well. 

0

How to turn Reporting Services Features such as–Schedule Events and Report Delivery and Web Service and HTTP Access–On or Off

According to SQL CAT team article on best practices consideration on RS-Scale out deployment – http://sqlcat.com/technicalnotes/archive/2008/10/21/reporting-services-scale-out-deployment-best-practices.aspx “..To isolate your workloads, set your scheduling Reporting Services servers to Schedule Events and Report Delivery Enabled, and set your interactive Reporting Services servers to Web Service and HTTP Access Enabled. By default both options are enabled, so make…

0

Latest Post on CodePlex by Visual Studio ALM Rangers–Guidance on Visual Studio 2010 Database Projects

Project Description Practical guidance for Visual Studio 2010 Database projects, which is focused on 5 areas: Solution and Project Management Source Code Control and Configuration Management Integrating External Changes with the Project System Build and Deployment Automation with Visual Studio Database Projects Database Testing and Deployment Verification This release includes common guidance, usage scenarios, hands…

0

Redirecting SQL Client connection to different instance of SQL who is listening to 1433 (default port) without altering client ConnectionString

Scenario: Current Setup: SQL Server 2005 Default instance – PRODServer listening at default port 1433 Client Connection String using SQL Native Client – Provider=SQLNCLI ;  Server=PRODServer; Database=PRODDB; Trusted_Connection=Yes;  with TCP/IP protocol with default port 1433 Now – Upgrade Happens… a side-by-side upgrade on a same server. New Setup: SQL Server 2008 Named Instance – PRODServer\NewPROD…

2

Preparing a SlipStream (Merged) Installation for SQL Server 2008 + SP1 + CU8

There is known issue with SQL Server 2008 RTM Install. http://support.microsoft.com/kb/957453/. Based on this the upgrade may fail. To avoid this possible failure, recommendation is to use “slipstream” installation with SP1 and latest Cumulative Update package 8 (CU8). Cumulative Update Package 8 can be obtained from – http://support.microsoft.com/kb/975976 SQL Server 2008 SP1 can be downloaded…

0