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
Katie and Emil
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
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
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
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
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
SQL FOREIGN KEY CONSTRAINT Syntax
You can enforce referential integrity (ensure you don't get orphans) by adding Foreign Key Constraint and in this tutorial you...
2012-07-24
929 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable caloled MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers