Click here to Skip to main content
12,405,543 members (57,031 online)

Articles by Sifiso W Ndlovu (Technical Blogs: 13, Tip/Trick: 1)

Technical Blogs: 13, Tip/Trick: 1

RSS Feed
No articles have been posted.

Average blogs rating: 4.53

Document / View
General
Posted: 11 May 2015   Updated: 11 May 2015   Views: 2,962   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
XML Document Sourced SSRS Report Using HTTP URL
Posted: 17 May 2015   Updated: 17 May 2015   Views: 4,752   Rating: 4.33/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
IntroductionThe post, XML Document Sourced SSRS Report Using HTTP URL, demonstrated how a SQL Server Reporting Services (SSRS) data source can be used to reference an Extensible Markup Language (XML) document located via Hypertext Transfer Protocol (HTTP) protocol-based URL.
Files and Folders
Compression
Posted: 13 Feb 2013   Updated: 13 Feb 2013   Views: 8,083   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
Using SQL Server Integration Services' Execute Process Task to compress a CSV file into a zip format using 7-Zip.
Memory Mapped Files
Posted: 13 Feb 2013   Updated: 13 Feb 2013   Views: 17,599   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
AbstractThis blog post is in response to a request/comment from Thato in this previous article. Hence, I have taken much of the logic used in the aforementioned article and changed it from static to dynamic file compression.
User Controls
General
Posted: 13 Feb 2013   Updated: 13 Feb 2013   Views: 19,214   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
AbstractThe growing popularity of the use of social networks by businesses indicate a possible change in ETL requirements.
Content Management Server
General
Posted: 19 Feb 2013   Updated: 19 Feb 2013   Views: 12,405   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
AbstractSQL Server Integration Services 2012 comes with a new API for scripting packages which is called MOM – Managed Object Model.
Database
MySQL
Posted: 7 Mar 2016   Updated: 15 Mar 2016   Views: 2,720   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Duplicate MySQL table using phpMyAdmin
SQL Reporting Services
General
Posted: 19 Feb 2013   Updated: 19 Feb 2013   Views: 4,640   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
AbstractSQL Server Integration Services 2012 comes with a new API for scripting packages which is called MOM – Managed Object Model. This API is accessed through the Microsoft.SqlServer.Management.IntegrationServices.dll assembly file.
Posted: 15 Jun 2015   Updated: 15 Jun 2015   Views: 800   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Some SSRS controls, such as charts, that references NoDataMessage property have by default the “No Data Available” caption to handle instances whereby an empty result set is returned.
Posted: 21 May 2016   Updated: 21 May 2016   Views: 2,430   Rating: 3.40/5    Votes: 3   Popularity: 1.43
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
SQL Server exercise for data warehouse candidates
Work Issues
Pro Developer
Posted: 30 Mar 2016   Updated: 30 Mar 2016   Views: 1,960   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
How TFS work items can be multi-tagged using Microsoft Excel
Uncategorised Technical Blogs
General
Posted: 6 Jul 2015   Updated: 6 Jul 2015   Views: 1,781   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 17
Execute All Packages Within SSIS Project Catalog
Reviews on Third Party Products and Tools
General
Posted: 30 Aug 2015   Updated: 30 Aug 2015   Views: 621   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
Data modelling is a pivotal skill that every practitioner in data management should acquire. That said, there are numerous tools that can be used to model data. As a Certified Microsoft Professional, my default modelling tool has always been Microsoft (MS) Visio and sometimes, Visual Studio.

Average tips rating: 5.00

Database
SQL Server
Posted: 22 Feb 2016   Updated: 22 Feb 2016   Views: 3,980   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 53
This tip illustrates a workaround to SQL Server pivoting on variable character data types.
No reference articles have been posted.

Sifiso W Ndlovu
Technical Lead select SIFISO
South Africa South Africa
Sifiso W. Ndlovu is a certified Microsoft professional who holds a Master’s degree in IT Management from the University of Johannesburg. He specializes on a range of enterprise and consumer technologies using open source and proprietary software. He is the member of the Johannesburg SQL User Group wherein he has made several presentations on User Group Meetings and SQL Saturday sessions. He has written for a number of publications including SQLShack.com and SQLServerCentral.com.


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 29 Jul 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid