Who is online?  0 guests and 1 members
Home  »  Blogs  »  BradSchacht

Communifire Blogs

Blogs RSS Feed

BradSchacht : Most Recent postings

BradSchacht

Find Skew in Distributed Tables

9/11/2012 by BradSchacht  -  Comments: 0  -  Views: [1672]

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 disk: Replicated: The entire table is stored on each node of the PDW Distributed: The table data is spread over all the nodes Skew comes into play when talking about distributed tables. Skew is when data...

Read More

BradSchacht

Cisco VPN Client 5 on Windows 8

9/11/2012 by BradSchacht  -  Comments: 6  -  Views: [59744]

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 client you may run into a little issues getting it to work on Windows 8. Luckily the fix is REALLY simple. I’m sure they will add support in the future, but for the time being check out the issue and fix below. Th...

Read More

BradSchacht

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

9/11/2012 by BradSchacht  -  Comments: 1  -  Views: [7399]

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 controller that needed to be joined to a domain. This was ok in the previous setup as communication between VMs was a pain. With Hyper-V though I decided to create one domain controller and join the other VMs to it in an attempt to boost my SharePoi...

Read More

BradSchacht

The INSTALLSHAREDWOWDIR command line value is not valid.

8/28/2012 by BradSchacht  -  Comments: 1  -  Views: [2754]

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 this instance I was simply adding the rest of the SQL tools (IS, RS, AS, BIDS, etc). Much to my surprise when I went to install 2008R2 onto my laptop I ended up with a strange error message: The message says there are validation errors on th...

Read More

BradSchacht

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

8/21/2012 by BradSchacht  -  Comments: 4  -  Views: [8759]

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 a fun little game I like to play to keep myself on my toes...question mark?? Anyway, what follows this message box is usually something that you can go fix, like adding the comma or semicolon back into the calculate script. Sometimes, h...

Read More

BradSchacht

Modify Host File on Windows 7

8/21/2012 by BradSchacht  -  Comments: 0  -  Views: [1255]

Modifying the Windows host file can be a great way to ensure that you don't accidentally modify production while doing development or just redirecting traffic on your computer. For instance, while at a client's office I was able to access a server by entering just the server name, but when working remote via VPN I was required to enter IP address or the server. Luckily while on the network I could access the server by IP also. All the SSIS packages used the server name, so it made testing from o...

Read More

BradSchacht

View Flat File Contents Using PowerShell

8/21/2012 by BradSchacht  -  Comments: 0  -  Views: [1597]

We have all been there; you need to take a look at the data inside a file. Sure you can open it in Notepad if it is under 20-30MB, bigger than that and you may run into problems depending on the computer. Sometime WordPad will handle the larger files, again up to about 60MB is where I tend to run out of luck. So what happens if the file is a hundred MB? 200 MB? How about 1 GB? I've recently been working on a PDW and it isn't uncommon to see files that are many GB in size that need to be loaded i...

Read More

BradSchacht

Exporting Data Using BCP

8/21/2012 by BradSchacht  -  Comments: 1  -  Views: [4446]

BCP, or bulk copy program, has been around in SQL Server for a long time. It is a great way to export large quantities of data very quickly from SQL Server. It can be used to export entire tables or even a custom query. In this post we will focus on doing some simple commands to export data. This is by no means a complete and comprehensive look at BCP. My only intention with this post is to get you started and maybe provide a quick syntax reference for doing BCP in the future. The obvious choice...

Read More

BradSchacht

Color Expressions In SSAS

7/27/2012 by BradSchacht  -  Comments: 1  -  Views: [4577]

Color expressions in SSAS allow you to build an MDX expression to control the color of text displayed in a calculation. This property can be found in the Calculations tab of the cube editor when working in BIDS. Simply select a calcuation and look for the section labeled Color Expressions between the Display Folder and Font Expressions in the Additional Properties. Simply enter a condition in the box as shown above when the results of the condition being the colors you would like the text to be....

Read More

BradSchacht

Office 2013 and SharePoint 2013 Beta

7/17/2012 by BradSchacht  -  Comments: 0  -  Views: [1857]

