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

Bradley Schacht

Bradley is a consultant at Pragmatic Works in Jacksonville, FL. He was an author on the book SharePoint 2010 Business Intelligence 24-Hour Trainer and tech edited the SQL 2011 Bible. His experience on the Microsoft BI platform includes DTS, SSIS, SSRS, SSAS and migrations and conversions. He has helped numerous companies in successfully developing and implementing new business intelligence solutions into their organizations. Bradley also participates as a speaker in community events like SQL Saturday, Code Camp, SQL Lunch and SQL Server User Groups. He is a contributor on sites such as BIDN.com and SQL Server Central as well as an active member of the Jacksonville SQL Server User Group (JSSUG).

Webinar Q&A: Getting Started with Change Data Capture

Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the T’s. I covered the basics of what Change Data Capture (CDC) is and showed how to use it. We had a good turn out, so thank you to everyone that attended. If you were unable… Read more

1 comments, 135 reads

Posted in Bradley Schacht on 25 July 2014

Find Users Logged Into Remote Computer

Have you ever wanted to find out if someone is logged into a computer or maybe who is logged into a computer without having to remote in to check? Recently I was working on a project doing some SharePoint work using 3 accounts: Admin/Install, Farm and Service. The work I… Read more

3 comments, 8,745 reads

Posted in Bradley Schacht on 23 July 2014

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… Read more

0 comments, 119 reads

Posted in Bradley Schacht on 21 July 2014

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,… Read more

0 comments, 1,647 reads

Posted in Bradley Schacht on 29 April 2014

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… Read more

0 comments, 220 reads

Posted in Bradley Schacht on 21 March 2014

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.

Error!

Read more

0 comments, 236 reads

Posted in Bradley Schacht on 4 March 2014

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… Read more

0 comments, 341 reads

Posted in Bradley Schacht on 28 February 2014

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… Read more

0 comments, 153 reads

Posted in Bradley Schacht on 30 December 2013

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… Read more

0 comments, 227 reads

Posted in Bradley Schacht on 6 December 2013

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.… Read more

2 comments, 186 reads

Posted in Bradley Schacht on 5 December 2013

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… Read more

1 comments, 235 reads

Posted in Bradley Schacht on 4 December 2013

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… Read more

1 comments, 227 reads

Posted in Bradley Schacht on 3 December 2013

Webinar Q&A: SSIS Design Patterns for Loading a Data Warehouse

I’m not going to sugar coat it. I’ve been a bit of a slacker lately. Unfortunately I didn’t get the Q&A for my two webinars up the week I did the presentations. So here is part 1 and the SSAS post will be separate. To start with, thank you for… Read more

2 comments, 251 reads

Posted in Bradley Schacht on 3 December 2013

Setting the Default View on a SharePoint Library

There could be a number of reasons why you would want to change the default view on a SharePoint library. Perhaps you created a new view and want to make it the default. Maybe you created a PowerPivot library and don’t have Silverlight installed. The list could go on. Luckily… Read more

0 comments, 255 reads

Posted in Bradley Schacht on 8 October 2013

SSIS Tips and Tricks Q&A

Thank you to everyone who attended my webinar on SSIS Tips and Tricks on October 3, 2013. The link to the recording can be found here. You can also check out all the Pragmatic Works Free Training videos here.

I had several people ask about PASS Summit. So… Read more

1 comments, 2,718 reads

Posted in Bradley Schacht on 7 October 2013

SharePoint Reporting Services Content Types Missing

Being able to manage the content types in your SharePoint libraries is key to creating a useful portal. Among the necessary content types are those associated with SQL Server Reporting Services (SSRS). If you create a new document library and want to add the ability to create data sources, reports… Read more

3 comments, 502 reads

Posted in Bradley Schacht on 2 October 2013

Free SSIS Tips and Tricks Webinar

On Thursday of this week I will be presenting a webinar for Pragmatic Works Free Training on the T’s. I hear Rachel is planning on doing leprechaun facts before I present and you won’t want to miss those. My topic this week is going to be SSIS Tips and Tricks.… Read more

0 comments, 376 reads

Posted in Bradley Schacht on 2 October 2013

Setting Up a Domain Controller with PowerShell

Quickly setting up a domain controller is a vital step in creating a good demo environment. This post will walk you through a quick and easy set of scripts to get started.

Step 1: Download and Install Windows Server 2012

If you don’t already have a blank image with Windows… Read more

1 comments, 815 reads

Posted in Bradley Schacht on 2 October 2013

Converting SQL_VARIANT on PDW

There are a number of data types that are currently unsupported on PDW. Among those are SQL_VARIANT. The interesting part of that is that SQL_VARIANT along with several other unsupported data types are found all over the place in system tables in PDW. There is a simple solution, convert the… Read more

0 comments, 408 reads

Posted in Bradley Schacht on 6 September 2013

Data Mining with Excel Q&A

Thank you to everyone who attended my free webinar on August 29, 2013 where I talked about using the Data Mining Add-in for Excel. If you were unable to attend you can find the recording here. You can also check out all the Pragmatic Works Free Training videos here Read more

0 comments, 603 reads

Posted in Bradley Schacht on 29 August 2013

Older posts