Achieving Data Modeling Nirvana Data Modeling has forever been a realm of a segment of folks that are immersed into the nitty gritty of Database Architecture from a model to Database approach. These are the individuals are that encompass, what Architects are to Buildings! So you have decided on venturing into Data Modeling, but don't have the skills to achieve it! Well! Fear Not! Embarcadero's flagship Data Modeling Suite ER/Studio, helps you through that journey. Concepts wise, there are plenty of books out that enable yo...
SQL Server Data Modeling Made Easy Microsoft SQL Server is slowly beginning to become the preferred platform for most organization big and small. So it would make sense in building Data Models that would be scalable for the Microsoft Data Platform? Well, you have a choice! And enter Embarcadero ER/Studio. With ER/Studio Data Architect, you can easily build SQL Server Data Models from scratch or by reverse engineering an existing database. [Reverse Engineering Wizard] [Logical Data Model window]   [Physical Data Mo...
PostgreSQL Administration Made Easy PostgreSQL let's face it! is the World's most advanced Open Source Database. It has been replacing many proprietary database systems out there. Well, being a bleeding edge Database Tools Company, Embarcadero always keeps pace with the latest happening in the Industry. Well, in the latest release of DBArtisan, our flagship Database Administration tool, we are proud to announce PostgreSQL native support!    [Datasource Registration Screen] [Database Explorer] [Query Editor and Res...

Posted by on in Database
SMO - SQL Server Management Objects SMO stands for Shared Management Objects. It is a SQL administration API used to get meta data information from SQL Server. You may ask “Why? I can already do that”. True, but what if your only need was to have a tool that could do some of the following: Backups and restores Create some test databases Maybe even export some SQL Server related information to an Excel Spreadsheet This tutorial focuses on getting started using this powerful API in your .NET applications. Mind you, this is n...
MongoDB - Data Modeling Primer We all know and have been hearing about NoSQL systems since the last year or so! 2014 is slated to be the year of NoSQL DB Platforms and Big Data Implementations. Well MongoDB one of the leading NoSQL Database providers are making waves. You might think why would one want to data model a schema-less database? Let this video show you how! http://youtu.be/ZKbjlsa2bhI       [Video Credit: Robert Loranger - Product Manager - ER/Studio]     For more details check...
Securing your Data Modeling Assets - ER/Studio Repository Enterprises today face a tough challenge of keeping their data assets in sync and secure. Data Modeling assets are no different! So we will explore:    Real-Time Data and Business Process Collaboration for the Enterprise The Model Repository for ER/Studio gives users real-time collaboration features for sharing and re-using assets across data and business process modeling projects. This collaborative working environment allows organizations to maintain compliance with business...
SQL PASS Summit 2014 - An Extraordinary Experience! What a Fabulous Week at @SQLPASS #Summit14.     Met new prospects and also current customers!! We had a lot of folks come to our booth and discuss some of the key pain points that they were facing in terms of database administration, performance and change management. We had special guests are our Booth ranging from Pinal Dave, Tim Radney and John Sturrett. On the data modeling side of the house, we had a bunch of DBAs and Architects approach our booth asking us the co-relati...
Building Your Very First Data Model From Scratch Section 1: Creating a Data Model In this section, we will be learning how to create a data model from scratch using ER/Studio Data Architect. Launch ER/Studio Data Architect Click on the New Data Model icon Choose Draw a new data model and Relational as the preferred choice. Click OK to complete. You will now be presented with a blank canvas as shown below. Now Click on the Entity icon as shown below. The blue circled indicates the Entity icon    We w...

Check out more tips and tricks in this development video: