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…
Everything in our world is governed by technology. From large corporations to small stores and simple individuals, everyone uses a computational system for performing the most complex or even the simplest task. Even though the level of technology’s involvement in our lives can be characterized by many as a controversial topic, it is a fact … Read more…
In-Memory OLTP (codenamed “Hekaton”) is the most significant feature originally shipped with SQL Server 2014. It is Microsoft’s new technology which is fully integrated into SQL Server’s Database Engine. In-Memory OLTP introduces new data structures for optimizing the performance of OLTP workloads. These data structures are called “memory-optimized” tables and along with natively compiled stored … Read more…
In this article, we will be discussing about the process of modelling database creation, using the Model system database in SQL Server. The Model database in SQL Server is used as the template for all the user databases that are created on a SQL Server instance. Most of the times, we do not modify the … Read more…
Good evening (or good morning) friends all around the globe! Wherever you are, whatever you do, wishing you a nice rest of the day (or night!) 🙂 This is the last of a series of posts that deal with the task of importing and exporting unstructured data in SQL Server. The first article of this … Read more…
It’s that time of the year again. April 1st, where you just wait to see if you have received the magic email from Microsoft saying that you are awarded as a Most Valuable Professional. During this waiting process you just keep on asking yourself: “Was I active enough and contributed as much as possible to … Read more…
A few days ago, on March 21st, I participated as an invited speaker at Microsoft Conference 2014 that took place in Nicosia, Cyprus. My session was on SQL Server 2014 and specifically about what’s new in this release of SQL Server. My session’s agenda was on the following areas of new features on SQL Server: … Read more…
A few weeks ago I posted an article on how to import and export unstructured data in SQL Server by using the “image” data type. In this article I will show how you can manipulate unstructured data in SQL Server 2008 or later by using the FILESTREAM feature. FILESTREAM allows storing unstructured data (i.e. music, … Read more…
Update: Artemiou Data Tools is now SQLNetHub! A few months ago I started a new project that has to do with software development. The concept behind this project is to develop simple yet useful software tools that have to do with data processing. All my tools will be distributed under the collection name “Artemiou Data … Read more…