Blog - Post List
    • 10 Jan 2017

    The Value of Data Modeling

    How do you convince your management that data models are worth the time and effort they require? You may be dealing with challenges around the value your company places on their data compared to how that data is actually managed. It can be difficult to assign a dollar amount and calculate a return on investment, but this is often what the business stakeholders need to see in order to justify and validate the use of data...
    • 6 Jan 2017

    2017: A New Year with new projects?

    2017: A New Year with new projects? I’m not big into new year’s resolutions. Too often they are just words that we never act on. When you stop and think about it, the dawning of a new year is just another day on the calendar: December 31 turns into January 1. Big deal, right? While we as individuals may scoff at new year’s resolutions, IT shops across the world make plans for the new year, building...
    • 6 Jan 2017

    Isolation Levels 101: Concurrency Issues

    The other day I had a client complaining about slowness, queries erroring out, blocking and processes stopping; you know the usual complaints. So, like any other DBA I pulled out my handy dandy toolbox of queries to determine exactly what was going on with the server. Upon reviewing their current running sessions, I noticed that the Isolation Level for a simple UPDATE transaction was “Serializable” and all...
    • 5 Jan 2017

    Making the Most of Modern Database Technology

    Is your database equipped to handle high-volume workloads without experiencing downtime?What kind of impact is the need for more frequent patching placing on it?Does it support the unique requirements of different data management sets? The SQL protocol at the heart of relational databases was written decades ago. It has managed to keep up with increasing data demands, but only if your database architecture has evolved...
    • 4 Jan 2017

    How to Run PowerShell Scripts with Uptime Infrastructure Monitor

    Introduction Microsoft PowerShell is an automation platform and scripting language for Windows and Windows Server that allows you to simplify the management of your systems. Unlike other text-based shells, PowerShell harnesses the power of the .NET Framework. PowerShell also provides rich objects and an extensive set of built-in functionality for taking control of your Windows environments. Combine PowerShell and...
    • 24 Dec 2016

    Comparing Database Virtual Machine Platforms

    Oracle technologists, database architects, database administrators, and senior database application developers are all very curious people by nature – even more curious than most people. So naturally database oriented issues evoke debates similar to “tastes great, less filling” from the famous beer commercial. You might be surprised by the scope and passion of such database debates. One area getting...
    • 24 Dec 2016

    Virtualized Storage: Where have all my disks gone?

    In the good old days most DBA’s could walk into their computing center and point to their database server and its disks. Furthermore, many DBA’s could also point to specific disks and state which database objects they housed. In fact database object placement and separation was a key tuning consideration back in the day. Oh my how times have changed. At first all database servers utilized direct attached...
    • 22 Dec 2016

    Run Book, Run!!!

    How many of you actually have a “Hit-by-the-Bus” handbook? What is that, you ask? It is a document that explains how to execute all your jobs and SSIS packages. In addition, I preference mine with all key elements someone might need, like where passwords are stored, architectures, backup times, where are backups stored, etc… then dig into the job steps. The purpose of this document is so that someone...
    • 19 Dec 2016

    Workload Analysis for SAP HANA General Availability

    We are delighted to announce the general availability of Workload Analysis for SAP HANA. Workload Analysis for SAP HANA provides a granular breakdown of SAP HANA metrics with easy drill-down for isolating problems quickly. It delivers valuable real-time and historical data to tune SQL statements. Its dashboard displays trending database activity and top resource utilization to identify problems and develop resolutions...
    • 16 Dec 2016

    How Do You Create a Disaster Recovery Plan?

    Get 2017 on a healthy start and participate in our January #SQLChat! Our next Twitter Chat will take place Wednesday, January 11th at 11 AM CT with Rie Irish ( @IrishSQL ). Rie will be leading a discussion on how to create your own disaster recovery plan. Having a plan to recover your business when disaster strikes is very important. This #SQLChat will help you learn how to build this plan by defining what a disaster...
    • 15 Dec 2016

    Annoying T-SQL Script error "Incorrect syntax near ' '."

    I'm hoping you'll find this post useful as finally got my issue solved but kept me going in circle. As I'm use to integrate my T-SQL scripts into my PowerShell scripts, but first I need to verify that everything is working as expected. Well, I ended up getting this annoying error every time I executed a valid SQL script: " Msg 102, Level 15, State 1, Line 4 Incorrect syntax near ' '. "...
    • 14 Dec 2016

    DB2 Monitoring and Optimization - Index Recommendations & Modeling

    This blog post explores a strategy for improving processing efficiency within IBM’s DB2 on LUW. The Precise product line is designed for monitoring and improvement. An idle database has static resource consumption and little contention. As resources are consumed, shortages develop resulting in waits, locks, contention, sub-optimal performance, and a ringing phone with users complaining. By tracking SQL statements...
    • 13 Dec 2016

    Golden Nugget : Naming Standards Templates

    Howdy! Today we will be exploring a feature called Naming Standards Template. In a Naming Standards Template you can define standards for character case, or add prefixes/suffixes to make the object types more easily recognizable. The Naming Standards Templates is comprised of an abbreviation list used to automatically convert logical to physical names and vice versa, and options for a given model that define case...
    • 2 Dec 2016

    Flashback to the Rescue

    Face it, we’ve all been there – that moment when we’ve done something a wee bit too fast and then realize we probably shouldn’t have done it. Then we often generally say something like “stupid database” or “stupid TOAD’ or “stupid whatever. But there are ways to recover without having to go hat in hand to the DBA and beg forgiveness and obtain a recovery. More recent...
    • 2 Dec 2016

    Normalization in Non-Gobbledygook Language

    Probably one of the most often discussed and hotly debated topics in both data modeling and database design is that of normalization. Many database designers, architects, DBA’s and senior developers have differing positions and/or beliefs on the topic. However quite unfortunately, they often are not communicating with optimal effectiveness due to some fundamental differences in terminology and understanding. The...
    • 1 Dec 2016

    Follow us on Twitter and Win!

    Hippie ducks are here for a limited time only! Do you follow us on Twitter ( @Idera_Software )? The first 100 people to follow us on Twitter in January will receive a free, limited-edition Hippie Duck! Please fill out this form to receive your Hippie Duck: Duck Form The IDERA Twitter Handle is a free resource for industry news, product updates, IDERA contests, networking, duck pictures and more. Follow us to start...
    • 29 Nov 2016

    Celebrate IDERA’s 12 Days of Giveaways!

    Happy Holidays from the IDERA Software team! Want to score this season’s hottest gifts? Celebrate the holidays with IDERA’s 12 Days of Giveaways! To participate, follow us on Twitter ( @Idera_Software ) and tell us what you want this Holiday Season by commenting in this blog below . One lucky winner will be announced every day! Giveaway gifts include a Kindle Paperwhite, Southwest Airlines Gift Card...
    • 28 Nov 2016

    How to Build the Essential SQL Server Administration Tool Chest

    A well-equipped tool chest is essential for completing jobs around the home — everything from hanging a picture frame to putting together furniture or working on major home improvements. A tool chest often starts with a small investment and grows over time as needs change. That is why database professionals require a comprehensive range of software applications for database administration. For example, manage storage...
    • 27 Nov 2016

    Using Notepad++ to Execute Oracle SQL

    While there are many different graphical user interface tools for running SQL statements, sometimes all you really want and need is a smaller, focused and thus simpler tool for modest tasks – such as opening and running a basic SQL script. For those specific, lesser needs I often utilize the popular freeware editor Notepad++ . However it requires manual tweaking in order to have Notepad++ execute SQL statements...
    • 27 Nov 2016

    Virtualized Database Procrastination

    Servers everywhere are being virtualized. Yet many DBA’s are hesitant to embrace virtualized database servers. I’ve been mystified by this anomaly, so I’ve asked those opposed for their rationale. While there are numerous arguments against, basically two pervasive themes surface from amongst all the replies. First and foremost, DBA’s almost universally claim that their databases are “mission...
    • 27 Nov 2016

    Virtual Paranoia?

    Lately I’ve been seeing what I think might be an interesting yet disturbing new trend: whenever there’s a problem that initially seems unusual and/or unexplainable, it’s not uncommon to quickly question virtualization as a potential source of the issue. I fully understand that virtualization adds a new variable to the basic equation – and represents greater complexity due to more moving parts....
    • 24 Nov 2016

    Useful Virtual Box Virtual Machine Script

    Many DBA’s and developers are now routinely using Oracle Virtual Box virtual machines to simplify database research and even development. I am one of those people. I also use VMware’s Workstation too. Today I’m sharing my Windows FIX_VDI.BAT script for compacting and zipping up my Virtual Box VM’s. For example when I’ve got a VM exactly the way I like it and want to create a version to save...
    • 24 Nov 2016

    Useful VMware Virtual Machine Script

    Many DBA’s and developers are now routinely using VMware Workstation virtual machines to simplify database research and even development. I am one of those people. I also use Oracle’s Virtual Box too. Today I’m sharing my Windows FIX_VMDK.BAT script for fixing, defragging, compacting and zipping up my VMware VM’s. For example when I’ve got a VM exactly the way I like it and want to create...
    • 24 Nov 2016

    The Not So Simple DELETE

    The February issue of SQL Server Magazine (yes – much like Darth Vader I dabble on the dark side) had a very interesting article by Vic Newell titled “ 4 Ways to purge Non-Partitioned Data ”. The basic premise is that in an ideal world all tables would be partitioned such that mass deletions could be accomplished via truncate or drop partition commands. But since we don’t live in an ideal world...