SQLFAQ Home

Data Science Project Example Walk-through: Predictive Analytics on London Cycle Hire Data using the CRISP-DM and TDSP process models: #2 Waterfall v Agile (Scrum v Kanban)

In Part #1 – Backgrounder we covered a basic introduction to CRISP-DM and Microsoft TDSP, in this article we put our ...
Read More
/

Data Science Project Example Walkthrough: Predictive Analytics on London Cycle Hire Data using the CRISP-DM and TDSP process models: #1 Backgrounder

I’m embarking on a series of articles covering an end to end example of applying Data Science to a problem, we ...
Read More
/

Who did what to my database and when…

One of the most popular questions on forums / SO etc is, “How can i find out who dropped a ...
Read More
/

SQL Server – Making Backup Compression work with Transparent Data Encryption by using Page Compression

Encrypted data does not compress well if at all so using the BACKUP with COMPRESSION feature will be ineffective on ...
Read More
/

Why is creating excel sheets from SSIS so hard ?

If there is one process that should be simpler than it is out of the box, it is creating Excel ...
Read More
/

Tableau Kerberos Delegation to SQL Server / SSAS – Part 2 – Setting it up

The ability to use Kerberos delegation against SQL Server and SQL Server Analysis Services (SSAS) was introduced in Tableau Server ...
Read More
/

Tableau Kerberos Delegation to SQL Server / SSAS – Part 1 – The Theory (Kerberos Tickets, Service Principal Names and Token Size)

Active Directory is by default geared to a two tier Client/Server architecture, the Client can only use resources either locally or on the ...
Read More
/

IT Community Roadshow – Real-world stories and demos from local community experts – May 2016

The IT Community Roadshow is a series of free training events focusing on next-generation technologies including Microsoft Azure, Windows 10, ...
Read More
/

.Net 4.6.1 and MultiSubnetFailover

Im not a big clustering/HA expert, but I obviously understand the need for such things to exist However, the standard ...
Read More
/

A journey to a movie recommender in U-SQL

I haven’t gotten to involved in the whole “Big Data” movement to much,  I’ve kept an arms length watch and ...
Read More
/