Tag Archives: SQL2012

Microsoft Connect Bug Reports

Posted on 17/05/2013 by Jens Vestergaard
Share

Just posted two bug reports to Microsoft Connect We don’t take kindly to sensitivity ’round here… First, I perceive it as a bug, when a foreach loop fails to list variables when a project parameter is set as sensitive. When a project … Continue reading →

Posted in Programming | Tagged , , | Leave a comment

SQL Server Quick Tip 16-20

Posted on 31/03/2013 by Jens Vestergaard
Share

#SQLTip #SQLServer #TSQL amzn.com/k/P3Livr0TRReO… TRUNCATE TABLE resets the IDENTITY property to its original seed, while DELETE doesn’t. — Jens Vestergaard (@vestergaardj) March 1, 2013 When dealing with parent-child pcks in #SSIS, be sure to verify the ProtectionLevel prop is set … Continue reading →

Posted in Programming | Tagged , , | Leave a comment

Run out of disk you say, eh?

Posted on 29/03/2013 by Jens Vestergaard
Share

In the rare occasion, that when you are executing a project from the Information Services Catalogs, and the SysAdmin didn’t foresee some, unforeseeable event causing the disk to run out of space. And the execution doesn’t fail, just waits for … Continue reading →

Posted in Programming | Tagged , , | Leave a comment

SQL Server Quick Tip 11 – 15

Posted on 04/12/2012 by Jens Vestergaard
Share

You can validate a #SQLServer setup by running ‘Setup.exe /Action=RunDiscovery /q’, more info at #MSDN bit.ly/TGw9Yl #SQLTip #SQL2012 — Jens Vestergaard (@vestergaardj) December 4, 2012 The only way to access SSAS is by using XML for Analysis Services Listener : … Continue reading →

Posted in Programming | Tagged , , | Leave a comment

Microsoft Connect Suggestions

Posted on 26/06/2012 by Jens Vestergaard
Share

Just posted two new suggestions to the Microsoft Connect site. First of is a suggestion, that when using a sensitive parameter, you get a warning when trying to use it in an expression. On the other hand, if you create … Continue reading →

Posted in Programming | Tagged , , | Leave a comment