Category Archives for SQL

Count tables in a SQL Database

Today I hit an odd error with Entity Framework 6, finding myself with a need to Count tables in a SQL Database. The error occurred when … Well I don’t really know. I was debugging an application we’ve been working on … Continue reading

10. November 2014 by Adam Riddick
Categories: SQL | Leave a comment

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

SSRS Performance with Option(Recompile)

Sometimes, SQL Server isn’t as great as it usually is and can cause SSRS Performance issues when running queries that execute fast inside SSMS. Just the other week I was writing a simple join script against close to 200k records in … Continue reading

15. October 2014 by Adam Riddick
Categories: Business Intelligence, SQL, Tips | Leave a comment

Sql Server Reporting Google Chrome Fix

Two weeks ago, I blogged about the need for Reporting Systems to support and influence the decisions being made by any organisation. Today, I’ll explore a Sql Server Reporting Google Chrome Fix, to enable the viewing of SSRS reports in … Continue reading

11. October 2014 by Adam Riddick
Categories: Business Intelligence, SQL, Tips | Leave a comment

Backup All Databases SQL

Data is precious and for many companies data means money, directly or indirectly. More and more countries are taking up laws on the ownership storage and historical persistence of data, meaning companies need to pay attention to backups for multiple … Continue reading

05. July 2014 by Adam Riddick
Categories: SQL | 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 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