Selected Tweets of Year 2015!

Another year has passed…as always, full of everything! Events, articles, direct communication with you, my fellow SQL Server community members, via different online and offline channels, software and book releases and many other activities!

Among my blog and journal articles, user group/conference events, tweets and software and book releases, I feel that two of my activities were the most highlighted in 2015. The first highlight was the release of my software tool ‘In-Memory OLTP Simulator‘, and the second was the release of my third book titled ‘Developing with SQL Server‘.

In-Memory OLTP Simulator allows you to easily test SQL Server’s In-Memory OLTP Engine against your own workload, with the use of custom scenarios which you can easily create using the tool. I was working for two years on this and I am really proud about it!

My book ‘Developing SQL Server‘ contains dozens of articles I wrote on different topics that have to do with SQL Server’s development. This book completed my three eBook series ‘The SQL Server and .NET Blog eBook Series’ but hey, don’t worry, there is much more to come! 🙂

All the above, provided me with a great interaction with you, my fellow SQL Server community members, for one more year. Thank you for making the SQL Server community an amazing place to be!

I’m really looking forward for 2016 having already scheduled a variety of amazing community activities!

Wishing to all of you a Happy New Year 2016!

As every year’s end, below you can find my selected tweets for the year 2015.

In-Memory OLTP Simulator

• In-Memory OLTP Simulator Frequently Asked Questions (FAQ) – https://www.sqlnethub.com/software/in-memory-oltp-simulator/ #SQLServer
• Get the Trial Version today for free! – https://www.sqlnethub.com/software/in-memory-oltp-simulator/  #MVPBuzz
• In-Memory OLTP Simulator just got its Facebook page, Likes are welcome! 🙂 https://www.facebook.com/inmemoltpsim  #MVPBuzz #SQLServer
• Now you can easily experiment with In-Memory Optimization in #SQLServer. Check out In-Memory OLTP Simulator!  #MVPBuzz
• [Two-Minute Video] In-Memory OLTP Simulator: Running a Standard Scenario – http://youtu.be/_hsaVUk1Nis  #MVPBuzz #SQLServer
• After two years of heavy development…In-Memory OLTP Simulator is now out! Spread the word! https://www.sqlnethub.com/software/in-memory-oltp-simulator/ #SQLServer #MVPBuzz
• [Blog] In-Memory OLTP Simulator v1.0 Now Live! – http://aartemiou.blogspot.com/2015/07/in-memory-oltp-simulator-v10-now-live.html #SQLServer #MVPBuzz
• [Blog] Introducing In-Memory OLTP Simulator – http://aartemiou.blogspot.com/2015/07/introducing-in-memory-oltp-simulator.html #InMemOLTPSim #MVPBuzz #SQLServer
• In-Memory OLTP Simulator Datasheet – http://bit.ly/1R0Mh8O #InMemOLTPSim #MVPBuzz #SQLServer

Blog Posts/Articles/Books and Announcements

• [Blog] My #Free eBook Series: “The #SQLServer and .NET Blog” – http://aartemiou.blogspot.com.cy/2015/11/my-free-ebook-series-sqlserver-and-net.html  #Books
• [Blog] SQL Server 2016: TempDB Enhancements – http://aartemiou.blogspot.com.cy/2015/12/sql-server-2016-tempdb-enhancements.html #SQLServer2016 #SQLServer #MVPBuzz
• [Blog] SQL Server 2016: Temporal Tables – http://aartemiou.blogspot.com.cy/2015/12/sql-server-2016-temporal-tables.html #MVPBuzz #SQLServer2016 #SQLServer
• [Blog] SQL Server 2016: Built-In JSON Support – http://aartemiou.blogspot.com.cy/2015/12/sql-server-2016-built-in-json-support.html #MVPBuzz #SQLServer #SQL2016
• [Blog] SQL Server 2016 Top Features – http://aartemiou.blogspot.com.cy/2015/12/sql-server-2016-top-features.html  #MVPBuzz #SQLServer #SQLServer2016
• My third book titled ‘Developing SQL Server’ is Now Out! Download your #free copy today! https://www.aartemiou.com/sqlbooks/  #SQLServer #mvpbuzz
• The SELECT permission was denied on the object ‘extended_properties’, database ‘mssqlsystemresource’, schema ‘sys’ – http://aartemiou.blogspot.com.cy/2015/10/the-select-permission-was-denied-on.html
• [Blog] In-Memory OLTP: Comparison of Features/Limitations between #SQLServer 2014 and #SQLServer 2016 – http://aartemiou.blogspot.com.cy/2015/10/in-memory-oltp-comparison-of.html #MVPBuzz
• Read my article “Introducing SQL Server In-Memory OLTP” on the Simple-Talk journal: https://www.simple-talk.com/sql/learn-sql-server/introducing-sql-server-in-memory-oltp/ #SQLServer
• Artemakis Artemiou Retweeted Simple_Talk ‏@Simple_Talk  Oct 5: Artemakis Artemiou looks into whether In-Memory OLTP can help those pinch-points in your data throughput. http://ow.ly/T1ulL
• [Blog] DBStats: A Stored Procedure for Easily Retrieving Basic DB Information – http://aartemiou.blogspot.com.cy/2015/09/dbstats-stored-procedure-for-easily.html #MVPBuzz #SQLServer
• [Two-Minute Video] In-Memory OLTP Simulator: Analyzing Multiple Runs – https://youtu.be/aX_dXS7PmZE  #SQLServer
• [Blog] In-Memory Optimization in SQL Server: Will my Workload Execute Faster? – http://aartemiou.blogspot.com/2015/08/in-memory-optimization-in-sql-server.html #MVPBuzz #SQLServer
• [Two-Minute Video] In-Memory OLTP Simulator: Multiple Runs of the Same Simulation – https://www.youtube.com/watch?v=kozMi7HQPHs #MVPBuzz #SQLServer
• [Blog] Compatibility Levels Supported by Different #SQLServer Versions – http://aartemiou.blogspot.com/2015/05/compatibility-levels-supported-by.html #MVPBuzz
• [Blog] Accessing Reporting Services Using a Fully Qualified Domain Name – http://aartemiou.blogspot.com/2015/05/accessing-reporting-services-using.html #MVPBuzz #SQLServer
• [Blog Post] Transferring Ownership of All Database Objects Back to DBO – http://aartemiou.blogspot.com/2015/05/transferring-ownership-of-all-database.html #MVPBuzz #SQLServer
• [Blog] There is insufficient system memory in resource pool ‘internal’ to run this query. – http://aartemiou.blogspot.com/2015/03/there-is-insufficient-system-memory-in.html #MVPBuzz #SQLServer
• [Blog] Handling NULL Character x00 when Exporting to File Using BCP – http://aartemiou.blogspot.com/2015/03/handling-null-character-x00-when.html #MVPBuzz #SQLServer
• [Blog] Searching for keywords in SQL Server Jobs – http://aartemiou.blogspot.com/2015/02/searching-for-keywords-in-sql-server.html #MVPBuzz

