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...
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...
Hi, Last blog we visited the IF-THEN-ELSE conditional syntax. This blog, I’d like to convert those examples using the newer CASE...
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...
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 Functions in Aqua Data Studio ? IBM DB2 has server SQL commands, and commands that are part of their...
SQL Diagnostic Manager automatically limits the number of connections that a collection service may make to an individual monitored server. This...
Developers, Administrators and individuals have various levels of motivations when it comes to taking certifications. There are no set rules or ways...
Nobody would want to shy away from some help. This is second to human nature and we never try to talk it out explicitly. When at work, if we can...
If nothing works, then a restart works. This is the exact sentiments that an Administrator has when it comes to working with software. If you are...
One of the most critical responsibility of a Database Administrator (DBA) is to make sure that the databases are backed up on regular basis. What...
Guest post by Pinal Dave If you are a developer, you might have heard this from your DBA – “That query plan has some problems”. This blog would help...
Check out this guest post by industry expert Pinal Dave who provides 3 leadership tips to define success in any industry. Every individual has their...
Backup is one of the driest topics and it seems to be something non-negotiable for a DBA role. If we look into the fine prints of why someone should...
Being a developer is an awesome experience – trust us. You are an architect and the builder of your dreams. A developer shapes the way the...
Section 1: Creating a Data Model In this section, we will be learning how to create a data model from scratch using ER/Studio Data Architect. See...
As adherence to regulations continues to be pressed upon organizations by industry and government regulators, the ability of the organizations to...
The operational culture of the enterprise has gradually shifted towards a more business-centric model, one where business users and front line...
The talk of the town these days is around Big Data if you are in a data-related domain. Most of the top CIOs are trying to get onto this bandwagon...
This article by Pinal Dave looks at some of the developer traits that one must keep in mind while working with databases Being in the databases...
This is the second in a series of six posts from David Loshin. Read the previous post and the next post in the series. In my last...