SQL Server Team Blog

In the past, deploying a data warehouse has been a costly affair. IT departments required expertise to procure and build state-of-the-art hardware servers (that are optimally balanced from a CPU, storage and I/O perspective) as well as install software...

Microsoft SQL Server 2014 CTP2 was announced by Quentin Clark during the Microsoft SQL PASS 2013 keynote. This second public CTP is essentially feature complete and enables you to try and test all of the capabilities of the full SQL Server 2014 release...

This morning, during my keynote at the Professional Association of SQL Server (PASS) Summit 2013, I discussed how customers are pushing the boundaries of what’s possible for businesses today using the advanced technologies in our data platform....

This summer we started blogging about all of the innovation in the products that make up the Microsoft Cloud OS vision. We’ve talked about Windows Server 2012 R2 , Windows Azure and of course Microsoft SQL Server 2014 . In the case of SQL Server...

PASS Summit is just right around the corner and we are very excited to share all of our hard work with you! Microsoft is sending over 140 people to Charlotte, NC to share our excitement about SQL Server & BI and spend time with our enthusiastic community...

In-memory OLTP provides full durability for memory-optimized tables. When a transaction that has made changes to memory-optimized table commits, SQL Server, just like it does for disk-based tables, guarantees that the changes are permanent and can survive...

SQL Server professionals, join us October 16 and 18 for two fast-paced, demo filled days of free training, live and online! If you aren’t able to attend PASS, you can take advantage of these 2 full days of expert led instruction. Administering...

On October 28-30, Microsoft will join 2,700 of the world’s leading big data scientists, CIOs and executives at the Strata+Hadoop conference in New York City. For some, Microsoft does not come immediately to mind when thinking about leadership in...

In-Memory OLTP introduces a new type of index for memory-optimized tables in SQL Server 2014: the hash index. This new index type is optimized for index seek operations, i.e. finding the rows corresponding to a given set of equality predicates; for example...

We believe that the In-Memory OLTP engine advances the industry state of the art with respect to concurrency control. The main reason for this advancement is due to the combination of lock free algorithms and the row-versioned architecture of the engine...

The new In-Memory OLTP feature introduces memory-optimized tables and natively compiled stored procedures in SQL Server 2014, to optimize performance and scalability of OLTP workloads. To benefit from this technology in an existing SQL Server application...

Here we are -- another week closer to the SQL Server event of the year, PASS Summit, and the buzz continues to grow! Last week, we had the opportunity to share the excitement of the Summit with you in our Tweet for the Summit Challenge , in which we asked...

Today we’re pleased to announce the addition of significant new features to the Power BI for Office 365 preview, including natural language search with Q&A and improved experiences in two preview add-ins for Excel with 3D mapping visualizations...

We’re just a few short weeks away from PASS Summit 2013, and the excitement is building! We’re getting our bags packed and ready to go, and we hope that you are too. However, if you haven’t made your plans just yet, listen up because we’re hosting a Tweet...

This week, we had the opportunity to have a quick chat with Adam Jorgensen, Director of PASS Programs, about the upcoming event in Charlotte, North Carolina.  Adam first joined the PASS Board in 2012, and he is a SQL Server MVP as well as the President...

As the SQL Server 2014 In-memory OLTP team began working with customers we recognized some common design patterns where the In-memory OLTP engine was a great fit. The intent of this blog is to call out one of those architectures which we call: High data...

Organizations today are collecting more types and sizes of data than ever before, and are seeking ways to gain actionable insights from that data. Harnessing big data can be especially helpful to financial institutions. To stay ahead of the competition...

As we have addressed in previous blog articles, the transition into SQL Server In-Memory OLTP is not as simple as flipping a switch. One of the design principles of In-Memory OLTP is that you would only need to make surgically precise migrations for your...

As you know, the SQL Server event of the year, PASS Summit , is coming to Charlotte, North Carolina this October.  The event promises a range of top notch training and networking opportunities that are designed to take your SQL Server skills to the...

PASS Summit 2013 is quickly approaching.  The conference will take place October 15 – 18 th in Charlotte, NC – that’s just five weeks until the world's largest and most intensive technical training conference for Microsoft SQL Server and BI professionals...

PASS Summit 2013 in Charlotte, NC is right around the corner, and we’re getting geared up for this great event!  Tune in to this week’s TechNet Radio special below to listen to Jennifer Moser, Lara Rubbelke, Chuck Heinzelman and SQL RockStar , Thomas...

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. You’ll learn about data manipulation and how...

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. The application was a high volume website storing...

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...

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...