Blog

Internals of Statistics That You Were Not Aware Of

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

MongoDB – Data Modeling Primer

by Anil M

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

How-To Guide: Upgrading Your Delphi VCL Applications To Support 4K Displays

by Eli M.

Alexander Halser from EC Software GmbH. has released an in-depth how to guide for preparing your Delphi VCL applications to support 4K...

Tips Database Developers Must Know Reading Query Plans

by Tim DelChiaro

If you are a developer, you might have heard this from your DBA – “That query plan has some problems”. This blog would help you in understanding...

The 3Vs may require NoSQL, but data modeling is still required – by Rob Loranger

by Joy Ruff

We live in an exciting time where technology is entering our lives in areas that many of us never expected. For example, at home, once unintelligent...

Knowing your Storage Basics- 2 Life Lessions for a DBA

by Tamarian D2278

IF_THEN_ELSE_RapidSQL

by Tamarian D2278

This week I’ll take a look at IF-THEN-ELSE-ELSEIF syntax. Next blog I’ll take a look at the similar CASE syntax and compare/contrast the...

CASE Syntax using Rapid SQL

by Tamarian D2278

Hi, Last blog we visited the IF-THEN-ELSE conditional syntax. This blog, I’d like to convert those examples using the newer CASE...

Auditing is More Than a Way to Get the Security Team Off Your Back

by ideracommunity

As a DBA, you probably look at auditing tools as a something forced upon you by the security officer. You are asked to provide continuous auditing...

Securing your Data Modeling Assets – ER/Studio Repository

by Anil M

How do I turn off Scientific Notation in the Grid and Text Results for Sybase ASE FLOAT data type?

by Jonathan Powers

How do we turn off scientific notation? I’m getting this in both text and grid results for Sybase ASE servers. create table myfloat (...

How to execute IBM DB2 UDB Admin commands that are part of CLP in Aqua Data Studio ?

by Tariq Rahiman

How to execute IBM DB2 UDB Admin Functions in Aqua Data Studio ? IBM DB2 has server SQL commands, and commands that are part of their...

Changing the Max Concurrent Service Connections for SQL Diagnostic Manager

by Vicky Harp

SQL Diagnostic Manager automatically limits the number of connections that a collection service may make to an individual monitored server. This...

Top 2 Reasons Why Database Developers Take Certifications

by Tim DelChiaro

Developers, Administrators and individuals have various levels of motivations when it comes to taking certifications. There are no set rules or ways...