In-Memory OLTP in SQL Server 2014 or later is a powerful engine integrated into the SQL Server Engine, optimized for Online Transaction Processing (OLTP). In-Memory Optimization in SQL Server, has certain characteristics and can help increasing performance in a great number of scenarios. A Short Description of the SQL Server In-Memory OLTP Technology If I … Read more…
After two years of heavy development, my tool “In-Memory OLTP Simulator” is finally out! In-Memory OLTP Simulator enables the IT Professional and Developer to easily test the powerful In-Memory OLTP Engine of SQL Server 2014® (or later) with different simulations and against different workloads. In the Ultimate Edition of the tool, among other, the user … Read more…
One of the key features originally shipped with SQL Server 2014 was the long-awaited In-Memory OLTP, codenamed as project “Hekaton”. In-Memory OLTP introduced new data structures for optimizing the performance of OLTP workloads. These data structures are called “memory-optimized” tables and along with natively compiled stored procedures, they can offer a huge performance boost when … Read more…
Software is evolving and certainly SQL Server is not an exception to the rule. Every few years we need to upgrade our databases in order to run on a newer version of SQL Server and take advantage of significant new features that will enhance the operations of our organization. However, upgrading a database to a … Read more…
If you installed SQL Server Reporting Services (SSRS) on a server in a domain and you use a domain user to start the service and did not perform any further configuration, then you most probably can only access the Report Manager using an IP and not the Fully Qualified Domain Name (FQDN) of the server … Read more…
In this article, we will be discussing about transferring ownership of all Database objects back to DBO in SQL Server. Let’s See an Example Consider the following scenario: You created a Window or SQL login in SQL Server and in the user mapping along with assigning a database role membership, you assigned as default … Read more…
Today, a while ago, I have received that special email from Microsoft informing me that I was awarded with the Microsoft Most Valuable Professional (MVP) Award: Dear Artemakis Artemiou, Congratulations! We are pleased to present you with the 2015 Microsoft® MVP Award! This award is given to exceptional technical community leaders who actively share their … Read more…
This article discusses how you can resolve the error message: There is insufficient system memory in resource pool ‘internal’ to run this query. Even though you might get the above error message for different occasions, one thing is for sure (after all, the message is quite self-explanatory), it has to do with memory management. 🙂 … Read more…
This article discusses the behavior of the BCP utility when extracting data from SQL Server tables to files and more specifically to CSV files. Example: Description Imagine that you have the below table: As you can see, records 2 and 3 contain null values. Then you export the table contents to CSV using BPC: bcp … Read more…
Hi friends all around the globe, it’s been a while since my last article but this is a very busy period with many other community activities of which you will soon enjoy the outcome! These activities have to do with heavy software development as well as the authoring of my third eBook with title “Developing … Read more…
So here I am, writing the last post for 2014! Don’t worry new posts for 2015 are coming up soon! 🙂 With only few hours left to welcome the new year, my thoughts go back deep into 2014 trying recollect the highlights of this year through my personal aspect. Beyond the personal highlights I would … Read more…
A few weeks ago I was contacted by Webucator, an online training provider that requested my permission to include one of my articles into a free video-training series called “SQL Server Solutions from the Web“. This is one of my articles on FileTables with title: “How to Import and Export Unstructured Data in SQL Server … Read more…
On the weekend of Nov 29-30, Windows CY Hackathon took place in Cyprus. The contestants had almost two days to develop a universal application for Windows Store and Windows Phone. They were given an open data API that they had to use. Beyond that, everything was up to their imagination which as their presentations proved, … Read more…
In this article, we will be discussing about, how you can easily list all tables of a linked SQL Server database. Introduction There are many scenarios in the DBMSs world where you might need to use a linked server between two different SQL Server instances in order to execute direct queries between them. However, the majority … Read more…
In this article, we will be discussing about In-Memory Optimization in SQL Server, and we will see a simple example, of optimizing a workload using In-Memory Optimization and thus improve performance. Introduction to SQL Server In-Memory Optimization In one of my previous articles I briefly introduced In-Memory Optimization in SQL Server. In this article … Read more…