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).

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, 432 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, 867 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, 445 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, 886 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, 427 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, 266 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, 803 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, 346 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, 492 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

2 comments, 1,187 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, 357 reads

Posted in Bradley Schacht on 14 May 2013

SQL Saturday Jacksonville 2013 Wrap-up

It was another great year at SQL Saturday Jacksonville. For the last several years I have been lucky enough to be part of the group that organizes the event. It’s definitely a lot of work leading up to the event, the others on the team definitely do more work than… Read more

0 comments, 227 reads

Posted in Bradley Schacht on 7 May 2013

Why I’m Considering a Surface and Windows Phone 8

Anyone who knows me will see the title of this post and tell you I’m about to trash the Surface, Windows 8 and Windows Phone. Let me assure you that’s not the case. I am a 100% openly admitted Apple fan. I have owned every version of the iPhone, have… Read more

1 comments, 352 reads

Posted in Bradley Schacht on 22 March 2013

SSIS 2012 Deadlock When Running SSIS from SQL Agent Job

I recently had an interesting situation where an SSIS package was scheduled to run at 1 AM but failed with a deadlock message. This seems a bit strange given that it was a deadlock on the step executing the SSIS package, not an error message from within the package. There… Read more

6 comments, 2,444 reads

Posted in Bradley Schacht on 12 March 2013

Remove Local Administrators SSAS Admin Access

Recently while changing some production security around on a new server I needed to modify the SQL Server Analysis Services (SSAS) administrator group at the server level. This is a pretty easy process; log in, add or remove admins as necessary in the security section. However, by default any user… Read more

1 comments, 454 reads

Posted in Bradley Schacht on 5 March 2013

Find Skew in Distributed Tables

The SQL Server PDW (Parallel Data Warehouse) is a beast of a machine. Spreading workload across multiple nodes inside the PDW provides a huge performance gain over a traditional SQL Server; however, when laying out tables it is a little different. There are two options for creating tables on the… Read more

0 comments, 698 reads

Posted in Bradley Schacht on 11 September 2012

Cisco VPN Client 5 on Windows 8

NOTE: Always create a backup before doing any type of Windows registry modifications!!!!

With the full public release of Windows 8 right around the corner it is inevitable that people will want to get in there and check it out. If you are working someplace that uses the Cisco VPN… Read more

10 comments, 940 reads

Posted in Bradley Schacht on 4 September 2012

Error: No mapping between account names and security IDs was done

I recently decided to move over to Windows 8 so I can take advantage of Hyper-V and get off a third party tool for virtualization. In the process I decided to rebuild my VM set up and modify the layout a little. Previously I had made each VM a domain… Read more

5 comments, 3,824 reads

Posted in Bradley Schacht on 4 September 2012

The INSTALLSHAREDWOWDIR command line value is not valid.

I was recently making some changes to my laptop setup and installing SQL Server 2008R2 and SQL Server 2012 directly on the computer rather than on my VM. In the case of my setup I had already installed the client tools for 2008R2 and 2012 on my laptop. So in… Read more

1 comments, 645 reads

Posted in Bradley Schacht on 28 August 2012

Internal error: Invalid enumeration value. Please call customer support! is not a valid value for this element.

If you have done a lot of work with SQL Server Analysis Services (SSAS) you may have seen this message:

We’ve all been there. A build error. I tend to get this because I like to forget commas when modifying calculations in the MDX section of the cube editor. It’s… Read more

2 comments, 630 reads

Posted in Bradley Schacht on 21 August 2012

Newer posts

Older posts