Özgür Aytekin - Today's problems come from yesterday's solutions

Format a SharePoint Calculated Field with Prefix 0

2009-12-06T11:27:00.003+01:00

You can use the TEXT function in SharePoint for the prefixing a calculated field with 0.

In my case, my source data was 123 and the wished result was 000123

Use the following formula to get the formatting text:
=TEXT(123;"00000#")

With an existing field-value, you can use the following formula:
=TEXT(ID;"00000#")

SharePoint SUSHI

2009-11-29T09:43:00.001+01:00

SharePoint SUSHI is a powerful, user-friendly utility enabling you to accomplish common administrative tasks. You can think of SUSHI as a Swiss army knife for SharePoint.

SUSHI = SharePoint Utility with a Smart, Helpful Interface

http://sushi.codeplex.com/

patterns & practices Acceptance Test Engineering Guidance

2009-11-28T12:27:00.000+01:00

Update: Release Candidate version of Volume I of the Acceptance Test Engineering Guide (Oct 26, 2009) is released

http://www.codeplex.com/TestingGuidance

Maximum Capacity Specifications for SQL Server

2009-11-28T09:20:00.002+01:00

The following tables specify the maximum sizes and numbers of various objects defined in SQL Server components.

http://msdn.microsoft.com/en-us/library/ms143432.aspx

SharePoint Content Database Restrictions... There are none!

2009-11-28T09:20:00.001+01:00

There have been a few questions lately around both numbers of sites per database for Windows SharePoint Services v2 and SharePoint Portal Server 2003 and size of a content database. The plans for WSS v3 and Microsoft Office SharePoint Server 2007 have the same guidance.

http://blogs.msdn.com/sharepoint/archive/2006/08/03/687995.aspx

FIT für Usability

2009-11-21T16:38:00.000+01:00

Usability-Experten helfen Ihnen beim Design. Fragen Sie sich, ob Ihr Design usable ist? Dann sind Sie hier genau richtig!

http://www.fit-fuer-usability.de/

Short Overview of SharePoint Features in Visual Studio 2010

2009-11-14T09:13:00.000+01:00

As you probably know, Visual Studio 2010 was announced last week and it contains a lot of great features and project templates for SharePoint developers. Below is a short overview for some of the SharePoint development related features and project templates.

Configurable deployment
Sandboxed and farm solutions
Extending SharePoint Tools
Feature and Package Designer
SharePoint Explorer
SharePoint Project and Project Item Templates
Project Templates
Project Item Templates
How to download, install and get started

http://blogs.msdn.com/sharepoint/archive/2009/10/28/short-overview-of-sharepoint-features-in-visual-studio-2010.aspx#9921742

SQL Server Unique Constraints for Large Text Columns

2009-10-28T20:27:00.002+01:00

In SQL Server, an unique constraint is enforced using an unique index on the column. But the index key size has a limitation of 900 bytes and this is why we can't enforce the unique constraint on columns over 900 bytes. This limitation not only applies to indexes, but also for foreign keys and primary keys as well. This 900 byte limitation is documented in the Maximum Capacity Specifications for SQL Server.

http://www.mssqltips.com/tip.asp?tip=1868

MonoTouch

2009-10-17T22:00:00.001+02:00

What is MonoTouch?

MonoTouch allows developers to create C# and .NET based applications that run on Apple's iPhone and Apple's iPod Touch devices, while taking advantage of the iPhone APIs and reusing both code and libraries that have been built for .NET, as well as existing skills.

http://monotouch.net/

Windows Azure Platform Training Kit - October Update

2009-10-17T11:20:00.000+02:00

The Azure Services Training Kit includes a comprehensive set of technical content including hands-on labs, presentations, and demos that are designed to help you learn how to use the Windows Azure platform including: Windows Azure, SQL Azure and .NET Services. The October release includes new videos and labs in addition to VB code snippets and updated content for SQL Azure October CTP. This training kit contains the following content:

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=413e88f8-5966-4a83-b309-53b7b77edf78

Microsoft Office 2010 Engineering

2009-10-05T19:18:00.000+02:00

The official blog of the Microsoft Office product development group

http://blogs.technet.com/office2010/default.aspx

Generating SQL Scripts using Windows PowerShell

2009-09-22T20:59:00.001+02:00

