SQLShare - Public Profile for Marco Francisco

Member for 1673 days

Marco Francisco (Author)

BI Senior Consultant

http://pt.linkedin.com/in/marcoadf

From Portugal. 26 years old. Experience in a wide variety of business intelligence projects and industries (in particular communications, automotive, billing & payments, CRM). Currently working at the biggest Portuguese communications company as BI Architect, Performance/Tuning and Project Manadgement.

Quiz Results

Questions Attempted:	139
Correct Answers:	106
Current Score:	76.00%

Videos I've made

Title	Published Date
Techniques for Deploying SSIS Packages	1/16/2011
Using Variables in a SSIS Package	10/20/2010
SSIS Variables in Parent/Child Packages and Jobs	8/8/2010
Intersect Operator	7/1/2010
Except Operator	7/1/2010
Ranking Functions - DENSE_RANK (Part 3)	6/13/2010
Ranking Functions - NTILE (Part 4)	6/13/2010
Ranking Functions - Rank (Part 2)	6/10/2010
Ranking Functions - Part 1	6/3/2010
SSRS: Information about Report Execution History	4/6/2010
Identifying and Re-running Failed Reporting Services Subscriptions	2/4/2010

Videos I've watched

Title	When Watched
Techniques for Deploying SSIS Packages	1/7/2012
Using Variables in a SSIS Package	1/4/2012
Formatting SSAS Measures	10/18/2011
Create a Symmetric Key in SQL Server 2005 / 2008	10/8/2011
What is the Scalar Operator in a SQL Query Plan?	7/30/2011
Setting Deadlock Priority	7/30/2011
Compound Assignments in SQL Server 2008	7/30/2011
Modifying SQL Server Settings with SMO	7/30/2011
Installing SQL Server 2008 Sample Databases	7/30/2011
Reversing Deadlocking - Part 3	7/30/2011
The difference between GRANT, DENY and REVOKE in SQL Server	7/30/2011
Reversing Deadlocking - Part 2	7/30/2011
Basic MERGE statements in SQL Server 2008	7/30/2011
Reversing Deadlocking - Part 1	7/30/2011
Preventing SQL Injection With String Filtering	7/16/2011
XP_cmdshell Execution in SQL Server 2005 / 2008	7/16/2011
SQL Server Properties to Avoid	7/16/2011
Transparent Data Encryption in SQL Server 2008	7/16/2011
You Can't Do That with UDF's	7/16/2011
Sparse Columns and Column Sets in SQL Server 2008	7/16/2011
Adding a Time Stamp to a File Name in SSIS	7/16/2011
Explaining The Properties Window in SQL Server Profiler	7/16/2011
Using the Fuzzy Lookup Transform	6/24/2011
Using the TSQL Checksum Function	6/24/2011
Performing Updates with Common Table Expressions (CTE)	6/24/2011
Aggregrate Queries in SQL Server T-SQL for Beginners	6/24/2011
Sparse Columns in SQL Server 2008	6/24/2011
SQL Server Login vs Windows Authenticated Logins	6/24/2011
Parameterizing the Execute SQL Task in SSIS	6/24/2011
Saving a Trace Definition in SQL Server Profiler	6/24/2011

My Playlists