Dude, where’s my Power Map?
If you haven’t noticed lately, Power Map has gone into General Availability as of 25 of February 2014. It comes...
2014-03-06 (first published: 2014-02-26)
2,722 reads
Koen Verbeeck
Dealing with the mysterious “True” column in BIML
Recently I ran into the following error when compiling BIML into SSIS packages:
The message itself is not very revealing:
The data...
2014-02-18
1,006 reads
Calculating the length of a hash in SQL Server
Some time ago I added a script component to a few SSIS packages to compare rows with each other using...
2014-02-11
2,501 reads
Master Data Services (Second Edition) – Review
For the preparation of my upcoming talk about SQL Server 2012 Master Data Services on the Microsoft Business Analytics Day...
2014-01-31
1,917 reads
Star Schema The Complete Reference – Review
I finished my first book of this year and here’s the review! After I finished the newest edition of Ralph...
2014-01-23
1,176 reads
T-SQL Tuesday #50: Automation, how much of it is the same?
It’s the second Tuesday of the New Year, so here comes the first T-SQL Tuesday of 2014! SQLChow (blog | twitter)...
2014-01-14
667 reads
Happy 2014
I am a bit late with the almost obligatory “How was my past year and how do I think next...
2014-01-07
578 reads
Nominated for the Tribal Awards
I’ve been notified I am a finalist for the category Best New Voice at the Tribal Awards. These awards are...
2013-12-19
1,045 reads
Nominated for the Tribal Awards
I’ve been notified I am a finalist for the category Best New Voice at the Tribal Awards. These awards are...
2013-12-19
912 reads
SQL Server 2012 Reporting Services Blueprints – Review
Recently Packt Publishing released the book SQL Server 2012 Reporting Services Blueprints authored by Marlon Ribunal (blog|twitter) and Mickey Stuewe...
2013-12-12
771 reads
Blogs
Understanding Zonal Redundancy in Azure SQL MI
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
SQL Server Database Compatibility Levels
By Kevin3NF
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve...
The PASS Summit on Tour in the Netherlands
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Upgraded VS2019 to version 16.11.49 but I cannot access my original SSIS package
Hi I upgraded to new version of VS2019 to 16.11.49. My original SSIS package...
How do I make this one row per id
I've written this code, but it is showing right now as 2 rows per...
Question of the Day
The Updated Columns List
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers