database-tools Archives

MongoDB – Data Modeling Primer

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

Break Into Script with PowerShell 5.0

by ps1

PowerShell 5.0 Preview As you might know, PowerShell 5.0 Preview is available and comes with vast debugging improvements. One is to be able to debug...

Watch Rick Astley Dance and Sing!

by ps1

All PowerShell Consoles (not PowerShell ISE) Before you try this, you may want to click the icon in the upper left corner of the PowerShell title...

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

Pinging via IPv4

by ps1

All PowerShell versions You can use ping.exe just like any other command inside PowerShell scripts. By adding “-4” to the command line,...

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

Changing PowerShell Priority

by ps1

All PowerShell versions Maybe you’d like a PowerShell script to work in the background, for example copy some files, but you do not want the...

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

5 Different Ways to Start SQL Server Services

by Tim DelChiaro

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

Lesser Known SQL Server Backup Practices by Pinal Dave

by Tim DelChiaro

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

Tips Developers Must Know Reading Query Plans

by Tim DelChiaro

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

3 Leadership Tips That Define Success by Pinal Dave

by Tim DelChiaro

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

Understanding Database Backup Strategies by Pinal Dave

by Tim DelChiaro

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