Database

Object Filtering in DBArtisan and Rapid SQL - DBA and Developer Skill Sprint In this Skill Sprint video from the DBA and Developer Skill Sprint series we look at object filtering in DBArtisan and Rapid SQL; Learn more about DBArtisan and try it free Learn more about Rapid SQL and try it free See more DBA and Database Developer Skill Sprints  ...
ISQL Editor in DBArtisan and Rapid SQL - DBA and Developer Skill Sprints In this skill sprint we cover ISQL editor features in DBArtisan and Rapid SQL. Learn about the options available in the ISQL window for different database platforms and for Auto Format and Code Assist. Then see some examples of Oracle and SQL Server queries, how to format queries, use code templates and much more.  Learn more about DBArtisan and try it free Learn more about Rapid SQL and try it free See more DBA and Database Developer Skill Sprints  ...
Are You Working on an Agile Project?  Should You Be? At EDW this year Ron Huizenga, Product Manager for ER/Studio, and I led a SIG discussion about working on agile projects...as a data modeler. As usual, this resulted in a lot of frustration being voiced from data modelers about: Not being wanted on the voyage Being treated like obstacles to getting stuff done Being confused by terminology and expectations that differ from 1980s approach to data modeling Being frustrated because perfectly good data models are ignore Being frustrated becaus...
Finding Your Top Offending Statements with Extended Events Finding the top offending statements for a specific workload can be hard if you are not using the best tool in your toolbox. On SQL Server 2012 and going forward you are able to leverage extended events which are included inside of SQL Server Manager Studio (SSMS) to build your first extended event to capture your workload.  The secret sauce to the Extended Event tools build into SQL Server Management Studio (SSMS) are the features you can use once your workload is captured. You can group ...
Tags: Rapid SQL
Aligning Your Models for Master Data Management - by David Loshin In my last post, I suggested that the conventional “facet” approach to designing master data models (in which each master domain is modeled, designed, and implemented in isolation from the others in the enterprise) creates gaps in the ability to effectively build applications that facilitate successful execution of end-to-end business processes. For example, the perception (and consequently the definition) of the role of a “customer” changes between the marketing, sales, finance, fulfillment, an...

Check out more tips and tricks in this development video: