Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: October 2011

GiveCamp Tampa 2011

This past weekend I participated at GiveCamp Tampa 2011 (http://www.givecamptampabay.org/) as part as the Worldwide GiveCamp (http://www.givecamp.org) weekend sponsored by Microsoft and other partners. Per GiveCamp’s website:

GiveCamp is a weekend-long event where technology professionals from designers, developers and database administrators to marketers and web strategists…

Read more

0 comments, 570 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 24 October 2011

Todo lo que debes saber sobre SSIS en 1 hora!

Gracias a lo asistentes de mi charla Todo lo que debes saber sobre SSIS en 1 hora! en el evento 24HOP LATAM. La verdad me agrado mucho presentar en espanol. Aun cuando mi primera lengua es espanol, todas las presentaciones tecnicas en el pasado las he realizado en ingles.

Si… Read more

0 comments, 661 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 20 October 2011

MDS Error: MDMMemberStatus does not de-activate members through the StgMemberAttribute table

Master Data Services provides a way of de-activating entity members using the StgMemberAttribute table as described in Books On Line http://msdn.microsoft.com/en-us/library/ee633772.aspx

This is a somewhat straightforward approach and requires for you to populate the StgMemberAttribute table with AttributeCode (actual code of the member in MDS), AttributeName as “MDMMemberStatus” and AttributeValue… Read more

0 comments, 465 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 11 October 2011

Useful queries #3: Get SQL Server Edition, Version, Build and Last Update date and time.

Keeping track of all the versions and editions SQL Server instances can be a daunting task if you don’t have the right tools and documentation. A very easy way to obtain version, edition and build information from your SQL Servers is by querying the SERVERPROPERTY function as follows:

SELECT
SERVERPROPERTY(‘Edition’)… Read more

1 comments, 659 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 11 October 2011