All posts by Richard

NEUGS Part 3: SharePoint Permissions Basics

Halt, Who Goes There?

 

 

 

 

 

Okay, so now that we’ve gone over the basic types of things that can be done in SharePoint and the four most basic things you will be doing, I’d going to throw a little sand under these wheels and talk about permissions. Because in SharePoint, you’re not just restricted by what you don’t yet know. There are many things you may never be able to do because the site owner doesn’t think you’re the right person to do them. No offense. What you can do depends on what user permission level you’ve been given.

Basically, there are two brackets of permissions levels: those for team sites and those for other sites. Each bracket has several types of users with expanding permissions, kind of like those Russian nesting dolls. Continue reading NEUGS Part 3: SharePoint Permissions Basics

Stories from the WIT Trenches: Kendra Little

 

[This is the third in a series of posts exploring the personal stories of real women in technology. Back in April I wrote a bit about my own history and about the problems, systemic and idiosyncratic, plaguing women who chose a career in most sectors of the tech world. Writing it was surprisingly cathartic, and the response to it was powerful enough to make me want to push it further. Every woman in tech overcame at the very least statistical odds to be here; this blog series aims to find out why, and what they found along the way. To many of you reading, the name Kendra Little may ring a bell. She’s one of the most active voices in the SQL community, and her blog is crammed with tech and workplace wisdom (and amazing illustrations). Her journey to becoming the sole female member of the Fantastic Four is described below. If reading her story inspires you to share yours, please feel free to email me.]

I love data.

I’m a founding partner of Brent Ozar PLF, LLC. We’re a team of consultants who dive in to help clients identify their biggest pain points and prescribe remedies that will work for their environment. Think of us as sports medicine trainers for the database layer—we’re experts at conditioning, recovering from and preventing failures, and helping database systems do more.

I’ve loved to draw since I was a kid. I create art for presentations and posters on topics like Isolation Levels and Table Partitioning. Everyone can download my posters for free from http://BrentOzar.com/go/posters.

1)      Can you take us back to your “eureka!” moment—a particular instance or event that got you interested in technology?

One conversation changed my life. Continue reading Stories from the WIT Trenches: Kendra Little

NEUGS Part 2: Whatcha Gonna Do with All That Junk

In Part 1, I introduced you to the main capabilities of SharePoint, and the parts through which these capabilities are manifested. Now, as promised, I’m going to walk you through some of the basic end-user tasks: creating new sites, uploading documents to a library and editing them, and adding items to a list.  Why these tasks? Because, essentially, they are the gist of what you will need to do on SharePoint.

1.      How to create a new site

