Даже если вы никогда ранее не работали с СУБД PostgreSQL, не представляет трудностей создать, заполнить и управлять БД на этой платформе, если у вас...
Создание БД PostgreSQL для новичков
read more
Blog
The #1 Data Modeling Issue – Being ‘Dead’ Right – By Len Silverston, Universal Data Models, LLC
While many data modelers are very open minded and not righteous at all in their attitudes, over the years, I have heard the following statements...
How to Connect your Applications to your Data
This is a video replay from the DataU online conference. An Application Programming Interface (API) brings your own applications closer to your...
Cloud Databases – A Primer
Ever since the era of Cloud Computing featuring SaaS(Software as a Service) pioneered by Salesforce, Databases have not been left behind. Databases...
Exploring Microsoft SQL Server System Databases
The Microsoft SQL Server System comprises of four key System Databases master model msdb and tempdb The following table outlines the key points...
Empower your Applications with Embarcadero Team Server APIs
The Team Server REST Application Programming Interface (API) allows one application to talk to another application directly and securely. Team...
Result Cache Using Rapid SQL
Hi! The Result Cache is a newer structure for Oracle11 and newer databases. This feature remembers the invariables and return...
Oracle 12 New Limits
Hi! I’ve been working on PL/SQL topics and wanted to share with you a new Oracle12 feature. Oracle12 now allows for much longer...
3 Things You Didn’t Know About Black Box Trace
Black Box Trace In earlier versions of SQL Server, there have been situations where root cause analysis was never possible because data saved by SQL...
Data Modeling Source Control Demystified
This video replay from the Data U online conference gives you an overview of the challenges faced by organizations wanting to implement a secure...
Top 3 Security Concepts Any DBA Must Know
DBAs understand how critical and important security is but due to other administration priorities, it can often take a back seat. When working...
3 Tips for Technical Presentation That Every Developer Must Know
Over the past decade, I have developed and given many technical presentations that range from being cultural, based on depth of audience or on...
Top 2 Errors When Working with Datetime Conversions
Working on universal applications has its own challenges. Often I have seen developers resort to unwanted conversions inside the database based on...
SQL Safe and AlwaysOn Availability Groups
With the release of version 7.4 in August, SQL Safe added AlwaysOn Availability Group support by taking into account the preferred replica when...
Adhoc Database Monitoring Made Easy
There are times when you need to get adhoc monitoring information from your databases. Well, now you can! with Embarcadero's DBArtisan Analyst...
Managing Change in Enterprise Data Modeling
It is often said that Change Management is nothing new in the IT Industry. The Data Modeling space is no different. The critical facet in enabling...
Altering wait categories in SQL Diagnostic Manager
SQL Diagnostic Manager ships with built-in categorization of wait types which are encountered in monitoring. These categories are used on both the...
Using Collaboration for Spreading Enterprise Knowledge – by David Loshin, Knowledge Integrity, Inc.
This is the last in a series of six posts on metadata collaboration from David Loshin. Read the previous post in the series. In my earlier...
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...
Did you choose to be a DBA?
We have had this survey question and a few others on the community for a few months and thought we would share some of the results. This was a brief...
Cloud phenomnenon- 3 things that make it different from on premise
Cloud – the new buzz word in the IT industry is just like the .com days in my humble opinion. Organizations have been doing the whole...
Top 4 Startup Parameters DBAs Must Know
Introduction Working on a server is always something DBAs cherish. With every environment that they monitor, they want to know how applications can...
Black Friday Sale – Flat 30% OFF on all products
Update: Thank you all for making this campaign a huge success. We are extending this offer till Dec 1st, 23:59 PST. Many corporate users requested...
Big Data = Bigger Need for Data Models – by Rob Loranger
Big Data has had a great impact on science, healthcare, government and many other industries. For instance, it is now possible for scientists to map...