The Microsoft Certified Masters Program for Microsoft SQL Server provides the most experienced and talented IT Professionals with worldwide validation and recognition of their deep technical expertise in SQL Server. The SQL Server 2008 Microsoft Certified Master program has been re-launched in a more scalable format because of the increased interest and global demand for the program. For more information, see the Microsoft Learning SQL Server 2008 Microsoft Certified Master program site. SQL Server 2008 MCM Readiness Videos
We've asked What The Heck Are You Actually Using NoSQL For?. We've asked 101 Questions To Ask When Considering A NoSQL Database. We've even had a webinar What Should I Do? Choosing SQL, NoSQL or Both for Scalable Web Applications. Now we get to the point of considering use cases and which systems might be appropriate for those use cases.
A paper authored by a Microsoft Research team: In the last decade we have seen a huge deployment of cheap clusters to run data analytics workloads. The conventional wisdom in industry and academia is that scaling out using a cluster of commodity machines is better for these workloads than scaling up by adding more resources to a single server. Popular analytics infrastructures such as Hadoop are aimed at such a cluster scale-out environment.
Over the last couple years, we see an emerging data storage mechanism for storing large scale of data. These storage solution differs quite significantly with the RDBMS model and is also known as the NOSQL. Some of the key players include ...GoogleBigTable, HBase, HypertableAmazonDynamo, Voldemort, Cassendra, RiakRedisCouchDB, MongoDB These solutions has a number of characteristics in commonKey value storeRun on large number of commodity machinesData are partitioned and replicated among these machinesRelax the data consistency requirement. (because the CAP theorem proves that you cannot get Consistency, Availability and Partitioning at the the same time)The aim of this blog is to extract the underlying technologies that these solutions have in common, and get a deeper understanding on the implication to your application's design. NOSQL Patterns
When SSDs Make Sense in Server Applications In past posts, I’ve talked a lot about Solid State Drives. I’ve mostly discussed about why they are going to be relevant on the server side and the shortest form of the argument is based on extremely hot online transaction processing systems (OLTP). There are potential applications as reliable boot disks in blade servers and other small data applications but I’m focused on high-scale OLTP in this discussion. OLTP applications random I/O bound workloads such as ecommerce systems, airline reservation systems, and any data intensive application that does lots of small reads and writes, usually on a database where future access patterns are unknown. When sizing a server for one of these workloads, the key dimension is the number of small random I/Os per second.
WP_Quest_AutomatingDBAProcessesSQLServer_FixLink_V1_.pdf (application/pdf Object)
TPC - Homepage
SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization The SQL Server Maintenance Solution comprises scripts for running backups, integrity checks, and index and statistics maintenance on all editions of Microsoft SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Server 2014. The solution is based on stored procedures, the sqlcmd utility, and SQL Server Agent jobs. I designed the solution for the most mission-critical environments, and it is used in many organizations around the world. Numerous SQL Server community experts recommend the SQL Server Maintenance Solution, which has been a Gold winner in the 2013, 2012, 2011, and 2010 SQL Server Magazine Awards. The SQL Server Maintenance Solution is free. “Personally, I’d recommend that you stop using Database Maintenance Plans entirely, and switch to a much more robust maintenance implementation using TSQL scripts.
Only Thursday precons available now! We are working in earnest for SQLBits XI that will be taking place between the 2nd and 4th of May 2013 at the East Midland Conference Centre. Friday and Saturday is full, but we do have the following sessions available on Thursday Only: For those who have managed to register, not only do we have the best SQL Server professionals in the world taking you on a three day tour of the best data platform product on the market. The SQL Server Conference - SQLBits - Query across the Mersey - 29 Sep 2011 - 1 Oct 2011 - Liverpool