I will be speaking at PowerShell Conference Asia 2017
Which better way could I have to launch my blog if not with great news ?!
I am so happy and excited to announce that I will be speaking at PowerShell...
2017-08-25
Which better way could I have to launch my blog if not with great news ?!
I am so happy and excited to announce that I will be speaking at PowerShell...
2017-08-25
On my last post “SSRS Report Deployment Made Easy – 700 Times Faster” I showed how you can rely on the...
2017-08-15 (first published: 2017-07-27)
5,185 reads
Back in October 2016, Microsoft started a new GitHub repository – ReportingServicesTools – an open source PowerShell module to manage SQL Server...
2017-07-12
3,918 reads
Why am I asking?
Have you never have been in a situation where:
the master backup is corruptedyou need to rollback a password...
2017-06-22
406 reads
Today I will write about an option that is less known/used in the SSMS tool. The ‘SQLCMD Mode’ option.
What is...
2017-02-14
3,494 reads
On the 5th of January, Brent Ozar (b|t) launched a survey on “Tell Us What You Make: The 2017 Data Professional...
2017-01-23
395 reads
A few days ago I came across with a error that says “Property Owner is not available for database [XXXXXXX].”....
2017-01-19
1,019 reads
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
This book was making its rounds on social media, and the concept seems interesting...
I declare @Where based on the input parameter in the stored procedure. Set @SQL...
Hi, hoping someone can help. We're in the process of migrating to a new...
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