SQL Server security best practice

Security! This is the word comes in mind of every concerned person when it come...

Change the Collation Settings in MS SQL Server

This post will show you how to change the collation settings in MS SQL Server for specific database...

Resolve collation conflict

In this post I will show you how you can resolve collation conflict error...

Book: SQL Server 2008 High Availability

In this book I have tried to cover every single piece of information that might requires for installing and configuring SQL Server HA option like Clustering, Replication, Log Shipping and Database Mirroring...

Why to recompile Stored Procedure

Generally, we create views and stored procedures (proc here after) ...

11/16/2010

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 collaboration platform for enterprise and the web, Sharepoint makes it easier for people to work together. One can setup websites and manage their documents with few mouse clicks!!!

Windows 7 is a cool new version of Microsoft Windows for personal computers, including home and business desktops and laptops.

During this event we will learn the new features that are introduced with the new version of SQL Server 2008 R2, Sharepoint 2010 and Windows 7.  I would request you to kindly mark your calendar for Community Techday, 28th November 2010 in Surat.

You will have to visit the home page or the event page of the Surat User Group and get yourself register for free!!
Note: Feel free to share this detail to your friends and colleagues, Community Techday is the free event you don’t have to pay any fees to attend this event.

11/12/2010

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 - Enhancements in server roles to manage separation of duties, and auditing will be available for all the editions.
  • Beyond Relational - FileTable, 2D Spatial support 
  • Juneau - A tool for Developers : Developers can easily work using new tool "Juneau", this will help developers to developing databases, BI and web solutions. It also provides environment for Declarative Database Definition, Dynamically Editing Existing Database
  • BI Enhancement: Drag and Drop interface
  • Analytic Enhancement: Analytics performance can be enhanced from the desktop to data center through in-memory column store technology
  • Data Integration Management: Denali introduces two component - Data Quality Services for knowledge driven data cleansing and Impact Analysis and lineage which will ensure that the right data is delivered to the right users and the right time.
You may find more information at http://www.microsoft.com/sqlserver/en/us/product-info/future-editions.aspx and if you like to review the new version of SQL Server you may, download Denali at - http://go.microsoft.com/fwlink/?LinkID=205500&clcid=0x409

11/02/2010

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  Upgrade Advisor for SQL Server is a good start for any SQL Server however we still need to address the entire  process of upgrading SQL Server to a new version. So What is the process  we should follow while upgrading SQL Server? Read full story....


-- Hemantgiri S. Goswami | www.sql-server-citation.com