Category Archives for Databases

Find Active Directory Group Members in SQL Server

Active Directory Group Members in SQL SQL Server is brilliant. It’s a pleasure to work with, sometimes the queries and structures required are complex and a challenge to implement, but ultimately you can rely on the SQL engine doing it’s … Continue reading

31. October 2014 by Adam Riddick
Categories: Databases, SQL, Tips | Leave a comment

Introducing Foreign Key Constraint May Cause Cycles Or Multiple Cascade Paths

Introducing Foreign Key Constraint May Cause Cycles Or Multiple Cascade Paths “Introducing Foreign Key Constraint May Cause Cycles Or Multiple Cascade Paths” may be a message you have seen before when using Entity Framework. The error message is thrown when … Continue reading

03. September 2014 by Adam Riddick
Categories: Databases, Entity Framework | Leave a comment

SSIS If-Then-Else Derived Column

I’ve been working more and more with Sql Server Integration Services in recent times, implementing a Data Warehouse for business analysis. Today I came across the need for an If-Then-Else Derived Column, something I’ve never done before in SSIS, so I … Continue reading

11. April 2014 by Adam Riddick
Categories: Databases | Leave a comment

SQL IsNumeric

SQL IsNumeric Function Today I have been working on the Extract, Transform and Load process of the latest section of our Data Warehouse implementation. The idea is to move an Ad-Hoc analysis engine created a year ago into the Microsoft … Continue reading

09. April 2014 by Adam Riddick
Categories: Databases, SQL, Tips | Leave a comment

Useful DBCC Commands

Useful DBCC Commands Happy New Year! Here’s to hoping you enjoyed yours as much as I enjoyed mine. I’ve decided to start the new year with the same theme I ended the old, and have brought to you a list … Continue reading

04. January 2014 by Adam Riddick
Categories: Databases | Leave a comment

Useful SQL Commands For Developers

When working with databases there are always going to be commonly used commands that you use on a daily or hourly basis. But when delving a little deeper, there are functions we need to run against databases from time to … Continue reading

23. December 2013 by Adam Riddick
Categories: Databases, SQL | Leave a comment