Database

Are Your Data Models Agile or Fragile: Sprints Last month I developed a whitepaper and a webinar on data modeling in an Agile environment.  These works focused on what we as data modelers can do to ensure that data models (and therefore data modelers) continue to be valued on IT projects.  This blog series touches on the key takeaways from these works.   Webinar: http://forms.embarcadero.com/Agile-or-Fragile Whitepaper: http://forms.embarcadero.com/Agile-or-Fragile-WP   Sprints   In the SCRUM methodo...
Are Your Data Models Agile or Fragile: Documentation   Last month I developed a whitepaper and a webinar on data modeling in an Agile environment.  These works focused on what we as data modelers can do to ensure that data models (and therefore data modelers) continue to be valued on IT projecs.  This blog series touches on the key takeaways from these works.   Webinar: http://forms.embarcadero.com/Agile-or-Fragile Whitepaper: http://forms.embarcadero.com/Agile-or-Fragile-WP   Documentation   The A...
Working with DBArtisan’s Performance Analyst In this video, Scott Walz covers DBArtisan's Performance Analyst, a cross-platform real time performance tool. Try DBArtisan free See more DBA and Developer Skill Sprints Learn more about Embarcadero® DBArtisan®, the premiere database administration toolset helping DBAs maximize availability, performance and security across multiple DBMSs. And try DBArtisan for free....
Enabling Enterprise Agility Through Model-Driven Data Design This is an excerpt from the IDC Technology Spotlight June 2015 report, Enabling Enterprise Agility Through Model-Driven Data Design. This paper examines the growing importance of model-driven processes for database design and management. You can download the entire report here.
Creating and Identifying Deadlocks in SQL Server This video from John Sterrett shows you how to create a deadlock and how you can proactively monitor deadlocks using the default system_health extended event. Get the ultimate tool suite for cross-platform database management Embarcadero DB PowerStudio, a suite of award-winning database tools for DBAs and data professionals, uniquely offers comprehensive administration, development and performance tuning capabilities across all major database platforms which dramatically increases productivi...

Check out more tips and tricks in this development video: