Discuss in the Community


Vaclav Frolik
Follow /4 Sep 2015 at 11:19am / Toad Data Modeler

Creating or Updating Models from Excel Files

Microsoft Excel is a powerful tool. I think I can say it excels in many areas, but... can it be used for database modeling? Yes and No. As you probably know, Toad Data Modeler introduced support for import and export to Microsoft Excel in version 5...
0 0 /
Dan Hotka
Follow /4 Sep 2015 at 12:08am / Oracle

SQL Tuning- lessons learned from a lifetime in Explain Plans (part 11)

Hi! OK, we have been discussing cardinality and the importance of order in the Explain Plan. I have shown you newer syntax (and tools that runs said syntax) that shows actual row counts (cardinality) per line of explain plan. I’ve beat round...
97 0 /
Follow /3 Sep 2015 at 11:52pm / NoSQL

Big Data Obstacles Faced by Developing Nations

Fully utilizing big data and making the most of its potential is no easy task. Even among the most technologically advanced organizations, proper use of big data analytics can be a challenge, so it’s easy to see how the enormous difficulties faced...
71 0 /
Brad Wulf
Follow /3 Sep 2015 at 4:17pm / Toad for Hadoop - Blog

Toad for Hadoop Charts Perspective (Pre - BETA)

Toad for Hadoop Charts Perspective (BETA) NOTE: This functionality is pre release, but should be available in time for Hadoop World , enjoy! What follows is a detailed walkthrough of the newly added features, let us know if this is helpful and what...
335 0 /
Follow /3 Sep 2015 at 1:19pm / Oracle

ORA-00845: MEMORY_TARGET not supported on this system

SQL> alter system set memory_max_target=2GB scope=spfile; System altered. SQL> alter system set memory_target=2GB scope=spfile; System altered. SQL> startup ; ORA-00845: MEMORY_TARGET not supported on this system Check the following Space :-...
93 0 /
Vinoth Nm
Follow /3 Sep 2015 at 10:54am / SQL Server

Update - PowerShell Script for SQL Server Cluster/Stand Alone unattended Install and Uninstall - SQL 2014/SQL 2016 Support Added

For a long time I have been using different scripts for SQL Server install based on the various user requirements, with my latest client requirement I decided to create a master script for unattended install either in Clustered environment or as Standalone...
109 0 /
Kellyn PotVin
Follow /2 Sep 2015 at 9:48pm / Oracle

Updating the Raspberry Pi Vbox Image

So one of the things I like to do is test out a lot of my python gaming code, (as far as for the coding and syntax) on my Oracle Virtualbox image of my Raspberry Pi .  Another great thing about building games on the Raspberry Pi, is a built in module...
41 0 /
Denny Cherry
Follow /2 Sep 2015 at 7:39pm / SQL Server

PASS Summit 2015 1st Timers Webcast is Next Week

Just a reminder, that if you are planning on attending the PASS Summit this year you’ll want to make sure to get registered for my 1st timers webcast which is scheduled for September 7th. 2015 at 1pm Pacific Time. I know it’s a holiday here...
48 0 /
Steven Feuerstein
Follow /2 Sep 2015 at 4:28pm / Oracle

Zero tolerance for out-of-scope references!

I received this question last week: Hi Steven, Here is a question that I have been pondering for sometime and haven't found a definitive answer to. Perhaps you can shed some light. When writing a procedure in PL/SQL, I pass it all the variables that...
111 0 /
Ed Elliott
Follow /2 Sep 2015 at 4:16pm / SQL Server

We can do professional SQL Server deployments using SSDT

Really excited by my first post on medium, haven't really used it before but found it to be a really nice tool: https://medium.com/@edelliott.the.agilesql.club/let-s-start-doing-profes... Tags: Sql Server SSDT Medium
147 0 /
Follow /2 Sep 2015 at 3:45pm / SQL Server

Checking for Excessive Permissions in SQL Server - WaterOx Consulting

Reading Time: 2 minutes Who can do what? One of the key things that a DBA... The post Checking for Excessive Permissions in SQL Server appeared first on WaterOx Consulting .
61 0 /
Kenneth Fisher
Follow /2 Sep 2015 at 1:00pm / SQL Server

Learning Regular Expressions

I’m a regular watcher of the Midnight DBA Webshow and one day they mentioned regular expressions. Not a new term for me, but not something I’d ever looked at much. Well as it happens I had something that I needed to use it on a day or two...
190 0 /
Vaclav Frolik
Follow /2 Sep 2015 at 9:35am / Toad Data Modeler

