SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Dimensional Modelling in Lucidchart vs Visio: Part 1

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. However, I’ve… Read more

0 comments, 1,085 reads

Posted in on 30 August 2015

Using SSIS to Import HTTP-Based XML Document


The 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. Another approach to reporting off an XML document is… Read more

1 comments, 551 reads

Posted in on 17 May 2015

XML Document Sourced SSRS Report Using HTTP URL


In my Business Intelligence development experience, most of my SQL Server Reporting Services (SSRS) Reports have largely been based off a relational data sources such Microsoft SQL Server and Oracle database. However, in some instances whereby an SSRS report is based off Operational Data Source (ODS) or Online transaction… Read more

0 comments, 406 reads

Posted in on 11 May 2015

Failing to Preview Report in Report Builder


We recently delivered a SQL Server 2012 Reporting Services solution to a client with an additional capability for client’s business users to be able to design, develop and publish ad hoc reports using Report Builder 3.0. During unit testing we had one of the Business Analysts (BA) in… Read more

2 comments, 2,055 reads

Posted in on 28 February 2013

Compress Dynamic Files Using 7-Zip in SSIS


This 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. Thus, I am still using SQL Server Integration Services‘s Execute… Read more

5 comments, 448 reads

Posted in on 30 December 2012

Using REST API in SSIS to Extract Top 100 User Tweets


The growing popularity of the use of social networks by businesses indicate a possible change in ETL requirements. Part of this change is that developers had to revise existing ETL model such that it caters for sourcing of data off the internet in addition to the traditional flat files… Read more

4 comments, 392 reads

Posted in on 24 November 2012