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

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

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

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
Previous 1 … 368 369 370 371 372 373 374 … 536 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version