How To Use the Unpivot Transform in SSIS
Moving data from columns to rows can be a tricky task and accomplished in a variety of ways. That may be...
2014-11-17 (first published: 2014-11-11)
8,005 reads
Blog Posts
Interview Questions on SQL Server Database Mirroring
1) What is default port of Database Mirroring Endpoint? Ans : 5022 2) Database Mirroring comes with which edition? Ans: SQL Server 2005 SP1. Or SQL Server 2005 RTM...
2014-11-17
6 reads
Interview Questions on SQL Server Database Mirroring
1) What is default port of Database Mirroring Endpoint?
Ans : 5022
2) Database Mirroring comes with which edition?
Ans: SQL Server 2005 SP1....
2014-11-17
20,515 reads
Last Weeks Top “Reading” Links #109
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-11-17
683 reads
Quickly Add Telnet
Have you found yourself on a server or workstation that doesn't have telnet (typical in new builds and new Azure...
2014-11-17
1,316 reads
Thoughts on Speakers and Topics for PASS Chapters
After wrapping up my part of SQLSaturday Orlando this year I’ve been thinking on what if anything we might do...
2014-11-17
753 reads
PASS Summit 2014 Recap
Every autumn one can observe the pilgrimage of almost all Microsoft Data Platform specialists (SQL Server, Excel, Azure Platform) for...
2014-11-16
309 reads
T-SQL Tuesday #60 Roundup – Step Right Up
We had a great turnout for this months T-SQL Tuesday Block Party. Coming into this month and knowing that I...
2014-11-16
620 reads
How to fix: Visual Studio 2012 startup problem: The 'HDIProjectPackage' package did not load correctly.
After installing Community Edition of VS2013 with some additional packages i've noticed that my VS2012 starts failing to start with...
2014-11-15
3,803 reads
PASS SQL Saturday Events: December 2014
DateEventDecember 6 SQLSaturday #359 – Istanbul 2014December 6 SQLSaturday #351 – Lima 2014December 6 SQLSaturday #347 – Washington DC 2014December 13 SQLSaturday #356...
2014-11-15
557 reads
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers