Posts
Sort by recent activity
Sql Agent 2.0
Hi AllI recently saw this article and definitely agree. https://www.sqlservercentral.com/articles/the-case-for-sql-server-agent-2-0SQL Agent is always a massive part of what we do in the data wareh...
Extending Summarise Script
Posting here instead of UserVoice because a screenshot helps explain it.Summarise script is a good feature. I often encounter SPs with 20+ statements. It would be nice if the logic already built ...
Inline EXEC (possbily) too hard to find?
Hi All. I was debugging a stored proc with ~1000 lines of code and with lots of parameters and temp tables.I came across the below image on UserVoice and then went down to the comments and found t...
Quickly compare two objects
Hi - is there a way to quickly compare two objects. I can do this very nicely with SQL Source control but a lot of our legacy stuff we've inherited isnt in source control at the moment. managemen...
FoRG Pivot Viewer
Hello all,
I don’t know if you guys remember Microsoft’s Pivot Viewer control
from about 10 years ago (which they abandoned)?
A company called Zegami have picked it up - I was mucking
about and p...
FoRG Pivot Viewer
Hello all,
I don’t know if you guys remember Microsoft’s Pivot Viewer control
from about 10 years ago (which they abandoned)?
A company called Zegami have picked it up - I was mucking
about and p...
RG_SQLSourceControl_DDLTrigger
Msg 15404, Level 16, State 19, Procedure RG_SQLSourceControl_DDLTrigger, Line 0 [Batch Start Line 0]Could not obtain information about Windows NT group/user 'AMTRUSTSERVICES\BBrown1', error code 0x...
what is the relationship between apexSQL and redgate?
Hi redgate - I ran a couple of demo's of sql source control in my company recently. it was well received but I was asked to check to see if any other vendors were offering a similar product.Istumb...
A collection of unorganised thoughts on SQL Dependency Tracker
Hi Redgate,
This is a random brain dump from my experience with Dependency Tracker; I decided it wasn't coherent enough for user voice and just wanted to record it all whilst it was fresh in my min...
SSMS + Sql Source Control - vs - Visual Studio
Hi All,
I recently joined a new company in their BI team. A lot of the team have some .NET experience but we are purely doing database work at the moment. It's a fairly new team so there aren't m...