April « 2010 « SQL Server Journey with SQL Authority

Archive for April, 2010

SQLAuthority News – Best Complements – DBA Survivor: Become a Rock Star DBA

Posted in SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLServer, T SQL, Technology on April 16, 2010 | 8 Comments »

Today’s blog post is about the biggest complement I have ever received. I am very very happy and would like to share my feelings with you. Thomas Larock (Blog | Twitter) (known as SQLRockstar) keeps the excellent ranking of the blogger in SQL Server Arena. I am big fan of this list and have been [...]

Read Full Post »

SQLAuthority News – Tips for Traveling to Nepal

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, T SQL, Technology on April 15, 2010 | 11 Comments »

If you are a regular reader of this blog, you might know that I travel nearly 20+ days out of 30 days in a month. There are cases when I don’t have a chance to go home for an entire month and my family has to travel to different cities just to meet me. During [...]

Read Full Post »

SQL SERVER – What is Spatial Database? – Developing with SQL Server Spatial and Deep Dive into Spatial Indexing

Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Optimization, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, T SQL, Technology, tagged Spatial Database on April 14, 2010 | 8 Comments »

What is Spatial Database? A spatial database is a database that is optimized to store and query data related to objects in space, including points, lines and polygons. While typical databases can understand various numeric and character types of data, additional functionality needs to be added for databases to process spatial data types. (Source: Wikipedia) [...]

Read Full Post »

SQL SERVER – Configure Management Data Collection in Quick Steps – T-SQL Tuesday #005

Posted in Pinal Dave, SQL, SQL Authority, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged SQL Reporting, SQL Reports on April 13, 2010 | 7 Comments »

This article was written as a response to T-SQL Tuesday #005 – Reporting. The three most important components of any computer and server are the CPU, Memory, and Hard disk specification. This post talks about how to get more details about these three most important components using the Management Data Collection. Management Data Collection generates [...]

Read Full Post »

SQLAuthority News – Three Posts on Reporting – T-SQL Tuesday #005

Posted in Pinal Dave, SQL, SQL Authority, SQL Performance, SQL Query, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, T SQL, Technology, tagged SQL Reporting, SQL Reports on April 13, 2010 | Leave a Comment »

If you are following my blog, you already know that I am more of “T-SQL and Performance Tuning” type of person. I do have a good understanding of Business Intelligence suit and I also do certain training sessions on the same subject. When I was writing the blog post for T-SQL Tuesday #005 – Reporting, [...]

Read Full Post »

« Newer Posts - Older Posts »