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…

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…

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…

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…