Geeks With Blogs
David Atkinson SQL Prompt
Ever wondered what the Object Explorer Details window is for?
Typically, when I install SQL Server Management Studio and run it for the first time, the first thing I do is to close the Object Explorer Details window. After all, it doesn’t seem to serve a useful purpose, duplicating information that already exists in the Object Explorer. However, I have discovered that it has one important redeeming capability, the ability to allow multi-selection by holding the ctrl or shift key depressed during the selection. Why is this useful? If I want to rename an object, ......

Posted On Monday, April 23, 2012 5:06 PM

Free tool to format your SQL code
There are a number of free T-SQL prettifiers out there, covering both code layout and syntax highlighting, but Format SQL is different in that it leverages the engine that powers SQL Prompt, the popular add-in that extends SQL Server Management Studio for SQL developers and DBAs. Simply type or paste T-SQL into the top text area, and it formats your SQL on the fly in the lower text area. This was developed by a small team at Red Gate during Down Tools Week, a quarterly occurrence, where everyone ......

Posted On Tuesday, April 17, 2012 4:56 PM

Using a SQL Prompt snippet with template parameters
As part of my product management role I regularly attend trade shows and man the Red Gate booth in the vendor exhibition hall. Amongst other things this involves giving product demos to customers. Our latest demo involves SQL Source Control and SQL Test in a continuous integration environment. In order to demonstrate quite how easy it is to set up our tools from scratch we start the demo by creating an entirely new database to link to source control, using an individual database name for each conference ......

Posted On Thursday, April 12, 2012 9:46 AM

Copyright © David Atkinson | Powered by: