Activity overview
Latest activity by robrich
I'll break the seal. It's very frequent that I want to select most but not all the columns. Yeah, I could script the table definition in SSMS, flip over to VS Code, regex the column names out, string them together, then start editing. Or I could just `select *`, copy results into Excel and delete columns. Instead I type `select * from mytable`, move my cursor back to the `*` and push tab. Up pops the full list of columns, and I'm nearly there. Just saying, it's elegantly simple. / comments
I'll break the seal. It's very frequent that I want to select most but not all the columns. Yeah, I could script the table definition in SSMS, flip over to VS Code, regex the column names out, st...
I like the terms you've chosen. They do seem very descriptive and modern. When I'm in this space I often hear the terms Data Access Management or Data Access Governance. (DAM and DAG respectively.) Is there benefit to using unique terms or industry standard terms? I know we got burned by leaning into DLM. / comments
I like the terms you've chosen. They do seem very descriptive and modern. When I'm in this space I often hear the terms Data Access Management or Data Access Governance. (DAM and DAG respectively....
I click download invite, and it refreshes the page but doesn't download. Thanks Eleanor. It's now resolved. / comments
I click download invite, and it refreshes the page but doesn't download. Thanks Eleanor. It's now resolved.
I just fell out of the newrow room. It tells me the instructor left. Refreshing tells me the instructor hasn't joined yet. / comments
I just fell out of the newrow room. It tells me the instructor left. Refreshing tells me the instructor hasn't joined yet.
I got to see this tool, and it's really cool. It's in early stages, so I can't yet replace SQL Source Control with Redgate Change Control, but I'm excited to do so when I can. Well done team. / comments
I got to see this tool, and it's really cool. It's in early stages, so I can't yet replace SQL Source Control with Redgate Change Control, but I'm excited to do so when I can. Well done team.
How has SQL Change Automation helped me? DevOps has made building and deploying apps a breeze. But what about the database? Should we continue RDPing into the server and manually running scripts? Of course not! SQL Change Automation is that magic piece that unlocks DevOps for databases. Hook it up to developers and we can now communicate both app and database changes in one git push. Hook it up to CI and we can now prove there aren't any syntax or logic errors in our SQL. Hook it up to tSQLt or SQL Test and we can now unit test our sql functions just like we unit test our code functions. And finally hook it up to the deployment databases in all environments, lock everyone out of those databases, and we now have confidence that if it ran in pre-prod it'll run great in prod too. After all, we practiced the production deployment with every DevOps build since the change was introduced. Just saying, DevOps with Databases is completely a thing, and SQL Change Automation is the elegantly simple way to do it. / comments
How has SQL Change Automation helped me? DevOps has made building and deploying apps a breeze. But what about the database? Should we continue RDPing into the server and manually running scripts...
Oooh, oooh. Can I win a copy of https://www.amazon.com/SQL-Server-Source-Control-Basics/dp/1910035017? I hear the authors are really awesome. :P / comments
Oooh, oooh. Can I win a copy of https://www.amazon.com/SQL-Server-Source-Control-Basics/dp/1910035017? I hear the authors are really awesome. :P
Calendar fail. I thought this was today right until I realized it was yesterday. Is there a recording of this presentation? I'm really curious to learn more about Redgate Deploy. / comments
Calendar fail. I thought this was today right until I realized it was yesterday. Is there a recording of this presentation? I'm really curious to learn more about Redgate Deploy.
Count me in! / comments
Count me in!
Curious about the details here. Will it still be branded "PASS" and "SQL Saturday"? Or will it now be "PASS by Redgate"? Or "Redgate PASS"? / comments
Curious about the details here. Will it still be branded "PASS" and "SQL Saturday"? Or will it now be "PASS by Redgate"? Or "Redgate PASS"?