SQL Archives - Page 361 of 519 - SQL Authority with Pinal Dave

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

April 14, 2010

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Spatial Database, SQL Index, SQLAuthority Author Visit

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…

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

April 13, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Reports

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…

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

April 13, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Reports, SQL Server Management Studio

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…

SQLAuthority News – Speaking Sessions at TechEd India – 3 Sessions – 1 Panel Discussion

April 10, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

MVP, SQLAuthority Author Visit, TechEd, TechEdIn

Microsoft Tech-Ed India 2010 is considered as the major Technology event of the year for various IT professionals and developers. This event will feature a comprehensive forum in order to learn, connect, explore, and evolve the current technologies we have today. I would recommend this event to you since here…

SQLAuthority News – Author Visit Review – TechMela Nepal – March 29-30, 2010

April 8, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

MVP, SQLAuthority Author Visit

I was very fortunate to attend TechMela at Kathmandu, Nepal on 29th and 30th of March 2010. I would like to thank Allen Bailochan Tuladhar from Microsoft MDP Nepal for inviting me. Allen is a person with seemingly infinite energy and unlimited passion for Microsoft Technology. If you get an…

SQLAuthority News – Milestone of 1300th Post and A Few Updates

April 7, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Today is my 1300th blog post and I realize that my blog has been quite running such a long journey. I have been writing for a lengthy time on this tech blog. Today I would like to go back and briefly recall the posts that were part of my blog’s…

SQL SERVER – Retrieve and Explore Database Backup without Restoring Database – Idera virtual database

April 6, 2010

Pinal Dave

SQL

Database, Idera, SQL Backup, SQL Data Storage, SQL Restore, SQL Server, SQL Utility

I recently downloaded Idera’s SQL virtual database, and tested it. There are a few things about this tool which caught my attention. Let us learn about Retrieve and Explore Database Backup without Restoring Database.