If you follow anything outside the regular SQL Server world coming from Microsoft it should be Office and more importantly SharePoint. The two follow the same release cycle and as of today (July 16th actually) they have released a public beta for Office and more importantly SharePoint 2013! If you are interested in the SharePoint 2013 preview you can head over here ( http://technet.microsoft.com/en-US/evalcenter/hh973397.aspx?wt.mc_id=TEC_121_1_33 ) and grab a copy of it. The download weighs in ...

Read More

BradSchacht

PowerPivot for Excel 2013

7/17/2012 by BradSchacht  -  Comments: 0  -  Views: [4258]

The preview for Office 2013 is live!! You can hop over to the Microsoft website and grab it here: http://www.microsoft.com/office/preview/en/try-office-preview . Naturally I am eager to see all the BI features in both Office and SharePoint. If you have ever used PowerPivot then you know how cool the technology is. Well, with Office 2013 it gets even better. If you recall, PowerPivot WAS an add-on for Excel 2010 available for download at PowerPivot.com. Well, in Office 2013 that all changes; Powe...

Read More

BradSchacht

PowerPivot for Excel Now 2012 Only

7/17/2012 by BradSchacht  -  Comments: 0  -  Views: [1589]

I’m not exactly sure when this happened, but it looks like Microsoft has moved past the PowerPivot 2008R2 and PowerPivot 2012 model and is now just offering PowerPivot on their website. Previously there were two options as I just mentioned with the 2012 version being labeled RTM. Now that the 2013 previews of the office suite are out there it looks like Microsoft is officially pushing PowerPivot 2012 on everyone and no longer offering the download for 2010. Ultimately this is a good sign a...

Read More

BradSchacht

Understanding the CDC State Value

7/17/2012 by BradSchacht  -  Comments: 0  -  Views: [1395]

If you are using Change Data Capture (CDC) it can be very useful to look at the CDC State table to understand what is happening. I am writing this in the context of using SSIS 2012 CDC components; in this case the CDC Control Task. The CD State can be very helpful to determine why data isn’t getting loaded right after an initial load for instance, which is when I decided to dig into the state shown in the state table. The CDC state is used to maintain the state of the loading process. It i...

Read More

BradSchacht

SSIS 2012 Change Data Capture (CDC) Control Task

7/17/2012 by BradSchacht  -  Comments: 1  -  Views: [2371]

Change data capture was introduced in SQL Server 2008 and has been pretty popular ever since. The basic concept behind it is that all changes (inserts, updates, deletes) are captured and the details made available in a consumable manner. This means ultimately that all changes will be written to a table you can query to see everything that has been going on. In SSIS 2008 it was a little cumbersome to maintain and get data out of the CDC tables. SSIS 2012 has made that much easier with the additio...

Read More

BradSchacht

Speaking At PASS Summit 2012

7/17/2012 by BradSchacht  -  Comments: 1  -  Views: [762]

It’s about that time again, PASS Summit 2012 is right around the corner in Seattle, WA. It will be held at the convention center from November 6-9. This year will feature more than 170 sessions across 6 tracks from 90 speakers in addition to 2 days of pre-cons; and that doesn’t even include the sessions from Microsoft! I have spoken at a lot of SQL Saturdays, code camps and done a handful of webinars for Pragmatic Works over the last couple of years and decided to take a shot and sub...

Read More

BradSchacht

SQL Server 2012 PowerPivot for Excel Prerequisites Error

4/5/2012 by BradSchacht  -  Comments: 2  -  Views: [2963]

PowerPivot was a great new tool when it released several years ago. Now the newest version is out along side SQL Server 2012.You can still install the 2008 R2 version of PowerPivot or you can try out the new 2012 RTM version. There are some nifty improvements that Devin Knight has chronicled ( Blog | Twitter ). There are several requirements that are not part of the 2008 R2 requirements. The install instructions are the following with the first step being the new requirements: Install .NET Frame...

Read More

BradSchacht

Unsupported Features in Excel Services SharePoint 2010

4/2/2012 by BradSchacht  -  Comments: 0  -  Views: [3320]

Between SharePoint 2007 and SharePoint 2010 there were many new features that were added or enhanced. There still remains a list of items that are either unsupported actions, such as workbook authoring, or unsupported features, such as cell comments. In Excel Services 2007 many unsupported features would cause the workbook to not load at all and have since had the behavior changed in 2010. The following is a list of features that would prevent the workbook from loading in 2007. They are still un...

Read More

BradSchacht

Mirroring Support for SharePoint 2010 Databases

4/2/2012 by BradSchacht  -  Comments: 0  -  Views: [6086]

Like all systems built on top of SQL Server SharePoint 2010 needs to have a plan for availability. There are many methods for configuring high availability, one of which is database mirroring. Other options, such as clustering will be discussed separately. Database mirroring is a SQL Server technology used for providing database redundancy. It is configured on a database level, not the server level. With this method any transaction on the the principal server are sent to the mirror server/databa...

Read More

BradSchacht

Trim Functions in SSIS

3/23/2012 by BradSchacht  -  Comments: 0  -  Views: [3469]

In T-SQL there are many functions there to help do a variety of different things. SSIS is no different. In fact, a good number of the commonly used functions from T-SQL are in SSIS as well. Here we will explore the different Trim functions found in SSIS. We will be using the test phrase " Test " to illustrate the three functions: LTRIM, RTRIM and TRIM. LTRIM (Left Trim): Just as in T-SQL, this removed empty spaces from the beginning (or left) of a string. Notice the highlighted result that the t...

Read More

BradSchacht

Excel Source The Output Column Failed Because Truncation Occurred

3/23/2012 by BradSchacht  -  Comments: 1  -  Views: [6348]

In an SSIS package you have the option to choose from a wide range of source from Flat Files to writing queries using OLEDB sources such as SQL Server. Often times, such as writing queries against SQL Server, the metadata will come from the table and you won't need to worry about truncation in the source. Flat files are scanned and metadata is chosen based on the file so those are usually good to go as well. Excel however tends to just use the default length on all columns of 255 characters. Thi...

Read More

BradSchacht

Check Version of SharePoint 2010 Currently Installed

1/11/2012 by BradSchacht  -  Comments: 0  -  Views: [6705]

There are several ways to check the version of SharePoint 2010 currently installed in your environment. That about sums up what we are talking about here. Check it out below. Method 1: Through SharePoint 2010 Central Administration: Open SharePoint 2010 Central Administration Click on the link for System Settings Click the link for Manage Servers in This Farm Look at the Configuration Database Version field Method 2: A detailed list through SharePoint 2010 Central Administration: Open SharePoint...

Read More

BradSchacht

Installing SharePoint 2010 and SQL Server 2012 RC0

1/10/2012 by BradSchacht  -  Comments: 2  -  Views: [4294]

With SQL Server 2012 right around the corner and Release Candidate 0 already out there I'm sure you will all want to see the cool new stuff that SharePoint has to offer. There are a number of changes coming to SharePoint with the SQL 2012 release including the much anticipated PowerView . A number of enhancements have been made to the installation process as well as the consolidation of Reporting Services for SharePoint integration; which is now all handled through Central Administration rather ...

Read More

BradSchacht

The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.

1/5/2012 by BradSchacht  -  Comments: 0  -  Views: [2304]

You may fire up the SharePoint 2010 Management Shell (which allows you to run PowerShell commands to do cool SharePoint stuff, very technical… I know) and get the following error: The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered. I have found there are two places you may get this error: The first is kind of a “duh” moment if you will: not running the Management Shell as an administrator will produce this error every time if UAC is turned on...

Read More

BradSchacht

SharePoint 2010 Your Backup Is From A Different Version Of Microsoft SharePoint Foundation

1/4/2012 by BradSchacht  -  Comments: 0  -  Views: [8753]

Restoring a SharePoint site collection can be a pretty easy task. If your interested in how to do that check this blog ( Backup and Restore SharePoint 2010 Site Collection With PowerShell ) where I explain the process. Unfortunately this is not always a foolproof process as I have recently found out. Most errors are pretty self explanatory such as the site collection already exists, in which case change use the -Force command to overwrite it. I recently came across the following error: Restore-S...

Read More

BradSchacht

Marking a Disk Partition as Inactive

12/20/2011 by BradSchacht  -  Comments: 0  -  Views: [3248]

If you are like me then you like to reinstall Windows on your laptop every few months to keep things fresh and running smoothly. That or your even more like me and you download some beta version of software and install it on your laptop rather than a VM and screw something up to an unrepairable state. Either way Windows is being reinstalled. I have a laptop without an optical drive in it. The vast majority of the time I don’t mind as I pretty much use ISO files exclusively. This is a probl...

Read More