If you’re already familiar with database fundamentals and you’ve worked with SQL Server, the Querying Microsoft SQL Server 2012 Databases Jump Start course will help you take your skills to the next level.
As we started working with early adopters on the SQL Server 2014 In-memory OLTP engine (project codenamed Hekaton) one of the first scenarios we ran into involved a session management database in SQL Server.
Join community experts and Microsoft leaders October 15-18th at 2013 PASS Summit in Charlotte! Quentin Clark, VP of Microsoft’s Data Platform Group, is returning to kick off the event with Wednesday’s keynote talking about innovations behind Microsoft’s database platform and business intelligence solutions – on premise and in the cloud.
Thomas LaRock is a Microsoft Certified Master, a SQL Server MVP, a VMWare vExpert, and a Microsoft Certified Trainer with over 15 years’ experience in the IT industry in various roles such as programmer, developer, analyst, and database administrator.
SQL Server 2014 introduces enhancements to two common database maintenance operations namely Partition Switching and Online Index Rebuild which greatly increases enterprise application availability by reducing maintenance downtime impact.
At Microsoft we believe that data, big and small, goes through a process or lifecycle called the Data Science Process, and is as relevant today as it was hundreds of years ago.
As we emphasized in the previous blogs, with other in-memory technologies in the market today you have to migrate the entire database to memory or it’s a separate database product that deals with in-memory, which means learning new APIs and dealing with application compatibility issues.