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.
SQL SERVER – Difference Between GRANT and WITH GRANT
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
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 MoreSQLAuthority News – MS Access Database is the Way to Go – April 1st 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
SQLAuthority News – Fun Quotes about Technology
SQL Server can be boring subject many times. In this blog post, let us see some of the fun quotes.
SQL SERVER – World Shape files Download and Upload to Database – Spatial Database
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.
SQL SERVER – Introduction to Extended Events – Finding Long Running Queries
The job of an SQL Consultant is very interesting as always. The month before, I was busy doing query optimization and performance tuning projects for our clients, and this month, I am busy delivering my performance in Microsoft SQL Server 2005/2008 Query Optimization and & Performance Tuning Course. I recently read white paper about Extended Event by SQL Server MVP Jonathan Kehayias. You can read the white paper here: Using SQL Server 2008 Extended Events. I also read another appealing chapter by Jonathan in the book, SQLAuthority Book Review – Professional SQL Server 2008 Internals and Troubleshooting. After reading these excellent notes by Jonathan, I decided to upgrade my course and include Extended Event as one of the modules.
SQLAuthority News – Author Visit to Nepal TechMela – 2 Technical Sessions
Microsoft MDP Nepal is going to organize a Tech Mela for the IT community of Nepal on March 29 & 30, 2010 (2066 Chaitra 16 & 17), Monday and Tuesday, at the Russian Center for Science & Culture, Kamalpokhari, Kathmandu. The objective of the event is to enhance and exchange knowledge about Information Technology, as well as Microsoft products and technologies, with the IT community. I am very excited to attend this one-of-a-kind event in Nepal.
SQL SERVER – FIX : ERROR : 4214 BACKUP LOG cannot be performed because there is no current database backup
I recently got following email from one of the readers. It is about Backup Log file.
SQL SERVER – Generate Report for Index Physical Statistics – SSMS
Few days ago, I wrote about SQL SERVER – Out of the Box – Activity and Performance Reports from SSSMS (Link). A user asked me a question regarding if we can use similar reports to get the detail about Indexes. Yes, it is possible to do the same. There are…
Read More