Black Marble
open-menucloseme
Home
Sub-Sites
Main Black Marble Website
  • Calculation Settings in Excel

    author Iain Angus calendar Feb 27, 2008 · 2 min read · Tech Tips  ·
    Share on: twitter facebook linkedin copy

    Sometimes Excel doesn't behave as you expect and you learn something. Excel is complex as Joel Spolsky pointed out last week.

    Quite often clients will send data updates in Excel spreadsheets as this is the format they are used to working with; even if you as a programmer are not. One such workbook I have worked with …


    Read More
  • Diagnosing referential integrity using TSQL

    author Iain Angus calendar Feb 26, 2008 · 1 min read · SQL  ·
    Share on: twitter facebook linkedin copy

    Quite often you work on databases that you didn't write. Getting up to speed on the structure of the tables and the relationships between them is not something you relish. The GUIs provided by SQL Server 2000 or 2005 don't always provide the best way, particularly with regard to complex referential integrity.

    I've …


    Read More
  • Accessing User Profile Information in WSS 3.0

    author Iain Angus calendar Jan 30, 2008 · 1 min read · SharePoint  ·
    Share on: twitter facebook linkedin copy

    MOSS and WSS 3.0 handle user profiles differently. In MOSS, user profile information is stored centrally and can be shared across site collections. Profiles can be manipulated using the UserProfileManager class found in Microsoft.Office.Server.dll.

    Life just isn't the same when working with WSS 3.0. When developing a …


    Read More
  • Microsoft Boy announces his school homework

    author Iain Angus calendar Jan 28, 2008 · 1 min read · General Interest  ·
    Share on: twitter facebook linkedin copy
    Very funny.
    Read More
  • Granting permissions on the GAC

    author Iain Angus calendar Jan 28, 2008 · 2 min read · Tech Tips  ·
    Share on: twitter facebook linkedin copy

    Normally you don't encounter permission errors when installing to the global assembly cache (GAC). Today I did, even though I was logged on as a member of the administrators group (not that being an administrator is a guarantee of much).

    If you navigate using Windows Explorer to %windir%\assembly, what you see is the …


    Read More
  • SharePoint User Group - Newcastle

    author Iain Angus calendar Jan 25, 2008 · 1 min read · SharePoint  ·
    Share on: twitter facebook linkedin copy

    Big thank you to Penny Coventry and Steve Smith for presenting at the SharePoint User Group UK Newcastle meeting on Wednesday night. Both were excellent sessions.

    Penny gave an overview of SharePoint Designer, which if not already, will probably become your default tool for design and basic development of SharePoint …


    Read More
  • SharePoint 2007 "Friendly" Error Messages

    author Iain Angus calendar Dec 20, 2007 · 1 min read · SharePoint  ·
    Share on: twitter facebook linkedin copy

    SharePoint 2007 displays a nice "friendly" error message when anything goes wrong. This "friendly" error message usually provides no useful information about why the error has occurred (sometimes you get an HRESULT). It may be friendly but isn't usually very helpful, not for a developer.

    You can …


    Read More
  • Gary Short Presentation

    author Iain Angus calendar Dec 18, 2007 · 1 min read · Events  ·
    Share on: twitter facebook linkedin copy

    Gary Short is speaking at Glasgow Caledonian University, 7pm, 16th January 2008. I saw him speak at DDD 6 and he was excellent. Well worth a trip to see.

    Link to presentation details


    Read More
  • SQL Server Status

    author Iain Angus calendar Dec 7, 2007 · 1 min read · SQL  ·
    Share on: twitter facebook linkedin copy
    In SQL Server 2000 you could query the sysdatabases table to find out the "status" of a database. This field was actually a bit mask and the sysdatabases table is only available in SQL Server 2005 for backwards compatability. The sysdatabases table "maps" to the sys.databases system view. The old …
    Read More
  • sp_validatelogins

    author Iain Angus calendar Nov 30, 2007 · 1 min read · SQL  ·
    Share on: twitter facebook linkedin copy

    Want to know which deleted windows user accounts still have entries in the SQL Server system tables?

     EXEC sp_validatelogins

    MSDN article on sp_validatelogins.


    Read More
    • ««
    • «
    • 1
    • 2
    • 3
    • 4
    • »
    • »»

From the outside in

The blog of Iain Angus

RSS RSS