In this tip Edwin Sarmiento covers the topic: how to generate scripts using Windows PowerShell

http://www.mssqltips.com/tip.asp?tip=1842

BinScope Binary Analyzer

2009-09-19T19:20:00.001+02:00

BinScope is a Microsoft verification tool that analyzes binaries on a project-wide level to ensure that they have been built in compliance with Microsoft’s Security Development Lifecycle (SDL) requirements and recommendations. BinScope checks that SDL-required compiler/linker flags are being set, strong-named assemblies are in use, up-to-date build tools are in place, and the latest good ATL headers are being used. BinScope also reports on dangerous constructs that are prohibited by SDL.

http://www.microsoft.com/downloads/details.aspx?FamilyID=90E6181C-5905-4799-826A-772EAFD4440A&displaylang=en

Best Practice - Increasing the Number of SQL Server Error Logs

2009-09-11T10:21:00.000+02:00

The SQL Server error log is a great place to find information about what is happening on your database server. Each SQL Server Error log will have all the information related to failures / errors that has occurred since SQL Server was last restarted or since the last time you have recycled the error logs. By default, there are six achieved SQL Server Error Logs along with the ERRORLOG which is currently used. However, it is a Best Practice to increase the number of SQL Server Error Logs from the default value of six. In this tip, you will see the steps which you need to follow to increase the number of SQL Server Error Logs.

http://www.mssqltips.com/tip.asp?tip=1835

Developing Interfaces in Outlook 2007

2009-09-10T20:30:00.002+02:00

Learn how to customize the Microsoft Office Outlook 2007 user interface using Microsoft Visual Studio Tools for Office 3.0.

From a development perspective, Microsoft Office Outlook 2007 is unique compared to Microsoft Office Word 2007 or Microsoft Office Excel 2007. Whereas Word 2007 and Excel 2007 are document-centric applications, Office Outlook 2007 does not have a single standard document type. Instead, Outlook 2007 is designed to work with multiple types of items that allow people to organize the details of their day-to-day routine and communicate with others. As a result, the Outlook 2007 user interface presents distinct challenges for programmers seeking to customize the Outlook 2007 user experience.

http://msdn.microsoft.com/de-ch/library/dd229324(en-us).aspx

Developing SharePoint Applications

2009-09-08T19:19:00.000+02:00

Guidance for building collaborative applications that extend your LOB systems

The Developing SharePoint Applications guidance helps architects and developers design and build applications that are both flexible and scaleable. It shows developers how to provide IT professionals with the information they need to maintain those applications and diagnose problems when they arise. The two reference implementations illustrate how to solve many of the common challenges developers encounter. One reference implementation addresses basic issues such as creating lists and content types. The other addresses more advanced problems such as how to integrate line of business services, how to create collaboration sites programmatically, and how to customize aspects of publishing and navigation. A library of reusable components helps you adopt techniques used in the reference implementations. The guidance discusses approaches for testing SharePoint applications, such as how to create unit tests, and documents experiences with stress and scale testing one of the reference implementations.

http://msdn.microsoft.com/en-us/library/dd203468.aspx

Microsoft SharePoint Administration Toolkit v4.0

2009-09-05T08:18:00.004+02:00

The Microsoft® SharePoint® Administration Toolkit contains functionality to help administrate and manage Microsoft® Office SharePoint® Server 2007 and Windows® SharePoint® Services version 3.0.

The Microsoft SharePoint Administration Toolkit contains functionality to help manage Office SharePoint Server 2007 and Windows SharePoint Services version 3.0. This toolkit contains the ability to diagnose performance issues and perform bulk operations on site collections.

New Features:
SharePoint Diagnostics tool (updated)
Permissions Reporting tool, which includes the UnlockFGPReport Stsadm operation
UpdateQuota Stsadm operation
SharePoint-related Security Configration Wizard manifests

Existing Features:
User Profile Replication Engine
Batch Site Manager
UpdateAlert Stsadm operation

x86: http://www.microsoft.com/downloads/details.aspx?FamilyID=CD2D09A7-1159-4D40-BE1C-8EFAB1345381&displaylang=en

x64: http://www.microsoft.com/downloads/details.aspx?FamilyID=665E98EA-5318-486D-ABA2-2BFE46254357&displaylang=en

TaskmgrPro, Enhances Windows Task Manager

