Blog

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

by Tamarian D2278

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

by Richard Scruggs

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

by Anil M

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

by Anil M

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

by Vicky Harp

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.

by Joy Ruff

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

by Anil M

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?

by SandiW

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

by Tamarian D2278

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

by Tamarian D2278

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

by whateverTJ

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

by Joy Ruff

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...

Internals of Statistics That You Were Not Aware Of

by Tamarian D2278

As a developer statistics is one of the important things we need to know while doing SQL Server query performance tuning exercise. Let us try to...

3 More Reasons SQL Server Service is Not Responding

by Tamarian D2278

NOTE: This content has been updated and expanded in a whitepaper: 7 Reasons Your SQL Server Service Won't Start, by Pinal Dave ---------- After...

SQL Server Data Modeling Made Easy

by Anil M

Microsoft SQL Server is slowly beginning to become the preferred platform for most organization big and small. So it would make sense in building...

Engaging the Business Users in Enterprise Semantics – by David Loshin, Knowledge Integrity, Inc.

by Joy Ruff

This is the fifth in a series of six posts on metadata collaboration from David Loshin. Read the previous post and the next post in the...

Collaboration Principles and Universal Data Models – By Len Silverston, Universal Data Models, LLC

by Joy Ruff

Once upon a time, there were four expert data modelers engaged on an enterprise data modeling effort. There was also an additional expert data...

PostgreSQL Administration Made Easy

by Anil M

PostgreSQL let's face it! is the World's most advanced Open Source Database. It has been replacing many proprietary database systems out...

2 Things to Know About When Using Snapshot Isolation

by Tamarian D2278

SQL Server 2005 version introduced the concept of Snapshot isolation setting. It is one of those hidden gems inside SQL Server which is under...

SMO – SQL Server Management Objects

by Anil M

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...