Feb 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

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…
Read More

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…
Read More
All Articles virtualdb1

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.

Read More

SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot

April 5, 2010
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Backup and Restore, SQL Data Storage
Snapshot database is one of the most interesting concepts that I have used at some places recently. Here is a quick definition of the subject from Book On Line: A Database Snapshot is a read-only, static view of a database (the source database). Multiple snapshots can exist on a source…
Read More
All Articles enableindentityon

SQL SERVER – Enable Identity Insert – Import Expert Wizard

April 4, 2010
Pinal Dave
SQL Tips and Tricks
SQL Identity, SQL Server, SQL Utility

I recently got an email from an old friend who told me that when he tries to execute the SSIS package, it fails because of some identity error. After a few series of debugging and opening his package, we finally figured out that he has the following problem. Let’s learn how to Enable Identity Insert – Import Expert Wizard.

Read More

SQL SERVER – Difference Between GRANT and WITH GRANT

April 3, 2010
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Server Security
What is the difference between GRANT and WITH GRANT when giving permissions to the user? This is a very interesting question recently asked me to during my session at TechMela Nepal. Let us first see the syntax and analyze. GRANT: USE master; GRANT VIEW ANY DATABASE TO username; GO WITH GRANT: USE…
Read More
All Articles MDS20

SQL SERVER – Simple Installation of Master Data Services (MDS) and Sample Packages – Very Easy

April 2, 2010
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
I twitted recently about: ‘Installing #sql Server 2008 R2 – Master Data Services. Painless.’ After doing so, I got quite a few emails from other users as to why I thought it was painless. The reason was very simple- I was able to install it rather quickly on my laptop…
Read More

SQLAuthority News – MS Access Database is the Way to Go – April 1st Humor

April 1, 2010
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Software Development, SQL Humor
First of all, today is April 1- April Fool’s Day, so I have written this post for some light entertainment. My friend has just sent me an email about why a person should go for Access Database. For a short background, I used to be an MS Access user once…
Read More
All Articles igotyourback-600x596

SQLAuthority News – Fun Quotes about Technology

March 31, 2010
Pinal Dave
Personal
SQL Humor, SQL Server

SQL Server can be boring subject many times. In this blog post, let us see some of the fun quotes.

Read More
All Articles spatial6

SQL SERVER – World Shape files Download and Upload to Database – Spatial Database

March 30, 2010
Pinal Dave
SQL Tips and Tricks
Spatial Database, SQL Scripts, SQL Server, SQL Spatial, SQL Utility

During my recent, training I was asked by a student if I know a place where he can download spatial files for all the countries around the world, as well as if there is a way to upload shape files to a database. Here is a quick tutorial for it.

Read More
Previous 1 … 448 449 450 451 452 453 454 … 580 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com