Tag: MSSQL
-
Thought Leaders in the Cloud: Cassandra’s Jonathan Ellis
The Windows Azure blog has a long and good interview with Jonathan Ellis about Cassandra and a lot of other relevant topics. Take a break to read Thought Leaders in the Cloud: Talking with Jonathan Ellis, Co-Founder of Riptano. When asked about Cassandra vs.… Continued
-
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 you’d work around that there.… Continued
-
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.
-
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 must still be confusion in the real world about these two approaches.… Continued
-
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.… Continued
-
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 support requirements are going to be.… Continued
-
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 to the recommended best practices
- Reports on all configurations, indicating settings that differ from recommendations
- Indicates potential problems in the installed instance of SQL Server
- Recommends solutions to potential problems
The following article also has more info on SQL BPA: Introducing the SQL Server 2008 R2 Best Practices Analyzer (BPA)…