Community Techday | Surat | 28th November 2010

We are very pleased to announce Community Techday at Surat on 28th November 2010. We try to bring you the new products  SQL Server is very popular and widely used RDBMS system in the SME and large Enterprises segment around the world for storing and managing their business critical data. Numerous applications are developed today with n-tier technologies, but they can be never be without database behind it. Recently Microsoft has announced the new version of SQL Server - SQL Server 2008 R2. SharePoint 2010 is the business...

Read More

What is new in SQL Server - Denali

Dear Readers, I have a great news to share with you all!!  A much awaited future version of SQL Server is announced - "Denali". This version has some new salient features like: SQL Server AlwaysOn -  A new feature that will provide maximum uptime with simplify HA deployment, this feature will also supports new availability group option to improve availability of mission critical databases by supporting multiple secondary servers. Column-Based Query Accelerator -  Increase query performance by ~10x  IT Administration...

Read More

How to Upgrade SQL Server

Couple of days back I have wrote an article on common issues we face while upgrading, and two methods to follow while upgrading SQL Server, this article also gives you some basic steps we need to follow post upgrades.  Here is an excerpts of the article: Upgrading the SQL Server version can have a major impact the applications using the databses. For example, from SQL Server 2005 onwards you are required to use  col IS NULL instead of Col = NULL and so any applications using the later will break. Using ...

Read More

Download MS SQL Server 2008 R2 Management Pack

Recently Microsoft has released MS SQL Server 2008 R2 Management Pack, it can monitor the Microsoft SQL Server components such as database engine, databases and SQL Server agents. MS SQL Server 2008 R2 Management Pack has few enhancements in this release including: Simplified and streamlined customer configuration and deployment Lower cost of operation due to improved health model and reduced false alarms Meets low-privilege constraints needed for financial and medical industries New rules, monitors, and knowledge improvments Easy deployment Discover...

Read More

Download SQL Server Developers Training Kit for free

There are tons of useful resources available for SQL Server but the link I am going to share with all of you today is really the greatest amongst - it's a SQL Server Developers Training Kit. Yes, MS has made the updated version available for we all and the best part is - it's free. The key benefits are: How to build applications with unique and new features available in SQL Server 2008 and SQL Server 2008 R2 It contains #55 videos, # 32 presentations, #39 demos and #24 hands-on-labs Content for SQL Server beginner developers Doesn't...

Read More

Download SQL Server 2008 R2 Best Practices Analyzer

Recencly Microsoft has released the Best Practices Analyzer (BPA) for SQL Server 2008 R2. BPA is a tool which helps Administrators to audit there local and remote SQL Server instances sagainst system events, logins, permissions and metadata for recommendation if it doesn't follow MS best practices for SQL Server. But, you have to have pre-requsite installed on your system before you install BPA for SQL Server 2008 R2, they are: Microsoft Baseline Configuration Analyzer V2.0 PowerShell V2.0 Windows Server 2003/2008/2008 R2...

Read More

Download free eBook on SQL Server 2008 R2

In this quarter Microsoft Press has gift a free eBook on "Introduction to SQL Server 2008 R2", a book written by Microsoft SQL Server MVP Ross Mistry and Stacia Misner. This book has 10 Chapters and 216 pages which covers Enhancements in SQL Server 2008 R2 Multi Server Administration Data Tier Application HA and Virtualization Enhancements Server Consolidation and Monitoring  Data Warehousing Master Data Services Event Processing with StreamInsigh SSRS Enhancements Self-Service Analysis using PowerPivot Isn't this list looking great?...

Read More

Virtualization – a way to reduce IT Costs!

A month ago I and my friend were discussing IT budget, and it becomes very interesting when we started discussing virtualization. Let me brief you the case: with the growing business usage of IT infrastructure increases and that increases the usage of energy and space. Apart from this, there is another side; are those resources getting utilized at optimum level? Well, at some cases yes but in most of the cases it doesn't - source. One would think if this really requires? I would say, yes, it is required. Let's take an example here; company...

Read More

Top 10 articles on SQL Server Clustering

Here are my favorite and top 10 articles on SQL Server clustering How to Create SQL Server 2005 Clustering with Virtual Server 2005   Introduction to SQL Server 2005 Clustering Basics   Inside SQL Server Cluster Setup and Troubleshooting Techcniques   Busting 6 SQL Server Failover Clustering Myths   SQL Server 2000 and 2005 Clustering   Preparing the SQL Server 2005 Clustering Infrastructure   Should I Upgrade my Current Clustering to SQL Server 2005 Cluster   SQL...

Read More

Embed security and secure your data

Security!! A word – that everybody want, whatever it may for - a life, money or a job. In an IT world this term is often used, and asked by the client, the customer or the end user because it is closely attached to the information they are providing or storing or exchanging with each other. It can create a chaos if an ounce of the information is leaked or spread publicly; refer the case about classified US Military info available, reported in July-2007 by Network World.   So, what we really have to care about that every piece...

Read More

Common Mistakes in SQL Server - Part 5

Last to Last week we discussed how Null Values can cause a trouble in Common Mistakes in SQL Server – Part 4. This I will discuss about Auto Growth feature of SQL Server, and how it can impacts us. What is Auto Growth? Auto Growth is a feature that allowed database files (primary, secondary and log) to expand when database file becomes full - without manual intervention. Auto Growth feature is really useful when we do not want to increase...

Read More