News

• Another successful #CDNUG event took place yesterday! Next stop: The In-Memory OLTP Experiment Technical Whitepaper! #SQLServer #MVPBuzz
• Preparing my session for CDNUG’s event on Nov 24. Title: #SQLServer 2016 Top Features! #sqlfamily #community #mvpbuzz
• A technical whitepaper for In-Memory OLTP Simulator is in the works. Make sure you check often: https://www.sqlnethub.com/software/in-memory-oltp-simulator/ #SQLServer #MVPBuzz
• Stay up to date with all my publications on #SQLServer – Register to the monthly newsletter! – http://goo.gl/forms/jlINJR9vCb #MVPBuzz #Community
• If you are interested in #SQLServer In-Memory Optimization then you should try “In-Memory OLTP Simulator“.  #Hekaton
• Get the Community Edition of In-Memory OLTP Simulator today at: https://www.sqlnethub.com/software/in-memory-oltp-simulator/  #Hekaton #SQLServer #InMemoryOLTP
• Up to 20 Million records where processed via a custom scenario. The results are amazing! More news soon! #Hekaton #SQLServer
• A tech whitepaper on In-Memory OLTP Simulator describing the 1st large-scale In-Memory OLTP Simulation conducted is in the works. #SQLServer
• All scenarios are designed and executed using the Ultimate Edition of In-Memory OLTP Simulator: https://www.sqlnethub.com/software/in-memory-oltp-simulator/  #SQLServer
• Up to now: 1M records:2.25x speedup, 5M records:7.52x speedup, 10M records:10.17x speedup.Now, who can see the trend? 🙂 #SQLServer #MVPBuzz
• Started running the In-Memory OLTP Experiment! It is expected to be completed by tomorrow or Wednesday the latest! #MVPBuzz #SQLServer
• Designing the 100M scenario in In-Memory OLTP Simulator (https://www.sqlnethub.com/software/in-memory-oltp-simulator/) – More info tomorrow! #MVPBuzz
• Generating 100M records to simulate a complex update operation using the In-Memory OLTP Engine in #SQLServer #MVPBuzz
• I have just been re-awarded as a Microsoft SQL Server MVP for the 7th Year in a Row! http://aartemiou.blogspot.com/2015/04/microsoft-sql-server-mvp-for-7th-year.html #MVPBuzz #SQLServer
• Simulating heavy aggregations against 10M+ records using In-Memory OLTP…This is amazing! More news real soon! #MVPBuzz #SQLServer
• Recommended 2-day free online .NET conference – dotnetConf – http://www.dotnetconf.net/
• The more I use @Snagit the more I get pleasantly surprised by its intelligent engine! Keep it up guys! #MVPBuzz

Miscellaneous

• Have just rebuilt the #SQLServer system databases on an instance in order to change their collation! Cool process but be careful! ? #MVPBuzz
• Migration completed! Back to “relaxing” mode 🙂 #MVPBuzz
• Relaxing…before starting the migration of 60 DBs from #SQLServer 2008R2 to SQL Server 2014! ? #MVPBuzz
• There is always a bug around when you write and maintain tens of thousands of lines of code! If you are lucky you will find it 🙂 #Community
• Great article on @lifehackorg – How To Work Faster And Smarter – http://www.lifehack.org/articles/productivity/how-work-faster-and-smarter.html?mid=20150205&ref=mail&uid=363574&feq=daily – That’s a must, especially in large scale projects!
• ISACA CY / itSMF CY Event on Cloud Security & Service Management on Jan 29, 2015. For more info & agenda: http://www.itsmf.org.cy/  #Community