Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Bradley Schacht

Bradley Schacht is a Data Platform Solution Architect on the state and local government team with Microsoft based in Jacksonville, FL. He has co-authored 3 SQL Server books including "SQL Server 2014 Professional Admin". As a former consultant and trainer, he uses his experience on many parts of the Microsoft BI and data platform to help customers deliver the best possible solutions. Bradley frequently presents at community events around the country. He is a contributor to sites such as SQLServerCentral.com and an active member of the Jacksonville SQL Server User Group (JSSUG).

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, 947 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, 963 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

5 comments, 942 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

2 comments, 955 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

0 comments, 1,018 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

3 comments, 1,139 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, 488 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, 3,277 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

4 comments, 1,584 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, 698 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, 1,424 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, 756 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, 1,784 reads

Posted in Bradley Schacht on 29 August 2013

SharePoint SSRS “The permissions granted to user ‘Domain\User’ are insufficient for performing this operation”

Not too long ago I ran into a crazy situation where just about everything that could have gone wrong with my SharePoint environment after a restore did go wrong. I was planning on blogging a bunch of it and thanks to time constraints I had to just get it backup… Read more

5 comments, 911 reads

Posted in Bradley Schacht on 27 August 2013

SQl Server 2014 CTP1

CTP 1 of SQL Server 2014 was released this evening. If you have an MSDN or TechNet account you can go grab it now! If you are curious about some of the features here is the Microsoft page and there are plenty of blogs out there as well: http://www.microsoft.com/en-us/sqlserver/sql-server-2014.aspx

This… Read more

0 comments, 518 reads

Posted in Bradley Schacht on 25 June 2013

Installing Power View for Multidimensional Models

 

Power View was a new reporting option added in the SQL Server 2012 release as part of the SharePoint integrated mode of Reporting Services. From the beginning it was limited to only reporting off tabular models (and therefore PowerPivot models as well). Power View later made its way into… Read more

9 comments, 1,440 reads

Posted in Bradley Schacht on 11 June 2013

Hide the Ribbon in Power View

There may come a day when you want to embed a Power View report into a PerformancePoint dashboard or a Web Part page in SharePoint. The first thing you will notice when entering the URL is the ribbon shows up in the web page viewer. The ribbon will be displayed… Read more

0 comments, 546 reads

Posted in Bradley Schacht on 7 June 2013

SharePoint 2010 on SQL 2012 Configuration Failed

Recently while doing an installation of SharePoint 2010 on a Windows Server 2008 R2 server with a SQL Server 2012 back end I ran into a small roadblock. The following error popped up as I was running the product configuration wizard.

 

Error!

Failed to create the configuration database.

An…

Read more

0 comments, 840 reads

Posted in Bradley Schacht on 29 May 2013

Creating a SharePoint 2013 Demo Environment – Part 1: Setting Up A Domain Controller

Development and demo environments can be hard to come by. Over the course of this series you will learn how to setup all the necessary components to create your own SharePoint 2013 demo environment. We will start with a blank Windows Server 2012 VM and conclude with a fully functional… Read more

0 comments, 1,841 reads

Posted in Bradley Schacht on 21 May 2013

Browse SharePoint in Windows Explorer

Have you ever wanted to browse your SharePoint 2010 site in Windows Explorer? If you are in SharePoint 2007 please upgrade to something a little more modern. In all seriousness, in SharePoint 2007 you could click on the Actions menu and then select Open With Windows Explorer. Simple. Easy. Read more

0 comments, 706 reads

Posted in Bradley Schacht on 14 May 2013

Newer posts

Older posts