#Data

Easily adding auditing to a Entity Framework Code First project

If you've done any amount of development where you need to interact with data you'd know that at some point customers or stakeholders always want to know who made that change or when was that change made. To answer these questions you'd look to your auditing which in most cases is the last thing people think about adding into their apps for some reason.

Posted on January 05, 2017 - Auditing Data Entity Framework

SSMS 2016 where have my line breaks gone?

I’m hoping it’s not just me but one of the things I was missing from SSMS 2014 is that I had my line breaks when copying large text fields out of the query results. For a long time I have been putting it off and only using SSMS 2014, last week I re-installed my Operating System and decided not to install SSMS 2014 just for this 1 feature.

Posted on July 25, 2016 - Data SQL Server SSMS 2016

They said Select * was bad but...

So speaking to any smart database people they will generally tell you that the SELECT * FROM ... is a bad idea and should not be used. Today (well would of been if I didn't procrastinate) I spent many hours debugging something from the wrong places because I used SELECT *. Below is what I found out =). Rennie Moodley helped me understand what was happening after I figured out where the problem was, helped me create the sample code below and then the 2 of us and Christopher Swart poked at and improve the sample and found some more weirdness which you'll also see below.

Posted on April 09, 2015 - Data Grab Some Coffee SQL Server T-SQL

Failover or Restart Results in Reseed of Identity - FIX

This post has been ported from http://www.sqlservercentral.com/scripts/MS+SQL+2012/93043/ which I then repeated on https://gbeeming.wordpress.com/2013/02/12/failover-or-restart-results-in-reseed-of-identity-fix/.

Posted on January 07, 2015 - Adoption Blockers Data Old Blog Posts SQL Server