SSMSDeploy Now Available!
I have finished my website, done all my recompilations, checked all my settings, and finally SSMSDeploy is on the internet,...
2011-01-19
592 reads
SSMSDeploy Demo #2 - new features
I've made some changes to the addin, adding some new features:
Comments: You can now add a comment to your request....
2011-01-15
598 reads
SSMSDeploy will be available, with source, for donation
After much um-ing and ah-ing I have decided to release my addin, with source code, under the GNU GPL.
I've also...
2011-01-15
561 reads
SSMS Addin Wrapper - Source Code and Usage
Code First, KTHX!
Here, as promised, is the source code for the SSMS wrapper.
Introduction
My apologies for the brief delay on this....
2011-01-10
2,342 reads
Updated SSMSDeploy Demo Video
This is just a quick note before I head off for work that I have made a new demo video...
2011-01-10
628 reads
SSMSDeploy - Demo Video Available!
Updates
1) I have discovered that there was already a tool called SQL Deploy, so I have renamed my addin to...
2011-01-09
573 reads
SSMS addin (and wrapper)
So I mentioned I'd been working on an SSMS addin. What I didn't mention was that I've also been working...
2011-01-04
1,393 reads
Easy CDC part 2: Automating a Quick Initial Load, and Some Gotchas
Introduction
A couple of weeks ago I made this post about quickly building a CDC system against a vendor ERP database....
2011-01-01
1,293 reads
Interlude: SSMS tips
Introduction
I know I said I was going to add more information about the CDC system in this post, but I...
2010-12-23
1,326 reads
Relational Types.
As I try to drag my team (sometimes with resistance, sometimes with pleasure) into the world of relational principles, I...
2010-12-23
1,083 reads
Blogs
Simple Talks Episode 9–Data masking and subsetting
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
T-SQL Tuesday #180: Avoid Perfect for Good Enough
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
Book Review – Humanizing Data Strategy by Tiankai Feng
This book was making its rounds on social media, and the concept seems interesting...
Forums
Does SSRS Report with Stored Procedure execute SQL string?
I declare @Where based on the input parameter in the stored procedure. Set @SQL...
SQL Server Constrained Delegation
Hi, hoping someone can help. We're in the process of migrating to a new...
Question of the Day
Comparing Images
I am building an ETL process between these tables in SQL Server 2022 set to 160 compatibility level:
CREATE TABLE Image_Staging ( imageid INT NOT NULL CONSTRAINT Image_StagingPK PRIMARY KEY , imagestatus TINYINT , imagebinary IMAGE); GO CREATE TABLE Images ( imageid INT NOT NULL CONSTRAINT ImagesPK PRIMARY KEY , imagestatus TINYINT , imagemodified DATETIME , imagebinary IMAGE); GOI want to run this query to check if the images already loaded exist. This will help me decide if I need to insert or update an image. What happens with this query?
SELECT i.imageid
FROM
dbo.Image_Staging AS ist
INNER JOIN dbo.Images AS i
ON ist.imagebinary = i.imagebinary; See possible answers