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…
In this article, we will be discussing about, how to import and export unstructured data in SQL Server, using the IMAGE datatype. Introduction Importing and exporting unstructured data from a database is a common practice, especially in large applications. SQL Server 2008 introduced the FILESTREAM feature that allows storing unstructured data (i.e. music, video, documents, … Read more…
Another year has come to an end. Being faithful to the “tradition” of posting the last day of every year my selected tweets for the year that ends, here I am again, posting the “Selected Tweets of Year 2013!”. 2013 was remarkable, especially when it comes to Community. Interacting with you, the SQL Server Community … Read more…
A few days ago I published my second eBook. The title of the book is “Administering SQL Server” and it is for database administrators and architects who monitor and administer SQL Server instances on a regular basis and have as a primary goal to maintain the health of the instances and thus the hosted databases. … Read more…
SQL Server programmability objects such as stored procedures, functions, assemblies, etc. are widely used, especially in cases of a major database design where you want to have a well-structured database with code reuse and performance. The need to know where are Programmability Objects Stored in SQL Server Even though many of us use these … Read more…
My first eBook on SQL Server has been released. The title of the book is “Tuning SQL Server” and it is part of “The SQL Server and .NET Blog eBook Series!“. How is the eBook Organized? This book is organized as follows. Chapter 1 discusses the usage of indexes and the derived benefits of … Read more…
I love technology. I love exploring. I love writing about it and share knowledge. I started working with SQL Server and .NET (C#) more than ten years ago. Since then it has been quite a journey! Each release came – and still comes – with exciting new features enabling us to do more and more! … Read more…
SQL Server, has a specific dynamic management view (DMV) which provides detailed information regarding the active locks within the SQL Server instance that is, locks that have been already granted or they are waiting to be granted. The DMV is called: sys.dm_tran_locks. Using the sys.dm_tran_locks DMV for Monitoring Locking in SQL Server The following … Read more…