How to Display and Format Links to Referenced Objects

Workspaces in Toad Data Modeler can be used for splitting Entity Relationship Diagrams (ERD) to smaller parts. In case your model is large, it is always recommended to use workspaces to limit the amount of visualized items. When you create a new model...
28 0 /
Chris Webb
Follow /1 Sep 2015 at 4:23pm / SQL Server

Excel 2016 BI Branding Changes

Office 2016 is on the verge of being released, and although Power BI is the cool new thing Excel 2016 has added several new BI-related features too. What is also interesting – and less well publicised – is that several of the BI features in Excel 2016...
134 0 /
Jason Brimhall
Follow /1 Sep 2015 at 1:21pm / SQL Server

Shredding Extended Event Actions

The other day I wrote about that torrid love/hate relationship DBAs tend to have with working with XML. In that same post, I promised I would have a follow up post about XML in Extended Events. Well, today I present to you another opportunity for you...
127 0 /
Jen McCown
Follow /1 Sep 2015 at 1:00pm / SQL Server

Time for T-SQL Tuesday #70!

Here is your invitation for T-SQL Tuesday #70, and the topic is: Strategies for managing an enterprise We define “enterprise” in a number of ways, but I tend to default to two definitions: “the things I’m in charge of” and...
119 0 /
Vaclav Frolik
Follow /1 Sep 2015 at 9:35am / Toad Data Modeler

Synchronization and Mapping of Renamed Table Columns

Toad Data Modeler contains many powerful synchronization features, incl. model comparison, model merge and generation of change scripts. In addition to the complex features, there is another possibility how to quickly compare selected object with database...
95 0 /
Kellyn PotVin
Follow /31 Aug 2015 at 7:21pm / Oracle

Raspberry Pi Controlled Airplane Launcher

Everything I do with the Raspberry Pi is about finding ways to incorporate STEAM, (Science, Technology, Engineering, Art and Math) into my projects.  This is no easy feat, but I have a lot of fun while I try.  This latest project, we’re still working...
126 0 /
Follow /31 Aug 2015 at 5:24pm / SQL Server

Populating My DBA Database for Power Bi with PowerShell – Server Info

Following my last post about using Power Bi with my DBA Database I have been asked if I would share the PowerShell scripts which I use to populate my database. They are the secondary part to my DBADatabase which I also use to automate the installation...
243 0 /
Sten Vesterli
Follow /31 Aug 2015 at 4:59pm / Oracle

Less Power to the DBA

Oracle has nice security features that allow you to run very secure systems, but few people are willing to pay extra for security. That's why we end up with data breaches like the Ashley Madison intrusion and confidential information about 21 million...
155 0 /
Michael J. Swart
Follow /31 Aug 2015 at 1:00pm / SQL Server

Avoid Frequent use of TVPs With Wide Rows

Tackling A Hairy Problem This series includes a number of stand-alone posts which can fit together to tell a bigger story Part One: Types of Performance Metrics Part Two: What’s Going On Inside Tempdb? Part Three: Avoid Frequent use of TVPs...
153 0 /
Kenneth Fisher
Follow /31 Aug 2015 at 1:00pm / SQL Server

The default instance has a name

The default instance actually has an instance name. It’s MSSQLSERVER. This is probably familiar to a lot of you but hold on because I’m going to go a little bit deeper. When we connect to a default instance we typically just put down the server...
149 0 /
Fernando Garcia
Follow /29 Aug 2015 at 3:29pm / Oracle

Cómo corroborar expresiones de calendario

Cuando necesitamos ejecutar tareas repetitivas en nuestra base de datos Oracle, podemos utilizar el planificador de tareas interno implementado por Oracle mediante el paquete DBMS_SCHEDULER. Para especificar cuándo ejecutar las tareas repetitivas...
143 0 /
Kellyn PotVin
Follow /29 Aug 2015 at 1:05am / Oracle

Creating a Trace File from EM12

Creating a trace file from EM12c is quite easy and doesn’t require a DBA offering up the world to allow a developer or support person to perform this action. Enterprise Manager also removes some of the syntax options that could get a developer...
181 0 /
Steven Feuerstein
Follow /28 Aug 2015 at 9:05pm / Oracle

Optimizing PL/SQL Panel at Oracle Open World 2015 - Questions welcome!

At Oracle Open World 2014, I was a member of a panel on SQL and PL/SQL Performance. It was an awful lot of fun, but as I had expected, most of the questions focused on SQL performance, and most of them were answered by Tom Kyte (no complaints from me...
306 0 /