SSIS Catalog Execution Parameter Values
When doing any new development or major overhaul of existing SSIS architecture, I almost always recommend to clients that they...
2018-12-18
343 reads
Blog Posts
Top 50 PowerShell bloggers of 2018
My work is recognized and my blog is listed under Top 30 elite list. I am pleased, honored and humbled...
2018-12-18
247 reads
T-SQL Tuesday 109: Influence Somebody Recap
Small tokens of gratitude and small actions help to build this wonderful SQL Community that gives and gives and gives. Humility leads us to seek out ways to give...
2018-12-18
5 reads
T-SQL Tuesday 109: Influence Somebody Recap
How have you impacted somebody in the community?
This month I am in charge of the topic for TSQLTuesday. The invite...
2018-12-18
210 reads
Visualizing Merge Join Internals And Understanding Their Implications
This post is part 2 in a series about physical join operators (be sure to check out part 1 - nested loops joins, and part 3 - hash match...
2018-12-18
23 reads
Visualizing Merge Join Internals And Understanding Their Implications
This post is part 2 in a series about physical join operators (be sure to check out part 1 - nested loops joins, and part 3 - hash match...
2018-12-18
10 reads
Adding the Constraint Name to the PK at the End of Create Table–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-12-17 (first published: 2018-11-28)
2,854 reads
Azure Data Factory Data Flow
Azure Data Factory v2 (ADF) has a new feature in public preview called Data Flow. I have usually described ADF as an orchestration tool instead of an Extract-Transform-Load (ETL)...
2018-12-17
76 reads
Azure Data Factory Data Flow
Azure Data Factory v2 (ADF) has a new feature in public preview called Data Flow. I have usually described ADF...
2018-12-17
536 reads
Azure SQL Database DTU Versus vCore
I wrote a guest article for an IT consultancy on Azure SQL Database, more specifically DTUs and vCore options. At...
2018-12-17
873 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers