http://ghemant.myopenid.com/
Name: http://ghemant.myopenid.com/
Score: 425
Last Seen: 442 days, 19 hours, 29 minutes ago
Member Since: 9 July, 2010
SqlServerKudos
atom rss
1
kudos
spam Kudos Remove

Describe HA and DR strategy and win | SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP

published 433 days, 43 minutes ago posted by http://ghemant.myopenid.com/http://ghemant.myopenid.com/ 442 days, 19 hours, 30 minutes ago
Thursday, March 17, 2011 7:25:23 AM GMT Monday, March 07, 2011 12:38:14 PM GMT
Share Dear Readers, I am very please to made an announcement about the contest.  As you aware that I have wrote a book on SQL Server 2008 High Availability which was published on 24th January 2008 by Packt Publication. Now you have a chance to win a subscription worth £150 of digital library at Packt Publication, here is the information. Describe the best HA+DR solution you have designed or worked upon, especially in case of physically dispersed location, and the reason why? The best answer will win... (more)
category: News | clicked: 0 | comment | | source: www.sql-server-citation.com
tags: Book on SQL Server 2008, cluster resources, clustering, Database Administration, database mirroring, Hemantgiri S. Goswami, high availability, Log Shipping, replication, SQL Server 2008, SQL Server MVP
1
kudos
spam Kudos Remove

Cannot resolve the collation conflict

published 440 days, 14 minutes ago posted by http://ghemant.myopenid.com/http://ghemant.myopenid.com/ 449 days, 21 hours, 28 minutes ago
Thursday, March 10, 2011 7:54:58 AM GMT Monday, February 28, 2011 10:40:28 AM GMT
Recently when I was referring to SQL Server Forums I saw a question that reads like: I get an error Cannot resolve the collation conflict between "Latin1GeneralCIAI" and "SQLLatin1GeneralCP1CIAS" in the equal to operation. (more)
category: News | clicked: 0 | comment | | source: www.sql-server-citation.com
tags: collate, collation settings, hemantgiri s goswami, SQL Server, SQL Server 2008 R2, sql server citation
1
kudos
spam Kudos Remove

Download Section for Script and free ebook | SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP

published 480 days, 3 hours, 5 minutes ago posted by http://ghemant.myopenid.com/http://ghemant.myopenid.com/ 489 days, 15 hours, 18 minutes ago
Saturday, January 29, 2011 5:03:24 AM GMT Wednesday, January 19, 2011 4:50:22 PM GMT
Dear Readers, Good News!! I have created a new section on this site from where you can download various scripts I have created and uploaded on my community website. Currently you can download scripts for: To Find Missing IndexTo get various SQL Server Property detailsTo search a given word from a stringScript which will take backup and verifies the backup set as wellScript which will give you an idea on how to perform transaction in smaller chunksYou may find them all at http://www.sql-se... (more)
category: News | clicked: 0 | comment | | source: www.sql-server-citation.com
tags: download ebook, download script, Hemantgiri S. Goswami, missing indexes, sql server citation, sql server script
1
kudos
spam Kudos Remove

How to Upgrade SQL Server | SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP

published 548 days, 7 hours, 51 minutes ago posted by http://ghemant.myopenid.com/http://ghemant.myopenid.com/ 558 days, 14 minutes ago
Monday, November 22, 2010 12:17:13 AM GMT Friday, November 12, 2010 7:54:21 AM GMT
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... (more)
category: News | clicked: 0 | comment | | source: www.sql-server-citation.com
tags: Hemantgiri S. Goswami, how to upgrade sql server, resolving upgrade issues, SQL Server 2008, sql server citation, sql server upgrade methods
1
kudos
spam Kudos Remove

What is new in SQL Server - Denali | SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP

published 548 days, 7 hours, 51 minutes ago posted by http://ghemant.myopenid.com/http://ghemant.myopenid.com/ 558 days, 16 minutes ago
Monday, November 22, 2010 12:17:13 AM GMT Friday, November 12, 2010 7:53:03 AM GMT
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... (more)
category: News | clicked: 2 | comment | | source: www.sql-server-citation.com
tags: column based query accelerator, Denali, download denali, Hemantgiri S. Goswami, juneau, new features of denali, sql server alwayson, sql server citation
1
kudos
spam Kudos Remove

Download MS SQL Server 2008 R2 Management Pack | SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP

published 642 days, 15 hours, 25 minutes ago posted by http://ghemant.myopenid.com/http://ghemant.myopenid.com/ 652 days, 1 hour, 38 minutes ago
Thursday, August 19, 2010 4:44:00 PM GMT Tuesday, August 10, 2010 6:30:42 AM GMT
Share 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 deploymentLower cost of operation due to improved health model and reduced false alarmsMeets low-privilege constraints needed for financial and medical industriesNew rules, monito... (more)
category: News | clicked: 1 | comment | | source: www.sql-server-citation.com
tags: download sql server 2008 r2 mangement pack, monitor sql server, MS SQL Server 2008 R2 Management Pack, operation manager, SQL Server 2008 R2, SQL Server Agent
1
kudos
spam Kudos Remove

Download SQL Server Developers Training Kit for free | SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP

published 674 days, 17 hours, 41 minutes ago posted by http://ghemant.myopenid.com/http://ghemant.myopenid.com/ 683 days, 23 hours, 4 minutes ago
Sunday, July 18, 2010 2:27:34 PM GMT Friday, July 09, 2010 9:04:41 AM GMT
Share 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 R2It contains #55 videos, # 32 presentations, #39 demos and #24 hands-on-labsContent for ... (more)
category: Query | clicked: 3 | comment | | source: www.sql-server-citation.com
tags: developers training kit, download training kit, sql presentations, sql server articles, sql videos, sql-server-citation.com