On April 5 2017, SQLArtBits releases DBA Security Advisor v2.0. This article gives a sneak peek of the upcoming new release of DBA Security Advisor v2.0. DBA Security Advisor is a powerful tool developed by SQLArtBits that allows Database Administrators (DBAs) to run comprehensive security assessments against multiple SQL Server instances, using…
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 Tools”. The…
Welcome to another screencast of the “SQL Server 2012 Screencast Series“! In this short screencast we talk about code snippets in SQL Server 2012 Management Studio. Code Snippets are being used for many years now by developers in Integrated Development Environments (IDEs) like Microsoft Visual Studio. Their benefits vary. Some…
The Story Behind Dynamic SQL Generator At some point in the past, in the early years of SQLNetHub, it reached 100.000 visits. Given this opportunity I decided to try to do something special, for example write a pretty cool article or even better, build a SQL-Related tool and make it…
[Update 2018] Please visit Snippet’s Generator page for the latest release of the tool and much more. T-SQL code snippets is a very handy new feature originally shipped in SQL Server 2012. Using code snippets you can save time when you write code and you just need to enter code that does…
Some time ago Red Gate released SQL Search, a SSMS add-in that allows the user to search for fragments of text within database objects in a SQL Server instance! Yes, I know, this is cool! 🙂 There are many scenarios where the tool can come in handy. For example, imagine…
One of the many privileges of being a Friend of Red Gate, is that you have the chance to evaluate the company’s products and provide feedback and suggestions. In this post, I provide my review for one of Red Gate’s latest tools; SQL Object Level Recovery Native. SQL Object Level…
Red Gate is a software company based in the university town of Cambridge, UK, specializing in MS SQL Server, .NET and email archiving tools. Red Gate is one of the strong supporters of the SQL Server, .NET and Exchange communities. A great example of this, are Red Gate’s well-known community…