Discuss in the Community - Toad World

Discuss in the Community


Chris Webb
Follow /11 Feb 2016 at 6:53pm / SQL Server

Rendering Text On A Map With Power Query And Power Map

They say a good magician never reveals his tricks. Luckily, I’m a rubbish magician and so (at the request of Jason Thomas and David Eldersveld ) I can reveal the secret behind one of the magic tricks I used in my sessions at SQLBits and the PASS Summit...
95 0 /
Follow /11 Feb 2016 at 5:00pm / IBM DB2

How Toad Makes You More Productive Than IBM Data Studio

Many DBAs who work on IBM DB2 often use IBM’s Data Studio for their day to day administration tasks. In fact, Data Studio is a fine tool for your average administration workload. But if you are like most DBAs who are finding themselves bogged down...
211 0 /
Michael J. Swart
Follow /11 Feb 2016 at 4:37pm / SQL Server

Ugly Pragmatism For The Win

Yesterday I had my mind changed about the best way to do concurrency. I describe several methods in Mythbusting: Concurrent Update/Insert Solutions . My preferred method is to increase the isolation level and fine tune locks. At least that was my preference...
45 0 /
Derik Hammer
Follow /11 Feb 2016 at 1:00pm / SQL Server

Availability Group Architecture – FCI hybrid

Last time, I discussed how to meet high-availability (HA) and disaster recovery (DR) using four stand-alone SQL Server instances in an Availability Group. In this post, I will add SQL Server Failover Cluster Instances to the mix and cut the number of...
40 0 /
Follow /11 Feb 2016 at 12:33pm / SQL Server

Text Mining Loch Ness Monster Sightings

Text Mining with RapidMiner for Loch Ness Monster Sightings Text mining involves pulling root words from text in a system.  In this example, I pulled all of the Loch Ness Monster sightings from 2000 to 2015 from the Official Loch Ness Monster Website...
101 0 /
Follow /10 Feb 2016 at 5:00pm / IBM DB2

3 DB2 Critical Design Factors for Big Data Analytics Scalability

Faster, bigger, and better analytical insights. These are the goals that management lays out as the new big data analytics process is talked about during the startup meetings. Looking around the room and listening to the CIO’s comments it becomes abundantly...
52 0 /
Chris Yates
Follow /10 Feb 2016 at 2:30pm / SQL Server

Leadership and the Data Professional

Many traits make up data professionals and the many who find themselves in leadership roles. The traits being shared in this blog post are ones that have helped me on my journey not just in a leadership role, but from a data professional perspective as...
252 0 /
Kenneth Fisher
Follow /10 Feb 2016 at 2:00pm / SQL Server

Changing to simple recovery to clear the log.

Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries and blog posts. Because of that I’m not going to talk about the correct methods of dealing with a transaction log full error. What I want...
62 0 /
Craig Mullins
Follow /10 Feb 2016 at 12:00pm / IBM DB2

The Most Misunderstood Features of DB2 – Part 3: Nulls

Welcome to Part 3 in my on-going blog series on The Most Misunderstood Features of DB2. You can find the first two parts here: Part 1 (on locking) and Part 2 (OPTIMIZE FOR v. FETCH FIRST). Today’s topic is one that confuses many SQL developers, Nulls...
44 0 /
Thomas LaRock
Follow /9 Feb 2016 at 6:20pm / SQL Server

Migrating Data From a TDE Enabled SQL Server Database Without a Key

But our database has TDE enabled, shouldn’t our data at rest in the BACPAC be protected? Nope. The post Migrating Data From a TDE Enabled SQL Server Database Without a Key appeared first on Thomas LaRock . If you liked this post then consider subscribing...
83 0 /
Fernando Garcia
Follow /9 Feb 2016 at 5:26pm / Oracle

El Datawarehouse, el OLTP, y las técnicas de modelado.

Un entorno de Datawarehousing habilita la posibilidad de obtener información de negocio valiosa a partir de datos alojados en bases de datos transaccionales. Pero la transformación de un dato transaccional puro en información de negocio...
98 0 /
Jen Stirrup
Follow /9 Feb 2016 at 4:07pm / SQL Server

Azure Architect Workshop in India – I’m presenting!

I’m over the moon to announce that, courtesy of Tech Mahindra and Microsoft, I’ll be participating and teaching in the three-day Azure Architect course in India this February – twice! It’s not just me – there is a whole team from Tech Mahindra and...
73 0 /
Marlon Ribunal
Follow /9 Feb 2016 at 2:29pm / SQL Server

How Much Hospitals Charge For The Same Type Of Cases?

How much hospitals charge for the same type of cases compared with the average across the US and other cities around the world (limited data)? The data used in this analysis may be old but it does give us a hint of how much more or less hospitals are...
79 0 /
Gethyn Ellis
Follow /9 Feb 2016 at 1:00pm / SQL Server

Spring Training: Developing SQL Queries for SQL Server

Just a short post for a Tuesday to let you that I will delivering Learning Tree’s 534 Developing SQL Queries for SQL Server course in Learning Tree’s London Education Centre. It’s a four day course starting on Tuesday 19th April and will complete on Friday...
71 0 /
Follow /9 Feb 2016 at 12:00pm / IBM DB2

Transferring a DB2 LUW Fixpack Directly to a UNIX, Linux, or Windows Server

This seems to change every few years, so I thought I’d document what’s working for me today. The Problem It used to be so easy to get DB2 fixpacks from IBM at the command line. It has gotten steadily more difficult over the years. At one...
39 0 /
Kellyn PotVin
Follow /8 Feb 2016 at 8:42pm / Oracle

EM13c Upgrade Tips- Part II

There is a flurry of excitement about Enterprise Manager 13c and I’m blown away by how many customers are looking not just to install and test out the new release, but have plans already underway to upgrade to it.  At Oracle, we’re covering...
75 0 /
Chris Webb
Follow /8 Feb 2016 at 8:28pm / SQL Server

Disabling Excel PivotTable Grouping And Session Cubes In SSAS Multidimensional

The Excel PivotTable grouping functionality that is available when you are connected to an SSAS Multidimensional cube (but not a Tabular model ) is a Very Bad Thing indeed. In my experience it is a major cause of query performance problems – not just...
84 0 /
Denny Cherry
Follow /8 Feb 2016 at 7:40pm / SQL Server

Would you like Microsoft to pay for you to move to Azure?

Have you been wanting to move some of your services up to Azure , but you don’t have the budget to move them up to th e cloud? Microsoft has an excellent deal for you. Microsoft will pay for (at least part) of the consulting time needed to get you...
76 0 /
Dan Hotka
Follow /8 Feb 2016 at 3:32pm / Oracle

Write your own hints

Ever have a need to do something with the library cache where it would be just plain convenient if the SQL always hard parsed? I’ve discussed the issues with bind variables. In recent articles and blogs, I’ve discussed Oracle’s work...
128 0 /
Dan Hotka
Follow /8 Feb 2016 at 3:29pm / Oracle

User Groups in your Area

Hi! Do you regularly attend user groups? Do you know if one is in your area? Do a little research… Many user groups, such as the Dallas OUG…meet once a month in the evenings. Many user groups such as the Twin Cities and the Heartland...
135 0 /
Gethyn Ellis
Follow /8 Feb 2016 at 3:00pm / SQL Server

Introduction to SQL Server: The Main Components

There has been much talk recently in the SQL Server community about writing introductory level blog posts. Posts that a new person just starting a career as a data professional using Microsoft's SQL Server data platform could use to learn all about...
159 0 /
Kenneth Fisher
Follow /8 Feb 2016 at 2:00pm / SQL Server

Impersonation can give you the wrong answer

I use impersonation all the time to let me see additional permissions information I can only get that way and, sometimes to help me see what permissions error someone is getting. For those of you who aren’t aware, with the right permissions you...
79 0 /
Jorge Segarra
Follow /8 Feb 2016 at 1:30pm / SQL Server

T-SQL Tuesday #75 Invitation: Jump into Power BI!

Hello everyone and welcome to this month’s T-SQL Tuesday. This month’s topic is all about Power BI ! If you’re reading this and thinking “crap, I’m not a BI person!”, don’t you fret. My intention is to make folks...
147 0 /
Steve Hood
Follow /8 Feb 2016 at 12:00pm / SQL Server

Database Log VLFs

Virtual Log Files (VLFs) split a physical database log file into smaller segments, which are required for how log files work in the background.  These are created automatically, but automatically doesn’t always mean perfect.  Here’s a practical...
85 0 /
Nakul Vachhrajani
Follow /8 Feb 2016 at 3:30am / SQL Server

#0373 – SQL Server – Interview Questions – Parameters required for server-side paging mechanisms

For a mid-level SQL developer profile, this is one of my favourite interview questions if their current projects involve some sort of paging mechanism while displaying results on a grid. What is the minimum number of parameters that your stored procedure...
140 0 /