2009-08-28T17:17:00.000+02:00

TaskmgrPro is a plug-in for Windows Task Manager. It enhances the standard Processes tab and creates three additional tabs. You can batch kill or resurrect processes in the standard Processes tab, batch stop or start services in the additional services tab, view all established TCP connections and all open ports in the additional TCP/IP tab and manage shared folders easy in the additional Shares Tab.

http://www.goldgingko.com/taskmgrpro/index.htm

Governance Resource Center for SharePoint Server 2007

2009-08-26T09:17:00.000+02:00

This page contains tools and resources to help business decision makers and IT professionals govern their SharePoint Products and Technologies environment. Governance is the set of roles, responsibilities, and processes that you put in place in an enterprise to guide the development and use of a solution based on SharePoint. By using the governance techniques and best practices available from this page, an enterprise can align its policies for using SharePoint with its culture and goals while still enabling teams and individuals to effectively collaborate and share information.

http://technet.microsoft.com/en-us/office/sharepointserver/bb507202.aspx

Visual Understanding Environment (VUE)

2009-08-23T18:50:00.001+02:00

The Visual Understanding Environment (VUE) is an Open Source project based at Tufts University. The VUE project is focused on creating flexible tools for managing and integrating digital resources in support of teaching, learning and research. VUE provides a flexible visual environment for structuring, presenting, and sharing digital information.

http://vue.tufts.edu/

Microsoft Small Basic

2009-08-22T05:24:00.002+02:00

A simplified programming language and environment to help teach programming to beginners.

Microsoft Small Basic is a project that is aimed at making computer programming accessible to beginners. The project comprises a simple programming language that gathers inspiration from the original BASIC programming language; a modern and attractive programming environment; and rich, extensible libraries. Together they make programming fun for kids and adults alike.

http://www.microsoft.com/downloads/details.aspx?FamilyID=B006D58D-C2C7-44AD-936B-E7E2D7DE793E&displaylang=en

Office 2010: The Movie

2009-07-19T13:41:00.002+02:00

Microsoft Code Analysis Tool .NET (CAT.NET) v1 CTP

2009-07-06T02:06:00.001+02:00

CAT.NET is a snap-in to the Visual Studio IDE that helps you identify security flaws within a managed code (C#, Visual Basic .NET, J#) application you are developing. It does so by scanning the binary and/or assembly of the application, and tracing the data flow among its statements, methods, and assemblies. This includes indirect data types such as property assignments and instance tainting operations. The engine works by reading the target assembly and all reference assemblies used in the application -- module-by-module -- and then analyzing all of the methods contained within each. It finally displays the issues its finds in a list that you can use to jump directly to the places in your application's source code where those issues were found. The following rules are currently support by this version of the tool. - Cross Site Scripting - SQL Injection - Process Command Injection - File Canonicalization - Exception Information - LDAP Injection - XPATH Injection - Redirection to User Controlled Site

32-Bit: http://www.microsoft.com/downloads/details.aspx?FamilyID=0178E2EF-9DA8-445E-9348-C93F24CC9F9D&displaylang=en

64-Bit: http://www.microsoft.com/downloads/details.aspx?familyid=E0052BBA-2D50-4214-B65B-37E5EF44F146&displaylang=en

Apple warns of overheating iPhones

2009-07-05T10:49:00.000+02:00

Amidst rumors of overheating iPhones since shortly after the iPhone 3GS was launched, Apple has finally released the first acknowledgment that there might really be an issue with the iPhone regarding excessive temperatures. Various sites on the internet have posted reports of problems with the iPhone due to excessive heat such as shortened battery life, shut downs and even discoloration of the device itself. Now Apple has officially issued a warning about operating and storing the iPhone 3G and iPhone 3GS in places with too much heat.

http://www.slipperybrick.com/2009/07/apple-warns-of-overheating-iphones/

Bing Maps 3D

2009-06-07T10:14:00.001+02:00

Bing Maps 3D brings you another step closer to knowing "what it is like out there". You can search, browse, and organize local information viewed in three dimensions, just the way it exists in the real world. This enables you to more effectively find the data that is relevant to you, making Bing Maps more useful than ever. Even better -- it's just plain fun!

http://www.microsoft.com/downloads/details.aspx?FamilyID=E9298080-50C4-4F2E-9FC4-4009074996BA&displaylang=en