SharePoint, like honeybees and the British, operates on a hierarchical system. At the top of this hierarchy is the portal, which is the container that houses all your organizations’ sites, subsites, pages, mysites etc… Assuming you have a portal, please navigate to it (http://portal). Good. Now across the top navigation bar you’ll see links to whatever sites your org already has going. These are team sites. Click on one of them (in my case, it’s “Marketing”).  Now, see that button in the top lefthand corner that says “site actions?” Click it and from the drop-down, select “create new site.” Now you’ll get a pop-up menu with all the different site templates you have at your disposal. Decide which one you need, and give it a title and url, then click create. I’m going to go with “document workspace.”

 

 

 

 

 

 

2.       How to upload a document/spreadsheet/ppt etc to a SharePoint library

In case I forgot to mention this, documents are stored in libraries. All files are stored in libraries. Navigate over to your new site or any other site of your choosing that has a document library or the ability to have a document library. Click on the lefthand link that says “libraries.” It will be empty save for “Shared Documents.” “Shared Documents” is your default library, so that is where we’re going to upload to today. Click the link and then click “add document.” You’ll be guided through a routine doc upload process.

 

 

 

 

 

 

 

 

3.       How to edit a document in SharePoint

If you want to edit a document in SharePoint, just click it and change the prompt toggle form “read only” to edit. If you want to make sure nobody else makes edits while you have it, check out the document first. You do this by clicking the check box next to your document and then choosing “check out” from the ribbon options above. After you’re done editing the doc, save it and it will ask you if you want to check it back in, which you do.

 

 

 

 

 

4.       How to add an item to a list

Again, in your new site or any other site with lists, click “lists” and then select one of the available lists. I’m going with “tasks.” Because I’ve just created this new site, there are no tasks yet. Click “add new item.” A dialog box will come up asking you to at the very least give your task a name. Do so, and then assign it to someone. You can also give it a priority level, a predecessor (eg a task that needs to be completed first), a due date, a status and a % complete. When you assign the task to someone else, they’ll get an email in outlook, or they should if your SharePoint has been properly configured by someone other than yourself.

Done? Congratulations! You now know the nuts of your SharePoint bolts. Stay tuned for Part 3, wherein we’ll take on customization.

 

NEUGS Part 1: Welcome to the SharePoint Jungle

Before I came to SoftArtisans, I’d never heard of SharePoint. (You can gasp here or save it for later in the post.) As is my wont, I began using it without ever reading any documentation or general how-it-works-for-essentially-tech-illiterate-fools-type information. Which, in terms of doing most of what I need to do (uploading docs to libraries and writing blog posts on my My Site), is not the worst strategy, but it left a lot of gaps. So, with Ben’s encouragement, I recently began a comprehensive SharePoint-for-the-End-User curriculum. And, to my surprise and chagrin, found that there really isn’t one. Don’t get me wrong, End User SharePoint is an amazing resource—but I’d say it’s more tailored to post-bacs. Microsoft used to have a series of training videos, but they seem to be down at the moment, and their getting started articles are pretty skimpy early on and fragmented after the ABCs. So, like any great innovator (if you’ve been holding in that gasp, you can let it out now), I decided to create my own guide. Welcome to part one of many: What SharePoint does for me and which of its parts I will use. Continue reading NEUGS Part 1: Welcome to the SharePoint Jungle

Solving the ‘double hop’ issue using Secure Store


[Image via Fabian Williams]

Last week I was working on some ASP.NET web forms that generated internal reports against MS CRM using ExcelWriter and I wanted to port the application to one of our SharePoint instances. Though it seemed simple at first, I ran into a few issues. One of the issues happened to be authentication related. It was a typical ‘double hop’ problem where this SharePoint instance was using integrated Windows NTLM authentication and my code was trying to access the CRM SQL Server database. By nature, NTLM is unable to pass the credentials to the database thus producing access errors. (You can find more information on the NTLM issue and using Kerberos as a solution here.)

Since we don’t have Kerberos configured on this environment, our best solution was Secure Store. This service allows a user to authenticate with domain credentials and then use an account established in Secure Store to access the database. In our case, this was the read-only CRM account. This also enables easy to use and convenient access control using AD groups. Continue reading Solving the ‘double hop’ issue using Secure Store

Andrew Brust on OfficeWriter: “Enhanced Integration for Microsoft Business Intelligence”

[Click here to read the full review!]

To many of you, the name Andrew Brust might ring a bell. After all, this is a man who’s been working with, shaping and talking about Microsoft technologies for twenty years. Maybe you’ve seen him speak or read his columns on Visual Studio Magazine and Redmond Developer News. Maybe you’ve heard of his new Microsoft consulting firm, Blue Badge Insights. Maybe, like me, you follow his personal blog. I started reading Brust Blog in the beginning of the year, and it quickly became my de facto source for objective analysis of Microsoft developments. A few comments led to an email exchange that, a few months later, lead to what has got to be one of the most cogent and comprehensive summaries of an advanced technological product out there. Continue reading Andrew Brust on OfficeWriter: “Enhanced Integration for Microsoft Business Intelligence”

Cloudy with a Chance of SharePoint

There’s been a lot of talk, recently and not so recently, about SharePoint in the cloud, especially with the release of Office 365. Hell, there’s been a lot of talk about cloudification, period (though perhaps not using that particular term). Cloud computing provider CloudShare just finalized a$10 million round of vc funding, Apple is letting users store and stream backups of their iTunes downloads in the iCloud, Google Docs now has pivot tables…From financial and ease-of-use standpoints, it’s easy to see why moving data to the cloud is such an appealing proposition. From a security standpoint, as we witnessed with the Amazon/Playstation hack this year, it’s rather less appealing. And then there’s the current lack of feature paritybetween SharePoint 2010 and SharePoint Online, and the fact that the latter doesn’t support farm-scoped solutions, full-trust solutions or WebApplication-scoped features. Continue reading Cloudy with a Chance of SharePoint

STEM and the Third Culture: A Case for Interdisciplinary Education

America is having a STEM crisis, I hear. There is great need for engineers and a dearth of qualified applicants, forcing employers to outsource, ramp up international recruitment or move.  On the 2009 Programme for International Student Assessment (PISA), the US ranked 25th in math and 17th in science. A recent OECD study with Stanford University projected that a boost in PISA scores could translate to economic gains in the tens of trillions of dollars over the span of the students’ lifetime. But right now, these students are building sugar cube castles while their Asian, German and Scandinavian counterparts are using Lattice QCD to calculate the properties of hadrons. A year before the PISA rankings came out, President Obama announced that America needed more hadrons and less sugar. His “Educate to Innovate” campaign is pumping $260 million into STEM teaching programs and his Race to the Top fund provides financial incentives to states that commit to improving their STEM education efforts. Continue reading STEM and the Third Culture: A Case for Interdisciplinary Education

Stories from the WIT Trenches: Jes Shultz Borland

Photo Credit: Jes Schultz Borland

[This is the second in a series of posts exploring the personal stories of real women in technology. Back in April I wrote a bit about my own history and about the problems, systemic and idiosyncratic, plaguing women who chose  a career in most sectors of the tech world. Writing it was surprisingly cathartic, and the response to it was powerful enough to make me want to push it further. Every woman in tech overcame at the very least statistical odds to be here; this blog series aims to find out why, and what they found along the way. This week we have the dynamic and inspiring Jes Schultz Borland, whom many of you know from her incredibly active social presence in the SQL and WIT communities. In March, Jes described her professional journey,with all its dips and twists and catalysts, for SQL University WIT Week, and reading her story was part of what encouraged me to tell my own. If reading this does the same for you, please feel free to email me.]

Hi! My name is Jes Schultz Borland. I live in central WI. I’m a runner, an avid cook, a Jaycee, and a database administrator for a Fortune 500 company. I love what I do. I love keeping SQL servers running with minimal downtime, I love writing scripts to automate or fix processes, I love writing reports, and I love helping developers tune queries. I’m also very involved in the (amazing) SQL community. I love answering people’s questions, I love speaking at user groups and SQL Saturdays, I love being on the board for my user group, and I love learning. I tweet, I blog, and I speak regularly.

1)      Can you take us back to your “eureka!” moment—a particular instance or event that got you interested in technology? Continue reading Stories from the WIT Trenches: Jes Shultz Borland

Social Media for Techies: Why Do I Need It?


[Image via Life Magazine]

Are there two more groan-inducing, not-you-again, put-on-your-earmuffs words than “social media?” If you say yes, then this article might be for you. If you say no, this article still might be for you. Because regardless of whom you are and where you stand, you need to have a social media presence, and this post aims to explain why.

Social media, as I’ve sure you’ve witnessed, is now a viable form of mass communication, and its interactive, abbreviated, real-time nature has influenced our other forms of communicating. I think it’s reasonably safe to say that we tend to think and speak in shorter, more easily digestible forms today than we did when Thomas Payne wrote Common Sense (@tompayne Monarchy is oppressive. We need our own govt w/ representation for all. Who’s ready to fight for it?). We’ve become a nation of skimmers and crux-extractors and sound-biters, and if you can’t produce readily skimmable, summary-box content, well, let’s hope you’re writing for The New Yorker. Continue reading Social Media for Techies: Why Do I Need It?