myspace live counter
Geeky Girl - Site Home - TechNet Blogs
Blog - Title

Geeky Girl

  • SQL Server Enterprise vs Standard

    SQL Server 2008 R2 comes with a lot of features and functionality. Even the Standard version has a long list of capabilities to set DBAs drooling. But then there’s the Enterprise version. A question that comes up, more often than we’d like...
  • Data Quality in SQL Server 2012 Part 1: Introducing Master Data Management

    Data quality is important and data quality mistakes can be expensive. Imagine a situation where a company has two systems, each with their own data set. One system is for CRM, the other is a financial system. Both systems have information about customers...
  • Data Quality in SQL Server 2012 Part 2: Introducing Master Data Services

    In the previous blog post , I introduced the concept of Master Data Management as a methodology to improve data quality by creating a “master” version of important information. Master Data Services is Microsoft’s technology for implementing...
  • Generating a unique form number - a SharePoint counter

    I’ve had a request to expand on my post about generating automatic numbers for InfoPath forms. I was asked to go into more detail about how to set up a SharePoint list to act as a counter. Go to the SharePoint site where you have your document library...
  • InfoPath and Excel Services

    Given that I spent a ridiculously long time trying to get an InfoPath form to interact with a spreadsheet published through Excel Services, I thought this was a suitable subject for a blog post. If I stop someone else feeling like they want to beat themselves...
  • SharePoint 2013 Snippet: Content Search Web Part

    The Content Search Web Part is a new web part in SharePoint 2013 that lets you bring together data from across SharePoint into a single view. For example, you might have a page on your intranet for engagements with a particular customer. You can use the...
  • SharePoint 2013 Snippets: Access Services

    Access Services is an interesting topic in the 2013 context. When this was described to me, my first reaction was, “but we could do that in 2010.” Then you scratch the surface and discover that everything has changed under the hood. The...
  • Connecting to Report Server

    Sometimes, people that have been working with a technology for a while assume that something is so obvious, they don’t feel it needs explaining. This means that those who are trying to wrap their heads around something for the first time could be...
  • Data Quality in SQL Server 2012 Part 3: Introducing Data Quality Services

    The previous two blog posts have been focusing on Master Data Services . Given the title of this series, it would be remiss of me to forget Data Quality Services, the second piece of the data quality story in SQL Server 2012. Data Quality Services is...
  • PowerPivot: Sort by column

    Sometimes there are measures which have an intrinsic order to them, such as days of the week or month of the year. However, this order is not always known by the technology being used to represent data by those values. For example, if I was to create...
  • InfoPath forms within SharePoint pages

    One of the great things about InfoPath 2007 is that it allows people to design forms that can be opened in an internet browser. This means, if you have a SharePoint intranet, extranet or website, you can publish InfoPath forms to SharePoint and have people...
  • Data Quality in SQL Server 2012 Part 4: Data Quality Services Client

    Data Quality Services, introduced in the previous blog post , includes two main components: DQS Server and DQS Client. There’s also a DQS Cleansing transformation included in SSIS in SQL Server 2012, but I won’t be going into that in this...
  • Books online for Power BI

    The Microsoft Office website now has some books online resources for Power BI. Power BI Getting Started Guide : http://office.microsoft.com/en-us/office365-sharepoint-online-enterprise-help/power-bi-getting-started-guide-HA104103589.aspx?CTT=1 ...
  • Workflow initiation forms

    With the 2010 version, a lot of work has been done to tighten up the integration between SharePoint and InfoPath. One example of this is workflow initiation forms. One of the things you can now do with SharePoint 2010 is create reusable SharePoint...
  • Displaying the month in an InfoPath form

    Someone asked this question on a discussion list and I thought the answer was one that others might be interested in. What do you do if you want to set a field in an InfoPath form to show the month that the form is filled out? This can be done by...
  • Generating a unique form number

    I’ve had someone ask me about automatically giving InfoPath forms a unique number. The scenario in question was one where the forms were being saved to a SharePoint document library with a unique number attached. Documents in a SharePoint library do...
  • SharePoint 2013 Snippet: User License Enforcement

    In MOSS 2007 and SharePoint Server 2010, it’s technically possible to set up an environment so that some users have the SharePoint Standard CAL and some users have the Enterprise CAL. Note the word “technically.” In order to get it to...
  • SharePoint 2013 Snippet: Machine Translation Services

    SharePoint 2013 brings in Machine Translation Services, which provides automatic content translation or packages up content in a standard format for human translation. For the automated translation, it uses a cloud-based translation service, sending content...
  • And now for something completely different

    Some of you may know that I've written a couple of books. The first, Child of the Hive , is a sci-fi adventure set in near-future England. The second is the hugely exciting Designing Forms for SharePoint and InfoPath . I have written another sci-fi...
  • Check-out and edit in SharePoint document libraries

    When I'm asked a question by a partner and feel that the answer is likely to benefit more people, I shall write a blog post about it. The question in this case was regarding checking out documents from a SharePoint document library and editing documents...
  • Better with Office - Data Connection Libraries

    Previously in this series, I’ve talked about general Office documents, which might be Word files, PowerPoint slide decks and so on. In this post, I’m going to go a bit more specific. I’m going to talk about data connection libraries and how they are they...
  • Data Quality in SQL Server 2012 Part 5: Master Data Services Excel Add-In

    In the previous post in this series (sorry for the delay), I talked about the Client for DQS. It seems appropriate then that I introduce the desktop client for MDS. In this case, the client is Excel, through a freely-downloadable add-in that runs in Excel...
  • Improving Form Performance

    When you load up InfoPath forms in a browser, do you see this message? Probably. The important question is, for how long? Does the form open in a couple of seconds, or are you sitting waiting for minutes? There are various reasons why a form...
  • Connecting two Visio web parts

    I’m taking a break from talking about forms and workflow to share a simple idea which I think is quite useful around Visio diagrams in SharePoint 2010. One of the new features in SharePoint 2010 is Visio services, which enables you to display Visio diagrams...
  • DQS: Create a New Knowledge Base

    (Please visit the site to view this video) This is the first video I've done on Data Quality Services. It shows how to get started with DQS by creating a new knowledge base and running knowledge discovery on a sample data set.