Every day a DBA (or a developer), has to reply to questions like “who changed that table?” or “who tried to login on our production database?”. These answers are not so simple to find out, actually. LepideAuditor for SQL Server is a tool that can helps us to audit operations on a SQL Server instance and to monitor both the server and the database level.
I’ve spoken about SSMS Boost in this post and now I’m going to apply one of its feature in order to improve the productivity of my team. Speaking about the database side, a table that contains static data can be used as a foreign key referenced table. In my experience those kind of tables are often mapped to enums in our application layer. Creating that enum can be a tedious operation and sometimes it can be very uncomfortable. With SSMS Boost we can enhance our development experience. Continue reading
Recently I moved my job on ALM topics, focusing on Source Control Management and Testing, in order to reach Continuous Integration on database development. I evaluated some tools and Red-Gate was my first choice. In this post I’d like to share the suggestions I made on two of the most important tool I’m using atm:
- SQL Prompt (productivity tool for code formatting, intellisense, code inspection, etc.)
suggestions: TODO highlights. I’d like to improve readability of TODO and HACK comments, like in the following picture:
- SQL Test (addon for SQL Server Management Studio, unit testing utility)
“Expand/Collapse all” for avoiding clicks when you have lots of test procedures
Italian Community Days 2014 are coming!
The event is totally free!
You fill find:
I’ll present my “database under source control” session. My “mission” is to bring ALM knowledge on database side. I think that this topic is often underestimated.
here is the list of cummunities that will follow the event:
Click here for more info.
So, spread the word! hashtag: #CDays14
What are you waiting for? Subscribe now!