By now it’s pretty common knowledge that PowerShell is Microsoft’s preferred management tool and over the past few years, they have really extended the capabilities of PowerShell to where it can be used for just about every management task. There are even some things that can only be done in PowerShell. Even so, PowerShell is […]
Read More
SQL Server 2014’s FileTable provides an easy way to integrate the Windows Server file system with SQL Server’s relational database. In part 1, I covered the basic requirements and limitations of the FileTable feature as well as showing you how to create a FileTable. In this article, you’ll see how you can load data into […]
Read More
Running multiple SQL Server and Oracle database platforms to support different applications is the norm for many IT organizations today. While in many cases the two different database platforms often operate as independent islands there are also times you might need to integrate the two database platforms to perform lookups, queries and other operations that […]
Read More
Like most Microsoft products, sometimes the licensing can be more difficult to figure out than the technical aspects of the product, and SQL Server is no different. Each SQL Server edition has a different licensing model and some have more than one. There are multiple different license types. And if that’s not enough there are […]
Read More
SQL Server Resource Governor concepts have been in existence since the SQL Server 2008 versions. With every version, there have been new additions, and it has steadily gotten better and better. It started with CPU throttling and memory throttling; now, with SQL Server 2014, they introduced IO throttling. There are three important concepts related to Resource Governor: Resource […]
Read More
With every release of SQL Server, the Microsoft product team introduces new features that can improve the performance of the applications using SQL Server as the backend. The buffer pool extension is one such feature introduced in SQL Server 2014. It can help DBAs to increase the size of SQL Server memory area (a.k.a. buffer pool) and extend […]
Read More
There’s no doubt that the most important new feature that Microsoft added to SQL Server 2014 is the new In-Memory OLTP engine. The In-Memory OLTP engine enables you to move select tables and stored procedures into memory for high-performance, low-latency data access. With CPU processing speeds plateauing and memory capacities expanding, Microsoft turned to utilizing RAM […]
Read More
With every release of SQL Server, Microsoft brings unique ways to solve the business problem. SQL Server 2014 is one such release, in which various new features were introduced which makes it truly world class enterprise level RDBMS engine. In this article, we explore a feature introduced in SQL Server 2014 called Managed Lock Priority. If we look […]
Read More
SQL Server 2014 introduced the new database engine enhancement called In-Memory OLTP. This feature uses new data structures which are optimized for in-memory access of table. People normally call it In-Memory database. In reality, we would like to call it partially in-memory database because SQL Server allows us to have few hot tables in-memory and […]
Read More
SQL Server and database experts share insights on features of SQL Server 2014 that promise significant performance potential.
Read More