Blog - Post List
    • 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...
    • 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...
    • 24 Nov 2016

    The Physics of Data

    Sometimes information systems professionals can draw some very useful analogies from the hard sciences. For example physics offers us one very useful concept – the states of matter. Figure 1 shows an excellent diagram that I copied from Wikipedia explaining the four states of matter. Looking at these four states, I’m going to suggest that from a higher level there are really just two fundamental states...
    • 24 Nov 2016

    Data is an Asset

    Sometimes information systems professionals can get “caught up” in our own worlds. For example, project managers and their developers might focus on latest and greatest application development methodologies such as Extreme Programming (XP) or Agile Development. Likewise enterprise architects might be adopting some new or updated modeling conventions. While database administrators (DBA’s) are often engaged...
    • 24 Nov 2016

    Are Database GUI Tools Evil?

    There are always those DBA’s who refuse to use GUI tools because they prefer scripts. And that’s OK – it’s a personal preference. But recently I’ve seen some stuff posted on the web and sent in email blasts suggesting that people who do use DBA GUI tools like DBArtisan , SQL Developer and Oracle Enterprise Manager (OEM) are somehow suspect as to their skill levels. And yes, I am sure there...
    • 24 Nov 2016

    Benchmarking Oracle 12c IN MEMORY COLUMN STORE

    Oracle 12.1.0.2 debuted recently and I decided to benchmark the IN MEMORY COLUMN STORE feature. There’s been a lot of press and excitement about this feature, so I wanted to add something of value to that dialog. So this blog covers what I learned while running industry standard TPC-H data warehousing benchmark utilizing the IN MEMORY COLUMN STORE feature (plus some other 11g and 12c features). So what exactly...
    • 19 Nov 2016

    Will SQL Server 2016 Service Pack 1 (SP1) Up the Ante?

    Microsoft has just released SQL Server 2016 Service Pack 1 (SP1) . The release has created quite a stir because Microsoft has made a major licensing changes – most notably every edition of SQL Server now gets every feature. Quoting PC Week , the only time users will have to pay to upgrade to higher edition is for greater hardware limits such as maximum CPU socket/core counts and maximum RAM. All the latest and greatest...
    • 19 Nov 2016

    Database Benchmarking Tool Differences

    In my last blog titled “ Varying Database Benchmark Results ” I tried to explain why people can often get varied performance results when running a specific database benchmark multiple times. I attempted to explain the possible reasons from a purely mechanics viewpoint. In other words it’s quite often the user background, experience and approach that can play a very significant role. I also stressed...
    • 19 Nov 2016

    Varying Database Benchmark Results

    I’ve been asked on numerous occasions why do peoples' database benchmark results often vary. In other words why one observed transaction per second (TPS) value today and sometimes 20% or more off tomorrow. In short, why aren’t database benchmark results reliably repeatable? Often people try to blame the benchmarking software. That is the logical choice since that software runs the benchmark and scores...
    • 19 Nov 2016

    Quickly Master Database Benchmarking

    Database benchmarking can be a very useful skillset to add to your DBA repertoire. And like any other tool on your tool belt it has a specific purpose and type of job it’s designed for. Much as you would not utilize a screwdriver to pound in a nail, database benchmarking has specific use cases where it provides critical answers to technical questions which may have basis in the business’ IT strategy. Here...
    • 16 Nov 2016

    Introducing DB PowerStudio 2016+

    On October 26, 2016, IDERA announced the latest release of the DB PowerStudio family, which includes DBArtisan, Rapid SQL, DB Change Manager, and DB Optimizer. These 4 products together provide a comprehensive database administration, management, and performance suite for environments with multiple platforms. Bert Scalzo posted a blog to share the news . Key features of the DB PowerStudio 2016+ release include: DBArtisan...
    • 15 Nov 2016

    Explore PowerShell with Maximo Trinidad and WIN!

    Our December #SQLChat will take place Thursday, December 8 at 11 AM CT with Maximo Trinidad ( @MaxTrinidad ) . Maximo will lead a conversation on PowerShell, including resources to learn more about the language, personal experiences and more. This #SQLChat will allow members from the SQL community to discuss SQL Server’s biggest topics with IDERA product experts, and have a chance to win a giveaway prize. This...
    • 10 Nov 2016

    Announcing SQL Admin Toolset 1.9 Is Now Available

    We are pleased to announce the general availability of SQL Admin Toolset. Admin Toolset provides 24 tools that simplify day-to-day tasks for DBAs. Existing users may upgrade to this version through the Idera Customer Portal. New users may download the trial version from the Idera Website. This release includes the following features: What’s New in Admin Toolset 1.9? Support for SQL Server 2016 Provide full...
    • 7 Nov 2016

    Another successful year at PASS Summit 2016!

    What a week at PASS Summit 2016! There were more than 4,000 attendees at the event in Seattle, Washington. After leveling up with all of you at PASS, we have a lot to share about our week at the event! You can also relive our week at PASS with us through our Flickr album . This year, IDERA held our first ever pre-conference event. This day long training took place on Tuesday, before the official start of the show...
    • 1 Nov 2016

    Meet Your 2017 IDERA ACEs!

    We are excited to introduce our 2017 IDERA ACEs! This program helps active members of the SQL Server community share knowledge by sponsoring their travel for speaking engagements and networking opportunities to a variety of SQL Server conferences and events. Members are selected annually and are up-and-coming data professionals who wish to attain Microsoft MVP status. We are looking forward to what this class of ACEs...
    • 1 Nov 2016

    Win an Nintendo Entertainment System!

    Did you love getting to play Super Mario on our Nintendo Entertainment System during PASS? Could you not make it PASS and are sad you missed out on a game? Well our NES can be yours! Let us know your favorite PASS memory and the NES we used during PASS could be yours! How to enter: 1) Let us know your favorite PASS memory by commenting below. It does not have to be from 2016. 2) Follow us on Twitter . 3) At the...
    • 31 Oct 2016

    TOP IT HORROR STORIES AND HOW TO SURVIVE THEM

    Tis the season for spooks and spoils so to get in the spirit here is a cauldron of scary, strange and sometimes humorous tales gathered from the beyond to remind us that it can be a grave delight to get a scare every now and then, as long as you survive. Truth is often stranger than fiction as these examples will attest. Stay tuned at the end for some simple survival tactics. If you are so possessed, we dare you to...