maol

Tag: MSSQL

  • Using MySQL as NoSQL

    Using MySQL as a NoSQL – A story for exceeding 750,000 qps on a commodity server – how to almost achieve double the Memcached performance using a MySQL UDF that bypasses the SQL layer, talks directly to the InnoDB layer. Wonder if the SQL overhead is similar in Oracle or MS SQL Server, and how…

    By

    Markus Perdrizat

    ·

  • Microsoft SQL Server Migration Assistant

    Just a quick pointer to the Microsoft SQL Server Migration Assistant (SSMA) Team’s Blog. May come in handy when looking at moving over to SQL Server. Check How To Migrate Oracle’s Sample HR Schema to SQL Server for a run-through with screenshots based on Oracle’s sample schema.

    By

    Markus Perdrizat

    ·

  • SQL Server Redundancy

    Andrew Fryer wrote a reference post about SQL Server Redundancy earlier this month about the pros and cons of clustering and mirroring, so it’s about time I mention it here! His motivation was an internal request at Microsoft: If there are internal Microsoft staff who don’t know when to use what, then I imagine there…

    By

    Markus Perdrizat

    ·

  • NoSQL Ecosystem

    Jonathan Ellis from the Cassandra project published a fantastic overview of the current NoSQL ecosystem in late 2009. He analyzed 10 popular NoSQL databases along three axes: horizontal scalability, data model and internal persistence design. It’s a great read, and still pretty much valid as of today. I stumbled upon it via Emil Eifrem from…

    By

    Markus Perdrizat

    ·

  • Windows Azure Platform Appliance

    Microsoft formally announced its Windows Azure Platform Appliance today, as TechCrunchIT reports. Dell, eBay, Fujitsu, and HP intend to deploy the appliance in their datacenters to offer new cloud services. While that’s nice to know, I’m much more interested to hear by when we can get our own appliance, and what the configuration sizes and…

    By

    Markus Perdrizat

    ·

  • SQL Server 2008 R2 Best Practices Analyzer

    Check out the SQL Server 2008 R2 Best Practices Analyzer if you’re using SQL Server 2008. Looks to be a handy tool that just came out over the weekend. Gathers information about a Server and a Microsoft SQL Server 2008  or 2008 R2 instance installed on that Server Determines if the configurations are set according…

    By

    Markus Perdrizat

    ·

By

Markus Perdrizat

·

—