Recent Posts

    Tags

    UNCATEGORISED 2090 TECH TIPS 96 VSTS 64 SHAREPOINT 50 WINDOWS AZURE 44 DEVOPS 40 POWERSHELL 22 AZURE 20 VISUAL STUDIO 20 DEPLOYMENT 15 EVENTS 15 SQL 15 ACS 11 GITHUB 11
    All Tags
    .NET FOR METRO STYLE APPS6 .NET FRAMEWORK5 ACCESS SERVICES2 ACS11 ACTIVE DIRECTORY7 ADFS4 ADSIEDIT1 AGILE3 AI2 AJAX1 ALM1 ANDROID1 APPFABRIC6 APPLICATION-INSIGHTS2 ASP.NET9 AZURE20 AZURE AD3 AZURE RESOURCE MANAGER3 AZURE STACK1 AZURE WEBSITES4 BACKUP2 BEST PRACTICE4 BIZTALK7 BIZTALK PIPELINE DISASSEMBLE1 BLETCHLEY PARK1 BLOGGING1 BOOK1 BOOKS2 BOTFRAMEWORK1 BOTS2 BPA1 BUSINESS PROCESS AUTOMATION1 CERTIFICATES2 CFP1 CHATBOTS1 CHRISTMAS1 CLOUD1 CLOUD OPERATING MODEL1 CLUSTER3 CODE BREAKING1 CODE QUALITY1 COLLABORATION1 COM1 CONFERENCE6 CONFIGURATION MANAGER6 CONTENT QUERY WEB PART1 CONTENT TYPE HUB1 CONTENT TYPES4 CRITICAL THINKING2 CRM4 CSOM1 DATA PROTECTION MANAGER5 DATA SCIENCE4 DDD10 DEBUGGING1 DEPLOYMENT15 DESIRED STATE CONFIGURATION2 DEVOPS40 DEVTEST LABS3 DIGITAL SIGNATURES1 DISCOVERY1 DPM5 DSC3 ENERGY SAVING1 ENIGMA1 EVENTS15 EXCHANGE2 FACEBOOK MESSENGER1 FEATURES1 FIREWALL1 FLOW1 GADGETEER4 GENERAL INTEREST1 GIT2 GITHUB11 GRAPHIC DESIGN3 GROUP POLICY3 HADOOP1 HARDWARE8 HIGH AVAILABILITY2 HORTONWORKS1 HYPER-V6 HYPER-V R26 HYPER-V SERVER1 IIS3 IMAGINE CUP1 INFOPATH5 INTEGRATION2 KERBEROS2 LINQ1 LIVE LABS1 LIVE MESSENGER1 LOGGING3 LOGIC APPS3 LOGICAPPS1 MALWARE1 MANAGED METADATA SERVICE1 MANAGEMENT4 METRO6 MICROSOFT AZURE4 MICROSOFT EVENTS3 MICROSOFT TEAMS2 MIGRATION5 MOSS3 MVP3 MYSITE1 MYSITE NEWSFEED1 NETWORK LOAD BALANCING2 NGROK1 NODE1 NODEJS1 OPEN XML1 OPINION10 OPTION1 OSLO1 PASSWORD RESET1 PERFORMANCEPOINT2 PERMISSIONS7 PESTER1 POLICING1 POWER AUTOMATE1 POWERSHELL22 PRISM6 PROBABILITY1 REGISTRY4 RELEASE MANAGEMENT9 REMOTE MANAGEMENT7 REPORTING1 REPORTING SERVICES2 SCCM1 SCOM 20071 SCRUM1 SCVMM1 SCVMM 20083 SEARCH1 SECURITY4 SERVICE APPLICATIONS2 SERVICE BUS11 SHAREPOINT50 SIGNALR3 SILVERLIGHT1 SOFTWARE DELIVERY1 SONARQUBE6 SPC 20094 SPN2 SQL15 SQL AZURE6 SQL SERVER7 STATISTICS1 SURFACE PRO 31 SYSTEM CENTER7 SYSTEM CENTER OPERATIONS MANAGER2 TEAM FOUNDATION SERVER3 TEAMS2 TECH ED EMEA 2008 IT2 TECH TIPS96 TECHTIPS9 TESTING3 TFS5 THREAT MANAGEMENT GATEWAY1 TLS1 TMG2 TNMOC1 TYPEMOCK1 UI3 UK IT CAMPS1 UNCATEGORISED2090 UPGRADE9 USER PROFILE SERVICE APPLICATION1 VBUG1 VIRTUAL MACHINES8 VISUAL STUDIO20 VSO1 VSTO2 VSTS64 WCF DATA SERVICE1 WCF DATA SERVICES1 WEB API4 WEB APPLICATION PROXY3 WEB PARTS2 WEB PLATFORM INSTALLER1 WHITE PAPER3 WHITE PAPERS1 WINDOWS 108 WINDOWS 10 15111 WINDOWS 10 19031 WINDOWS 72 WINDOWS 86 WINDOWS 8.12 WINDOWS ADMIN CENTER1 WINDOWS AZURE44 WINDOWS AZURE APPFABRIC8 WINDOWS AZURE WEBSITES4 WINDOWS HOME SERVER4 WINDOWS PHONE1 WINDOWS PHONE 71 WINDOWS SERVER2 WINDOWS SERVER 20037 WINDOWS SERVER 20087 WINDOWS SERVER 2008 CORE1 WINDOWS SERVER 2008 R29 WINDOWS SERVER 2008 R2 CORE1 WINDOWS SERVER 20125 WINDOWS SERVER 2012 R25 WINDOWS SERVER CORE1 WINDOWS TIME SERVICE1 WINOWS SERVER 20161 WINRT7 WORKFLOW MANAGER1 WORLD WAR 21 WSUS4 X646 ZOMBIES1
    [A~Z][0~9]
    Black Marble

    Copyright  BLACK MARBLE. All Rights Reserved

    to-top