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

SQL Server 2014 Launch Party Mississauga Ontario (Toronto) June 21, 2014

This event promises to be a highlight of the Canadian SQL Server calendar year. The presenters are all 'first class'. All are SQL Server MVP's and they will be addressing us in both official languages. The event is being held at Microsoft's offices in Mississauga Ontario from 10 AM to…

Read more

0 comments, 187 reads

Posted in Simon Says on 27 May 2014

SQL Server 2012 and 2014 and Windows 8.1 Professsional CPU goes up to 100% all freezes and Analysis Services Crashes

<p>Hi All This is a note that I just sent out. I hope that this helps those contemplating upgrading to Windows 8.1 Professional BEFORE SP 1 is released. Hi Dejan Once again, thanks for the reply, my friend. Really appreciated. The same to you Greg, Andrew and Viktor. Dejan, it… Read more

0 comments, 254 reads

Posted in Simon Says on 24 March 2014

Master Data Services for the Beginner Part 06

Introduction


The consumers of our data wish to be able to make stock and financial decisions from our data. Turning raw data into valuable information is one of the fortes of Master Data Services. In this part of discussion we shall be looking at ways and means of extracting valuable… Read more

0 comments, 356 reads

Posted in Simon Says on 2 February 2014

Master Data Services for the Beginner Part 05

 

Introduction

In yesterday’s discussion we looked at creating a current flag, creating views and looking at some of our data.  Today we shall be looking at creating a simple SQL Server Integration Services (SSIS) package to pull the data from Master Data Services and how to place it in… Read more

0 comments, 365 reads

Posted in Simon Says on 1 February 2014

Master Data Services for the Beginner Part 04

 

Introduction

In yesterday’s discussion we looked at populating entities and their related attributes. In today’s discussion we shall be concentrating on extracting data from Master Data Services, via views.

Getting started

We start off by bringing up the Master Data Manager in the normal manner.

Once again, my link… Read more

0 comments, 447 reads

Posted in Simon Says on 29 January 2014

Master Data Services for the Beginner Part 03

 

Introduction

In yesterday’s discussion we looked at creating entities and their related attributes. We learnt that a ‘model’ could be very loosely compared to a database, an entity to a table and attributes to the fields of a table.

Today we are going to load the raw data(member) into… Read more

0 comments, 1,842 reads

Posted in Simon Says on 28 January 2014

Master Data Services for the Beginner Part 02

 

Introduction

In the first part of this discussion, I discussed step by step instructions pertaining to getting up and running with Microsoft SQL Server Master Data Services.
In this part of the discussions we are going to discuss Entities and Attributes and the members that make up our data. Read more

2 comments, 2,310 reads

Posted in Simon Says on 27 January 2014

Master Data Services for the Beginner Part 01

 

Introduction

About 12 months ago, I started to look at Master Data Services in a serious manner. I had toyed with the product in SQL Server 2008 R2 but (like others did) found it very awkward to work with and difficult to understand. Microsoft has done a super job… Read more

2 comments, 1,197 reads

Posted in Simon Says on 26 January 2014

Master Data Services Disaster Recovery Challenges

 

Introduction

While Master Data Services is the best tool to come along to permit user to update their qualitative and quantitative data, disaster recovery from the failure of a model or the MDS database itself can be a challenge to say the least.

The main challenge comes NOT with… Read more

0 comments, 388 reads

Posted in Simon Says on 25 January 2014

SQL Server 2014: Master Data Services Backing up your data models.. A necessary evil !!

 

Introduction

A few days back, in my article entitled ‘Master Data Services 2014: Creating nightly load processes’, I discussed the setting up of a nightly batch process to update a Master Data Services 2014 application that I have recently created for our finance department.

This is fine and dandy,… Read more

0 comments, 764 reads

Posted in Simon Says on 2 January 2014

Master Data Services 2014: Creating nightly load processes

 

Introduction

A few days ago, I ran into an interesting issue when creating a stored procedure to load new data into a 2014 Master Data Services entity via a staging table and a SQL Server stored procedure. As those familiar with the product know, incoming data (for any entity)… Read more

1 comments, 1,427 reads

Posted in Simon Says on 23 December 2013

Gotcha!!! Trying to install SQL Server 2012 on Windows 8.1 Professional

OK, after several tranquillizers and much grey hair, I found out why SQL Server 2012 will NOT install on Windows 8.1 Professional. 

The issue lies with the fact that SQL Server requires the .NET Framework 3.5 ,which is NOT installed by default.

OK you say, download it from the Microsoft… Read more

0 comments, 2,341 reads

Posted in Simon Says on 7 December 2013

Setting your predicate arguments at run time Part: 2 MultiSelect

 

Introduction

A few days ago, I did a presentation for a Virtual Chapter meeting where I discussed SQL Server Data Access Layers. The user obtained his or her data by submitting an argument to a parameter. In our case, there were three of these parameters, thus requiring 3 different… Read more

0 comments, 219 reads

Posted in Simon Says on 26 November 2013

Setting your predicate arguments at run time

 

Introduction

A few days ago, I did a presentation for a Virtual Chapter meeting where I discussed SQL Server Data Access Layers. The user obtained his or her data by submitting an argument to a parameter. In our case, there were three of these parameters, thus requiring 3 different… Read more

0 comments, 197 reads

Posted in Simon Says on 24 November 2013

Monthly profit percentage techniques

Introduction

A few days ago, a friend of mine approached me with an interesting challenge. What he was trying to achieve was to extract monthly profit percentages from a SQL Server table (along with the projected monthly goal) and to place the latest month’s actuals into an SSRS gauge and… Read more

0 comments, 314 reads

Posted in Simon Says on 30 October 2013

Flexible Fiscal Data Sort

Flexible Fiscal Data Sorting A few months ago, I faced the challenge of extracting data via SQL Queries (for our enterprise), whose fiscal year runs from July through June. Further, the parameters fed through from SQL Server Reporting Services to our stored procedures, had to cater for multiple years, as…

Read more

0 comments, 474 reads

Posted in Simon Says on 2 August 2013

Dynamic calculations of running totals

 Dynamic calculations of running totals

A few weeks back, a friend from South Africa wrote to
me asking if I knew of a way to quickly produce cumulative totals from monthly
data figures. Here is one way to achieve just that.

As the fiscal year at his firm begins in… Read more

2 comments, 333 reads

Posted in Simon Says on 24 June 2013

Resolving data redundancy up front

 

Introduction

As all of us do when confronted with a problem, the resource of choice is to ‘Google it’.

This is where the plot thickens. Recently I was asked to stage data from numerous databases which were to be loaded into a data warehouse. To make a long story… Read more

0 comments, 457 reads

Posted in Simon Says on 22 April 2013

SQL Saturday 207 Yaounde Cameroon

SQL Saturday 207 Yaoundé Cameroon, is holding its first SQL Saturday on June 8th. Due to the remoteness from the US, Achilles Nguela has kindly opened the event to live meeting presentations. This is a really a great opportunity to make a BIG DIFFERENCE to the SQL Server community.… Read more

0 comments, 421 reads

Posted in Simon Says on 20 April 2013

SQL Saturday Total NOVICE sessions

Have you ever been to a SQL Saturday where someone 'rocks up' for a beginner's presentation. In fact he or she works at a help desk and the boss sent him or her, to the event, to 'learn everything there is to know about SQL Server'.

This ACTUALLY happened to… Read more

0 comments, 232 reads

Posted in Simon Says on 20 April 2013

Older posts