SQLArtBits News

  • Latest News
  • News Archive
  • [March 7, 2017 - New Article: Should Windows "Built-In\Administrators" Group be SQL Server SysAdmins?]
    This article discusses whether Windows "Built-In\Administrators" Group should be SQL Server SysAdmins or not. [read article]

    [December 22, 2016 - Weekly SQL Server Tips Collection for August 2016 - December 2016]
    Weekly SQL Server Tips Collection August 2016 - December 2016. This collection contains all SQL Server tips published for the last 5 months. [download collection]

    [December 16, 2016 - Weekly SQL Server Tip #17]
    Weekly SQL Server Tip #17. This week's tip is about the STRING_SPLIT function in SQL Server 2016. [see tip]

    [December 09, 2016 - Weekly SQL Server Tip #16]
    Weekly SQL Server Tip #16. This week's tip is about .NET and connecting to SQL Server databases. [see tip]

    [November 30, 2016 - Weekly SQL Server Tip #15]
    Weekly SQL Server Tip #15. This week's tip is about SQL Server 2016 SP1 T-SQL enhancements and other. [see tip]

    [November 24, 2016 - Black Friday Discounts]
    Black Friday discounts from Nov 25 2016 to Nov 27 2016! 50% Off for all our products! Don't lose this unique opportunity. Visit our secure online store now!

    [November 22, 2016 - Weekly SQL Server Tip #14]
    Weekly SQL Server Tip #14. This week's tip is about SQL Server 2016 SP1. [see tip]

    [November 21, 2016 - New Release: In-Memory OLTP Simulator 1.1 (Build_20161120_1)]
    This new build of In-Memory OLTP Simulator fully supports SQL Server 2016 SP1. [download]

    [November 18, 2016 - Blog: SQL Server 2016 SP1: A Pleasant Surprise]
    In this article we are talking about the release of SP1 for SQL Server 2016 and the breakthrough changes shipped with this release. [read article]

    [November 15, 2016 - Weekly SQL Server Tip #13]
    Weekly SQL Server Tip #13. This week's tip is about Password Expiration option in SQL Server and a security advice. [see tip]

    [November 13, 2016 - Video: Introducing DBA Security Advisor in 75 Seconds]
    In this video we are presenting DBA Security Advisor in just 75 seconds. With DBA Security Advisor you can run security assesments against your SQL Server instances and get recomendations and remediation scripts or methods for the detected security risks. [see video]

    [November 09, 2016 - Weekly SQL Server Tip #12]
    Weekly SQL Server Tip #12. This week's tip is about In-Memory OLTP Engine. [see tip]

    [November 06, 2016 - Video: Introducing In-Memory OLTP Simulator in 60 Seconds]
    In this video we are presenting In-Memory OLTP Simulator v1.1 in just 60 seconds. With In-Memory OLTP Simulator you can benchmark your own workload against SQL Server's powerful In-Memory OLTP Engine. [see video]












     
  • [November 01, 2016 - In-Memory OLTP Simulator v1.1 is Now Out!]
    Today we are proudly announcing the release of In-Memory OLTP Simulator v1.1! The highligh of this release is Benchark Mode which is available in both editions of In-Memory OLTP Simulator. Simulate your own workload against SQL Server's powerful In-Memory OLTP Engine. Run benchmarks. Experience the performance boost! [download Community Edition!]

    [October 31, 2016 - Weekly SQL Server Tip #11]
    Weekly SQL Server Tip #11. This week's tip is about T-SQL code snippets in SSMS. [see tip]

    [October 22, 2016 - New Free Online SQL Server Service: SQL Server Backward Compatibility Checker]
    This free service brought to you by SQLArtBits, allows you to get the list of the backward compatible SQL Server versions for a selected SQL Server version. Just select the SQL Server version, click on submit and you will get the list! [use this service]

    [October 18, 2016 - Weekly SQL Server Tip #9]
    Weekly SQL Server Tip #9. This week's tip is about the Password Expiration option in SQL Server. [see tip]

    [October 13, 2016 - Announcement - New Release of In-Memory OLTP Simulator]
    We are excited to announce that In-Memory OLTP Simulator v1.1 will be released on Wed Oct 26 2016. The highlight in this new release is 'Benchmark Mode'.

    [October 10, 2016 - Weekly SQL Server Tip #8]
    Weekly SQL Server Tip #8. This week's tip is about our special solution 'DBA Security Advisor'. [see tip]

    [October 4, 2016 - Dynamic T-SQL Generator v2.0 is Now Out and it's Free!]
    Dynamic T-SQL Generator v2.0 is Now Out and it's Free! Easily convert static T-SQL to dynamic and vice versa. This new release is full of new features! Get it today!

    [October 3, 2016 - Weekly SQL Server Tip #7]
    Weekly SQL Server Tip #7. This week's tip is about Query Store in SQL Server 2016. [see tip]

    [September 27, 2016 - Weekly SQL Server Tip #6]
    Weekly SQL Server Tip #6. This week's tip is about Always Encrypted in SQL Server 2016. [see tip]

    [September 26, 2016 - New Blog Article: Why We Build SQL Server Tools]
    For us, building SQL Server tools is an Art. It's the art of helping you doing more with less effort when it comes to SQL Server! Learn more about our philosophy! Read the article!

    [September 22, 2016 - Snippets Generator v3.1 is Now Out!]
    Snippets Generator v3.1 is now out and it's free! Get it here!

    [September 21, 2016 - Article on SQL Server In-Memory OLTP]
    In this article, our Founder and Microsoft Data Platform MVP Artemakis Artemiou, presents a simple, yet comprehensive example of workload processing that was optimized using SQL Server In-Memory OLTP which led to a performance boost up to 79x times faster processing over disk-based execution. [read article]

    [September 19, 2016 - Weekly SQL Server Tip #5]
    Weekly SQL Server Tip #5. This week's tip is about Row Level Security in SQL Server 2016. [see tip]

    [September 15, 2016 - We are now SQLArtBits!]
    We are now SQLArtBits! Our initiative took the form of a software startup and it's here to to provide you with intelligent, high-quality SQL Server tools! We are now a team and we are here to make some noise!
    [August 31, 2016 - Top 10 Security Considerations for your SQL Server Instances]
    Read Artemakis Artemiou's latest article on SQLShack.com Journal discussing the difficult topic of how you can efficiently secure your SQL Server instances. [read article]

    [August 30, 2016 - Weekly SQL Server Tip 2]
    This week's SQL Server Tip is about JSON support in SQL Server 2016. [see tip]

    [August 15, 2016 - New Free Online SQL Server Service: SQL Server Latest Service Pack Info]
    This free service brought to you by Artemiou Data Tools, allows you to see the latest available service pack info for the SQL Server version you wish to check.Just select the SQL Server version, click on submit and you will get the latest service pack information! [use this service]

    [August 13, 2016 - New Free Online SQL Server Service: SQL Server Supported Operating Systems]
    This free service brought to you by Artemiou Data Tools, allows you to see the supported Windows Operating Systems for any SQL Server version you wish to check. Just select the SQL Server version, click on submit and you will get the list of supported Operating Systems! [use this service]

    [August 13, 2016 - Free Online SQL Server Services]
    A brand new initiative is now launched: Free Online SQL Server Services!
    With these free sql services you can get on-demand access to different useful information on different SQL Server topics such as: supported operating systems, service pack info, and much more!
    Feel free to share the news!

    [July 29, 2016 - We Are Now Live!]
    The brand new responsive website of Artemiou Data Tools is now officially launched!
    Visit our website from any device such as PC, smartphone, tablet, etc. and have the same rich user-experience!
    Feel free to explore our software tools and services which will definitely help you get the most out of SQL Server!