(Kenneth Fisher) I seem to get a lot of permissions questions these days and one of the more frequent ones goes along these lines “I still don’t have the right permissions on database xyq.”
Other News
Compare those hard-to-reach servers with SQL Snapper
(Michelle Taylor) If you’ve got an environment which is at the end of an unreliable or slow network connection, or isn’t connected to your network at all, and you want to do a deployment to that environment – then pointing SQL Compare at it directly is difficult or impossible.
What To Do When SaveChanges() Fails?
(Bipin Joshi) Beginners often ask this question – “What course of action should I take when a call to SaveChanges() fails?” The answer may vary based on a given situation and requirement. However, in many cases the following course of actions can be performed:
Test-Driven Development with Entity Framework 6
(Peter Vogel) You can completely disconnect your test code from your database with Entity Framework 6 in .NET and Visual Studio. You just need a little bit of custom code for your application, along with some boilerplate code.
Is SSIS Right For You?
I have used SQL Server integration Services (SSIS) since it was first released in SQL Server 2005. I have used a lot of ETL tools over the years, and in my opinion, SSIS is equal to the best of them. It is amazing some of the features included such as fuzzy logic. And the number of data connections it is […]
Don’t delete your flashback logs manually
(Marcin Przepiorowski) What happen when someone will delete Oracle flashback logs ? You probably don’t notice it until you will try to flashback database or bounce instance.
STMM Analysis Tool
(Ember Crooks) I mostly like and use DB2Œs Self Tuning Memory Memory Manager (STMM) for my OLTP databases where I have only one DB2 Instance/Database on a database server. I do have some areas that I do not let it set for me.
Single database backup and restore with MEB
(Daniel van Eeden) I was recently asked about if MySQL Enterprise Backup would be able to restore single databases.
jQuery Overview
(Rohatash Kumar) In this tutorial I will discuss jQuery and some important exciting features in jQuery. If you’ve used event handling, animation functions and DOM Manipulation or are interested in implementing one, you should be serious about jQuery.
Difference between Select and SelectMany in LINQ
(Shailendra Chauhan) Select and SelectMany are projection operators. Select operator is used to select value from a collection and SelectMany operator is used to select values from a collection of collection i.e. nested collection.