• SQL Premier Field Engineering

    DevDays 2010, The Hague(NL)

    • 0 Comments
    Last week I did a session on SQL Server for Developers on DevDays. For those of you who are interested I uploaded the powerpoint slidedeck and the demo scripts I used during the session. If you have any questions about them: feel free to ask.
  • SQL Premier Field Engineering

    Index Maintenance across all Databases in an Instance

    • 2 Comments
    I needed to make a job for a customer that rebuilds all indexes in an instance that have a fragmentation of more than 10%. Usually we use a maintenance plan for rebuilding indexes. Although that is a fine approach is has one disadvantage: it rebuilds...
  • SQL Premier Field Engineering

    Reading PerfMon Counters in T-SQL with CLR

    • 6 Comments
    A collegue of mine asked me if it is possible to read out PerfMon counters that are not in the sys . dm_os_performance_counters DMV. I searched everywhere but the only possibility I could think of is by using a CLR user defined function. So I wrote...
  • SQL Premier Field Engineering

    Back again!

    • 1 Comments
    I didn't blog for a long time. For various reasons but the main reason is because I have been quite busy. So what did I do the last half year? A lot of Performance Tuning and Optimization Workshops Plus on SQL 2005. This is in my opinion one of the...
  • SQL Premier Field Engineering

    TechEd IT Proffesionals 2008 EMEA Day 2

    • 1 Comments
    Today I visited 4 presentations: Next generation analysis services, Gemini Windows 2008 Clustering Policy Based Management Migrating to SQL Server.     The best session was on Policy Based Management by Buck Woody. He made PBM look very simple...
  • SQL Premier Field Engineering

    TechEd IT Proffesionals 2008 EMEA Day 1

    • 1 Comments
    For the next two weeks I will be attending Teched in the beautiful city of Barcelona. I attended 2 sessions today. The first one was about the high availability tools of SQL Server 2008. It was presented by Andrew Fryer, a technology evangelist of Microsoft...
  • SQL Premier Field Engineering

    The SQL 2008 Resource Governor

    • 1 Comments
    The client I work for today asked me to come up with a quick overview of the Resource Governor. I'm in luck these days because I have lots of assignments on SQL 2008. Usually PFE's deal with production environments. More often then not this is still SQL...
  • SQL Premier Field Engineering

    Sync Framework

    • 1 Comments
    Today I'm working for a customer who wants to implement the Sync Framework. As you probably know the Sync Framework is still beta but RTM is expected somewhere this fall. The client has a typical problem. They have 7000 field engineers roaming the...
  • SQL Premier Field Engineering

    Table Partitioning Conclusions

    • 2 Comments
    Today I tested all my code and made changes where I made mistakes. And I made quite a few! My biggest mistake was with the GetDate() function. I made partitions with milliseconds which was not my intention! I changed the code in my last post where necessary...
  • SQL Premier Field Engineering

    Table Partitioning Sliding Window Case

    • 5 Comments
    As I mentioned in my last post I'm currently working on a complex partitioning project for a customer. They need partitioning in order to speed up inserts on the table. Lots of inserts take place on this table. Right now they have around 2 million inserts...
  • SQL Premier Field Engineering

    Table Partitioning Basics(2)

    • 2 Comments
    In my last blog I looked at SPLIT and MERGE operations on partition functions. SPLIT and MERGE are nice functions but I use them with care. A merge is not the best performing function there is…. And that is completely logical when you think about everything...
  • SQL Premier Field Engineering

    Table Partitioning Basics

    • 4 Comments
    Partioning objects in SQL Server starts with defining Partition Functions and Partition Schema's. The functions split your data and the schema's place it somewhere. A function can be used by multiple schema's. You start out by creating a function: ...
  • SQL Premier Field Engineering

    Synonyms and other Oracle stuff

    • 0 Comments
    Every now and then I meet Oracle specialists at customers sites. Sometimes they start a good discussion on the differences between the Oracle engine and the SQL Server engine. I don't mind a good discussion on the differences but sadly lots of Oracle...
  • SQL Premier Field Engineering

    Table Partitioning in SQL2008(2)

    • 1 Comments
    Today I proceeded with partitioning a large table in SQL 2008. The objective is to build a partition function with a sliding window. Usually you use staging tables to get to this. This customer wants to keep all his data in one table so staging tables...
  • SQL Premier Field Engineering

    Table Partitioning in SQL 2008

    • 4 Comments
    At the moment I'm working for a client that wants to partition some tables. They need to do that because the tables have grown to immense proportions. One table has 800.000.000 rows. Obviously a lot of inserts are happening on this tables and they hope...
  • SQL Premier Field Engineering

    Introduction

    • 0 Comments
    Hi all, I'm Menzo Steinhost. I'm a SQL Server PFE based in the Netherlands. Before I came to Microsoft I worked for Deloitte Consulting. I did lots of different things there ranging from Oracle development to project audits. At some point I picked...
Page 1 of 1 (16 items)