Using a Variable to Populate the Query in a Lookup in SSIS
I encountered a situation on my last SSIS project in which I needed to be able to populate the query in lookup...
2015-12-29
831 reads
Blog Posts
Why use a data lake?
Previously I covered what a data lake is (including the Azure Data Lake and enhancements), and now I wanted to touch...
2015-12-29
3,319 reads
Indexing Strategy
What do I care about when I’m playing with indexes? That’s easy. I want as few indexes as possible efficiently referenced...
2015-12-28 (first published: 2015-12-16)
3,530 reads
Thank You for More Than You Realize
Blogging and presenting have changed me for the better, and in ways I didn’t see coming. However, I know I wouldn’t...
2015-12-28
689 reads
Thank You for More Than You Realize
Blogging and presenting have changed me for the better, and in ways I didn’t see coming. However, I know I wouldn’t have had them if it wasn’t for three things. Getting...
2015-12-28
6 reads
What does that N in nvarchar really mean?
In any study of Data Types in SQL Server you are going to have to look at the various string...
2015-12-28
2,388 reads
What is an execution plan? When would you use it? How would you view the execution plan?
An execution plan is basically a road map that graphically or textually shows the data retrieval methods chosen by the...
2015-12-28
859 reads
When Should You Use Identity as a Clustered Index Key?
A few days ago, while delivering my session, The Data-Loading Performance Presentation, I was asked when, performance-wise, Identity should be...
2015-12-28 (first published: 2015-12-16)
3,815 reads
Presentations & Blogging of 2015 in Review
Another year is coming to an end and I am doing a review of which goals I have managed to...
2015-12-27
766 reads
Top 10 Enhancements to Azure SQL Database in 2015
Top 10 Enhancements to Azure SQL Database in 2015DECEMBER 27, 2015
Introduction
2015 has been a massive year for Azure SQL Database....
2015-12-27
1,013 reads
Blogs
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers