Truncate All Tables in Oracle and SQL Server

I was working with another developer today, and he wanted to experiment and see if running Entity Framework generator on a blank database takes longer than the one with a lot of data.  We wanted to truncate all the tables.  You cannot truncate a table with that participates in a foreign key constraint.  SO, together …

Continue reading ‘Truncate All Tables in Oracle and SQL Server’ »

Connecting to Oracle from SQL Server

I wanted to query some Oracle data from the SQL Server Management Studio today and issue some updates as well.  After trying many, many things I finally was able to get the connection to work.  I wanted to document the exact steps here, mostly for myself. You have to add a linked server into SQL …

Continue reading ‘Connecting to Oracle from SQL Server’ »

Talk at SQL Saturday Atlanta

Today I spoke at SQL Saturday in Atlanta, an excellent event completely dedicated to educating software and database developers on many SQL Server related topics.  I am honored to have been selected to be a speaker.  I spoke on SSDT – SQL Server Data Tools.  As usual, I had fun in a tech crowd.  I …

Continue reading ‘Talk at SQL Saturday Atlanta’ »

Using SSRS In Angular / ASP.NET MVC Application

I blogged a long time ago about a pattern on how to show reports in an ASP.NET MVC application.  I have received a lot of request to share code, but I have lost the source code when I reimaged my machine.  Rather than recreating this from scratch, I decided to take a more advanced route …

Continue reading ‘Using SSRS In Angular / ASP.NET MVC Application’ »

SQL Azure, Entity Framework and HIPAA

I was helping out a friend who is working on healthcare software.  They would like to run the app on Azure.  I am not sure how many of you have heard of HIPAA – Healthcare Insurance Portability and Accountability Act.  It sets some rules for anyone who writes healthcare related software.  One of the requirements …

Continue reading ‘SQL Azure, Entity Framework and HIPAA’ »

Transaction Isolation Levels Explained in Details

In this post I would like to go into a level of details regarding transaction isolation levels with simple explanations and advice on when to use each one. Transaction isolation levels refer to multiple database processes interacting with each other in terms of reading and writing the data.  Isolation levels are there to deal with …

Continue reading ‘Transaction Isolation Levels Explained in Details’ »

TransactionScope and Connection Pooling in SQL Server

There is one very interesting behavior of connection pooling feature in .NET framework / SQL Server that I learned yesterday.  You can read the Connect issue here.  Interestingly enough, default setting for TransactionScope object is to use Serializable Isolation Level. Here is a typical scenario to put the problem in perspective. An application is using …

Continue reading ‘TransactionScope and Connection Pooling in SQL Server’ »