Things that have impressed me today
-
Well there's only one "thing" actually, but back when I was doing software and all that jazz I would have loved a tool like Red Gate SQL Prompt. Talk about taking the effort out of writing T-Sql and the code formatting option is brilliant. Excellent stuff, and if you're not convinced by my rambling they offer a free 14 day trial.
-
Well there's only one "thing" actually, but back when I was doing software and all that jazz I would have loved a tool like Red Gate SQL Prompt. Talk about taking the effort out of writing T-Sql and the code formatting option is brilliant. Excellent stuff, and if you're not convinced by my rambling they offer a free 14 day trial.
I haven't used their SQL tools, but their memory profiler and exception hunter stuff is similarly impressive.
-
Well there's only one "thing" actually, but back when I was doing software and all that jazz I would have loved a tool like Red Gate SQL Prompt. Talk about taking the effort out of writing T-Sql and the code formatting option is brilliant. Excellent stuff, and if you're not convinced by my rambling they offer a free 14 day trial.
I found SQLPrompt to slow me way down. I DO love SQLCompare, though...worth every penny.
-
I found SQLPrompt to slow me way down. I DO love SQLCompare, though...worth every penny.
You must have ninja-like SQL skills, fingers of tungsten and asbestos underpants. I have always sucked at SQL though, and take any help I can get :)
-
Well there's only one "thing" actually, but back when I was doing software and all that jazz I would have loved a tool like Red Gate SQL Prompt. Talk about taking the effort out of writing T-Sql and the code formatting option is brilliant. Excellent stuff, and if you're not convinced by my rambling they offer a free 14 day trial.
I have used prompt from when it was a free tool, the current version is excellent but the previous release was pretty crappy. I rarely praise a suite in general but all the bits from Red-Gate we have used are excellent. SQL Compare is my favourite.
Never underestimate the power of human stupidity RAH
-
You must have ninja-like SQL skills, fingers of tungsten and asbestos underpants. I have always sucked at SQL though, and take any help I can get :)
I have written tools that format table field names into a list for a SQL query so I can cut and paste large lists of fields into the query (with aliases prepended and with commas). If there are only a few fields, then typing them is faster than waiting for the SQLPrompt lists to pop up (not to mention that SQL is not formatted to easily allow the editor to know which table you are querying from until you write the FROM and JOIN clauses).
-
Well there's only one "thing" actually, but back when I was doing software and all that jazz I would have loved a tool like Red Gate SQL Prompt. Talk about taking the effort out of writing T-Sql and the code formatting option is brilliant. Excellent stuff, and if you're not convinced by my rambling they offer a free 14 day trial.
-
I have written tools that format table field names into a list for a SQL query so I can cut and paste large lists of fields into the query (with aliases prepended and with commas). If there are only a few fields, then typing them is faster than waiting for the SQLPrompt lists to pop up (not to mention that SQL is not formatted to easily allow the editor to know which table you are querying from until you write the FROM and JOIN clauses).
Scott Serl wrote:
not to mention that SQL is not formatted to easily allow the editor to know which table you are querying from until you write the FROM and JOIN clauses
Good point - in the 6 hours or so of using the tool I started doing this: SELECT dbo.Table.Field to get intellisense and only got unstuck (slightly) when I needed to do this: where dbo.Table.Field = (SELECT MAX(tbl.Field) FROM dbo.Table as tbl WHERE dbo.Table.Field2 = tbl.Field2) 'cos the subquery couldn't be intellisnesed until I'd written the FROM clause. Still a brilliant tool, though :)
-
Well there's only one "thing" actually, but back when I was doing software and all that jazz I would have loved a tool like Red Gate SQL Prompt. Talk about taking the effort out of writing T-Sql and the code formatting option is brilliant. Excellent stuff, and if you're not convinced by my rambling they offer a free 14 day trial.
I find the sometimes limited Intellisense in SQL Server 2008 quite helpful and enough most of the time.