Sneak Peek of SQLArtBits DBA Security Advisor v2.0

[Update: SQLArtBits is Now SQLNetHub!] You can find the latest version of DBA Security Advisor here. 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) … Read more…

A New Project: Artemiou Data Tools

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…

Screencast: Working with Snippets in SQL Server 2012

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 of them are: Code Reuse … Read more…

Tool that Generates Dynamic T-SQL!

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 available on SQLNetHub! Before talking … Read more…

Snippets Generator v1.0 is Now Out!

[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 common tasks. Code reuse has … Read more…

Product Review: SQL Search – Searching for SQL Text Within SQL Server DB Objects

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 trying to perform a modification … Read more…

Product Review: SQL Object Level Recovery Native

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.   What Does SQL Object Level Recovery Native … Read more…

Friends of Red Gate

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 web sites www.simple-talk.com and www.sqlservercentral.com. … Read more…