Database developers often face the task to synchronize users’ data. Currently, to solve this task, there was developed quite a big number of various utilities. In this article, we will review the process of creating the new functionality to synchronize data exclusively with T-SQL.
SQL SERVER – Faster Application Performance with In-Memory OLTP
Today, I’d like to examine how in-memory OLTP engines to vastly improve performance and scalability of SQL Server databases and to accelerate applications. A very large part of this article focuses specifically on SQL Server 2014 and its new In-Memory OLTP capabilities.
SQLAuthority News – Two Microsoft Whitepaper on In-Memory OLTP
Earlier this week, I was presenting at Great Indian Developer Summit in Bangalore. Lots of people were interested in the subject of In-Memory OLTP database. Everybody wanted to know how to do, use the new features of In-Memory OLTP feature. Microsoft has recently released two white paper which discusses about…
Read MoreSQLAuthority News – Microsoft Whitepaper – Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator
I have been reading this Whitepaper from a couple of days and I am yet not done reading it completely, but I think it is one of the best white papers I have read in the recent time. First of all, it is written by my friend and SQL Expert…
Read MoreSQL SERVER – GIDS – Two Technical Sessions Today – Resources and Whereabouts – Part 2
Today I will be presenting two sessions at Great Indian Developer Summit. Here is the details about where I will be during today. If you are not going to attend this event, sign up for the newsletter over here: https://darkslategrey-bat-805937.hostingersite.com/contact-me/sign-up/. I will be sharing my code, demo, slides and all…
Read MoreSQL SERVER – Database File Names and Extentions – Notes from the Field #025
[Notes from Pinal]: People believe Shakespeare’s birth date is on April 26. ” What is there in a name?” – I often hear this statement, which famously quotes from Shakespeare. I think we developer believe in this statement as most of our various are either BAR or FOO. However, this…
Read MoreSQL SERVER – GIDS – Two Technical Sessions Today – Resources and Whereabouts
Today I will be presenting two sessions at Great Indian Developer Summit. Here is the details about where I will be during today. If you are not going to attend this event, sign up for the newsletter over here: https://darkslategrey-bat-805937.hostingersite.com/contact-me/sign-up/. I will be sharing my code, demo, slides and all…
Read More