Jul 21

Rename SharePoint Central Administration Database

SharePoint uses a series of SQL Server databases to save configuration information, security setups and all the user data that has been created. The Central Administration site is no different and has its own content database that is created when running the SharePoint configuration wizard. Unfortunately, unlike when creating service applications, you do not get …

Continue reading »

Apr 29

Find SQL Database Owner with T-SQL

One thing that on occasion bugs me about PDW or APS or whatever it happens to be called this week is the lack of a UI to do things. I’m not one of those people who has to have a UI to perform operations. I have no problem creating databases, doing backups or creating tables …

Continue reading »

Mar 21

Webinar Q&A: Getting Started With Analysis Services

I recently presented a free webinar for Pragmatic Works Free Training on the T’s about Getting Started With Analysis Services. We covered some of the differences between the two project types at a high level then built one of each to give everyone an idea of how difficult and how fast each could be developed. …

Continue reading »

Mar 04

SharePoint 2013 – Failed to install the product: D:\global\oserver.msi ErrorCode: 1603(0×643)

I often do my SharePoint setups on virtual machines since I need to build them up and tear them down frequently. Hyper-V is a beauty when it comes to demo environments. A few weeks ago I was doing an install and got an error that was absolutely no help. Well thanks. That’s completely unhelpful. To …

Continue reading »

Feb 28

Webinar Q&A: New BI Features in SharePoint 2013

I recently presented a free webinar for Pragmatic Works Free Training on the T’s about new Business Intelligence features in SharePoint 2013. If you attended I want to say thank you. It’s always a fun time presenting and the audience is always a lot of fun to interact with before presenting. If you were unable …

Continue reading »

Dec 30

A New Year is Right Around the Corner

If you read my 2013 Year In Review you may be here today wondering why I haven’t posted anything despite my stated desire to blog more over the next year. Well, it’s not because I’m waiting until after the new year or anything like that….well, not that may sound a little bit like a lie …

Continue reading »

Dec 06

Presentation Update: New BI Features in SharePoint 2013

It’s time for another free webinar!! Whether you like it or not SharePoint is here to stay! With every release of SQL Server or SharePoint (which follow different release cycles) the feature set for Business Intelligence professionals gets more fragmented and more complicated. If I want to get Feature A what combination of SQL Server …

Continue reading »

Dec 05

Presentation Update: Change Data Capture (CDC) Made Easy With SSIS 2012

Come get your learn on with Pragmatic Works and myself! In January I’ll be dropping some knowledge about change data capture and how to consume it with SSIS. CDC is one of the features I wish more of my clients were leveraging. It makes doing incremental loads dramatically more simplified. In this session I’ll show …

Continue reading »

Dec 04

Year In Review: 2013

Ok, so it’s not quite the end of the year yet. I figured I would get a head start on things. Who says that this type of post has to come on January 1st though? Well here goes. Let’s talk a little bit about what has happened in the last year and some of my …

Continue reading »

Dec 02

Webinar Q&A: Practical SSAS: Getting Started with Analysis Services

A couple of weeks ago I did two webinars for the Pragmatic Works Free Training on The T’s. The first was a session on how to load a data warehouse with SSIS. The followup session was about getting started with SQL Server Analysis Services (SSAS). You can find the link to the recording here. The …

Continue reading »

Older posts «