One of the most common issue you can find when source controlling the database is about the security. How to manage the users and the related permissions?
If you use to apply permission to users and to assign users to the database, this can be a problem, especially when you are in the deployment phase (or else when getting latest versions from the source control). Let’s see these two scenarios:
Continue reading “How to manage SQL Server security with SQL Source Control”
My SQL Saturday Parma slide decks are available to download on SlideShare.
Concepts: ALM/DLM, team work, differences between code and databases.
Stay Tuned! 🙂
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.
Continue reading “LepideAuditor for SQL Server review”
This year, 22 November, PASS SQL Saturday
will come to Parma, my birth town. I’m proud to be the organizer of that event.
Our community, dotnethell.it
, will be there and you can meet some of us 🙂
Continue reading “PASS SQL Saturday in Parma”
I’ve already spoken about source controlling database using Visual Studio Online and Red-Gate SQL Source Control in this post. The described kind of approach brings a drawback, due to the nature of the plugin and VSO APIs: High latency when getting and syncing local database and workspaces.
Due to this problem, I’ve changed my settings when linking my databases, switching them from “Team Foundation Server (TFS)” to “Working folder“, as in the following picture:
Continue reading “SQL Server with Red-gate SQL Source Control – Working folder management with TFS”
In previous posts, I’ve spent a lot of words speaking about third party add-in for SQL Server Management Studio.
Finally we have developed a new extension! We’re proud to present….
Continue reading “Engage IT Services SQL Todo Explorer – our *FIRST RELEASE*!”
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 “Create C# enum template with SSMS Boost”
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
for grouping tests logically and not with the strict database schema names
If you think that those suggestions could help us, feel free to vote!
Italian Community Days 2014 are coming!
The event is totally free!
You fill find:
- A very good agenda.
- Three days of tech full immersion, dal 25 al 27 febbraio.
- Five tracks
- Sixty speakers!
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!
During my SQL Devlife I tried lots of SQL Server management studio add-ins. Some days ago I tried SSMSBoost. Since I’ve already spoken about SSMSToolsPack and SQLPrompt, I’d like to focus this post on the capabilities that SSMSBoost adds to Sql Server Management Studio. I’ll speak about some of the available features, in the following order:
- UI/User experience capabilities
- Connections management
- Extended menu options
- Grid commands
Continue reading “SSMS Boost another cool addin for SQL Server Management Studio”