100 Video and Why BI Projects fail
We thought that our 100 YouTube video on our Katie and Emil YouTube Channel should be a special one... so...
2013-01-14
812 reads
1h SSIS Webinar
1h Free SSIS Webinar - 7th of Feb 2013
We recently submitted a session for SQL Bits and SQL Saturday (UK) and...
2013-01-14
723 reads
SSIS Precedence Constraint Tutorial
Recently we decided to create a series of videos for our SSIS Precedence Constraint Tutorial which is part of our...
2012-12-26 (first published: 2012-12-18)
9,164 reads
Katie and Emil come back
We are back on SQL Server Central... This is our first post after a while; also a test to see...
2012-12-02
741 reads
Video Enable PowerPivot Add-in
This is one of our first PowerPivot video tutorials and this short 1 minute tutorial we show how to enable...
2012-07-30
1,627 reads
reconfigure vs reconfigure with override
You can change server properties of SQL Server using sp_confgure and to "save" it you need to use reconfigure. In...
2012-07-28
2,319 reads
transparent data encryption steps
In this blog post I show steps that are needed to enable Transparent Data Encyption on a SQL Server 2012...
2012-07-28
1,580 reads
Introducing PowerView with Excel 2013
In this blog post we show video that introduces PowerView with Excel 2013. You provide an overview of the tool...
2012-07-25
1,752 reads
SSIS aggregate transformation
In this SSIS 2012 tutorial we will show you how to use data flow Aggregate Transformation and we will use...
2012-07-25
1,761 reads
PowerPivot diagram view missing
Some of you might be wondering why Diagram View is missing in some PowerPivot windows. This is related to Microsoft...
2012-07-24
2,378 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers