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) ...

Showing posts with label sql server citation. Show all posts
Showing posts with label sql server citation. Show all posts

11/20/2016

New home for SQL Server Citation



Change is inevitable, it's natural. I would like to quote few lines from Shrimad Bhagavad Gita says     Change is the law of the the universe.  In my opinion, change will bring good to your life, always. 

In 2004, I have started this blog, like others, this blog was started to make notes for myself so that it's available for me whenever and wherever I want to refer. Initially this blog was not public, as I was thinking and fearing that whoever is going to read will laugh at the way I am writing, the grammatical mistakes I do, the topic I choose to write and so on, and the most stupid reason was no one is going to read my blog.  I was reading few articles based on Shrimad Bhagvad Gita, where I read the above quote, and I thought, okay, let's begin the change. I made this blog public, conquer my fear of thinking people laughing at me and my mistakes. Now, I thought, the only way to learn new things is to read, and try, unless you don't do mistake you will have very less chance to learn how to improve, and that's why I never believe in perfection - it will never make you think of improvement, there is no 100% in my dictionary, it's always 90%. I remember the days when SQL Server Pedia and was managed by Brent Ozar, I wanted my blog to get syndicate there but I could not do that. The reason was grammatical mistake, and, since my attitude was to correct my mistake, Brent introduced me to Lori Edwards ( B ), Jeremiah Peschka ( B ) and Patrick Kansa ( B ) who have helped me tremendously to proof read my writing, suggesting and help modification in my posts. I would like to thank Brent Ozar, Lori Edwards, Jeremiah Peschka and Patrick Kansa for helping and inspiring me, and everyone who have helped me grow .

When  HA was newly introduced and was buzz word, I have been on some projects where I have to helped customer, and I failed it but then, I was able to author a book on that very topic, for beginners though. That means, I love and believe in the quote that I have mentioned in starting.  I was amateur blogger then, and I am still. 

This blog space is hosted on Blogger platform, it has served me well. But as I already mentioned, changed is inevitable and is only constant. Few days back, in my last post I have mentioned that it will be the new beginning. Well, here is an announcement, this blog space is moving to somewhere else. It will be on word press platform. It is still in in designing phase, I will make an announcement of it's new home in my next post. 

Keep loving me and keep visiting.


photo credit: forrest.wheatey Moving box via photopin (license)

photo credit: Yevy Photography paint via photopin (license)

1/25/2011

SQL Server 2008 High Availability – A Book

I have no words to explain my excitement and happiness to share news with you all - my book on SQL Server 2008 High Availability is published!!
I have started authoring this book in May 2010 and as the time passes and gradually I move to the final chapter of the book, I was feeling like aha finally it is done!!! – Do you think so, it was this easy?
No, every publication house has their own set of rules to be followed while authoring a book and a process to be followed before the chapter or entire book is ready to be published i.e. 1st edit, 2nd edit of the chapter until final edit and the Packt Publication is no exception.
Since this is the first time I was authoring book I was having little or no idea about authoring a book. The editors from Packt Publication helped me a lot by helping me time to time with proper answers to my queries. I must admit that I could not be able to complete this book without support and encouragement from my family including my 2 year old daughter Dhruti.
I hope that you all will enjoy reading and learning from this book as I did while authoring and contributed my little part for the growth of my beloved SQL Server J
Let me tell you about this book:
1223EN_MockupCover The term High Availability means that the servers or systems that host or run the business-critical applications should be highly available 24 X 7. As the word it-self defines how important it is to make these applications and data available for end-users as well as business users, if this data is not available for a short time, it will be a big problem for both sets of users. Imagine a bank spread across the country and having a huge customer base. One fine day, their server crashes! If the bank relies only on backups, then it might end up losing approximately 15 to 30 minutes of data, depending on the backup strategy. Now the HA options related to SQL Server such as clustering, replication, log shipping, and database mirroring will help overcome this situation.
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, below are the chapters:
Chapter 1: Understanding Windows Domains, Domain Users, and SQL Server Security
Chapter 2: Implementing Clustering
Chapter 3: Snapshot Replication
Chapter 4: Transactional Replication
Chapter 5: Merge Replication
Chapter 6: Peer-to-Peer Replication
Chapter 7: Log Shipping
Chapter 8: Database Mirroring
Appendix A: Troubleshooting
Appendix B: External References
If you are interested to read more about the detailed / contents of each chapter you may find them here https://www.packtpub.com/toc/microsoft-sql-server-2008-high-availability-table-contents
And, here is the link for the sample chapter https://www.packtpub.com/sites/default/files/1223-chapter-1-understanding-windows-domains-domain.pdf

Regards
Hemantgiri S. Goswami

1/19/2011

Download Section for Script and free ebook

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 Index
  • To get various SQL Server Property details
  • To search a given word from a string
  • Script which will take backup and verifies the backup set as well
  • Script which will give you an idea on how to perform transaction in smaller chunks
You may find them all at http://www.sql-server-citation.com/p/downloads.html, and I promise that I will surely upload some more scripts in coming future.

Regards
Hemantgiri S. Goswami | http://www.sql-server-citation.com/

1/01/2011

welcome 2011

Dear Readers,

Wishing you all very happy and prosperous new year, may the new day bring you joy and happiness