While working on a project of database backup and recovery, I found out that my client was not aware of the resource database at all. Location of Resource.
SQL SERVER – Several Readers Questions and Readers Answers
I often get questions on blog and many times I even get answers from readers as well. This article is collection of few of the questions and answers by readers of this blog. Q. How the records of a table can be scripted in INSERT INTO statements? A. In SQL…
Read More
SQLAuthority News – Leadership Quotes and Inspiration
There is a big difference between leader and manager. There are plenty of interesting details written on this subject on the internet. In a recent presentation on leadership of one of the organizations I have presented a few of the quotes on the leadership subject to them. The leadership quotes were very much appreciated by the team so I am writing them over here.
SQLAuthority News – Community Tech Days – Jan 30, 2010 – Must Attend
Attend deep technology sessions for developers and IT professionals, as some of the best-known names come to your city to share their insights in topics ranging from .Net, Visual studio, Silverlight, to Windows and SQL Server. Build connections with Microsoft experts and community members and gain the inspiration and skills…
Read More
SQLAuthority News – SQL Server 2008 R2 – Release Date in May 2010
Microsoft has announced that SQL Server 2008 R2 will be available by May 2010. Its CTP (Community Technology Preview) version was already available from August 2009. It is still available for download.
SQLAuthority News – Download White Paper – Troubleshooting Performance Problems in SQL Server 2008
Troubleshooting Performance Problems in SQL Server 2008 SQL Server Technical Article Writers: Sunil Agarwal, Boris Baryshnikov, Keith Elmore, Juergen Thomas, Kun Cheng, Burzin Patel Technical Reviewers: Jerome Halmans, Fabricio Voznika, George Reynya Published: March 2009 It’s not uncommon to experience the occasional slowdown of a database running the Microsoft SQL…
Read More
SQL SERVER – Find Statistics Update Date – Update Statistics
Statistics are one of the most important factors of a database as it contains information about how data is distributed in the database objects (tables, indexes etc). It is quite common to listen people talking about not optimal plan and expired statistics. Quite often I have heard the suggestion to…
Read More
SQLAuthority News – Download Sample Database for Microsoft SQL Server
This post is a response to one of the most asked questions where to get Sample Database for SQL Server 2008. The name of the new sample database is AdventureWorks.Â
SQLAuthority News – Remote BLOB Store Provider Library Implementation Specification
Remote BLOB Store Provider Library Implementation Specification logo-sql08.gif SQL Server Technical Article Writers: Kevin Farlee, Pradeep Madhavarapu Technical Reviewer: Pradeep Madhavarapu, Michael Warmington Published: August 2008 Remote BLOB Store (RBS) is designed to move the storage of large binary data (BLOBs) from database servers to commodity storage solutions. With RBS,…
Read More
SQL SERVER – Execution Plan – Estimated I/O Cost – Estimated CPU Cost – No Unit
During the SQL Server Optimization training, I enjoy teaching the Execution Plan. I am always sure that questions related to the estimated cost will be raised by attendees. Following are some common questions related to costs: