SQL Server

Facebook Twitter

SQL Server 2005 support ends April 2016. Are you ready? - SQL Server Team Blog. Don’t get caught off-guard.

SQL Server 2005 support ends April 2016. Are you ready? - SQL Server Team Blog

Upgrading to Microsoft SQL Server 2014 helps you maintain security and compliance, gain faster data insights, and optimize your data infrastructure—all using familiar tools you already know and trust. Be prepared when extended support for SQL Server 2005 ends. Protect your data with a thoughtful upgrade plan and mitigate cost and risk. Read this complimentary report today to learn more about the robust backward compatibility features and tools that enable a range of migration options. SQLServerMag sur Twitter : "A quick look at #SQLServer hybrid cloud options. Photo Gallery: SQL Server Hybrid Cloud Options. Without a doubt, SQL Server DBAs and database professionals are among the most reluctant customers to adopt cloud anything, and there are some good reasons for that.

Photo Gallery: SQL Server Hybrid Cloud Options

SQL Server is a business critical infrastructure component that most organizations simply won’t trust to the cloud. Those organizations have a significant investment in on-premises hardware and software, plus moving to the cloud involves a number of risks. Why SQL Server runs best on Microsoft Azure - SQL Server Team Blog. Microsoft Azure Infrastructure Services offers many ways to optimize your on-premises data and data platform projects from development and test of new SQL Server applications to migrating existing on-premises SQL Server instances on the latest images of SQL Server to cost effective hybrid scenarios such as database backup and extended business continuity.

Why SQL Server runs best on Microsoft Azure - SQL Server Team Blog

So why is Microsoft Azure Infrastructure Services the ideal place to implement such scenarios? The latest Images of SQL Server always available Let’s start with having the latest images of SQL Server as soon as they are made generally available including tuned images for select workloads like an optimized data warehousing image. An example is Microsoft Azure offered SQL Server 2014 CU1 update at the end of April, the day it was made generally available. This image is still pending to be uploaded on many other service providers. Additional VM Sizes to choose from and more continually being added Try Microsoft Azure. SQL Server 2008 MCM Readiness Videos.

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. 35+ Use Cases for Choosing Your Next NoSQL Database.

We've asked What The Heck Are You Actually Using NoSQL For?.

35+ Use Cases for Choosing Your Next NoSQL Database

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. What are your options? First, let's cover what are the various data models. Document Databases Lineage: Inspired by Lotus Notes.Data model: Collections of documents, which contain key-value collections.Example: CouchDB, MongoDB Good at: Natural data modeling.

NoSQL Databases and Polyglot Persistence: A Curated Guide. NOSQL Patterns. Over the last couple years, we see an emerging data storage mechanism for storing large scale of data.

NOSQL Patterns

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.

I am not intending to compare the features of these solutions, nor to suggest which one to use. API model The basic form of API access is. When SSDs Make Sense in Server Applications. In past posts, I’ve talked a lot about Solid State Drives.

When SSDs Make Sense in Server Applications

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.

You need to add memory to increase the memory hit rate and reduce the number I/Os or you need to add disks to support the application-required I/O rates. We know that disk sequential bandwidth growth lags the rest of the system. Data.gov. WP_Quest_AutomatingDBAProcessesSQLServer_FixLink_V1_.pdf (application/pdf Object)

SQL Bloggers

TPC - Homepage. Computing. SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization. The SQL Server Conference - SQLBits - Query across the Mersey - 29 Sep 2011 - 1 Oct 2011 - Liverpool. Global Overview.