Discuss in the Community


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...
14 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...
93 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...
110 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...
118 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...
96 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...
95 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...
107 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...
154 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...
217 0 /
Ricardo Leka
Follow /28 Aug 2015 at 8:27pm / SQL Server

Event Notification para kill

Algum tempo atras fiz um post sobre Event Notification para monitorar DeadLock o que funciona muito bem,,, Com um pouco de modificação o mesmo código pode ser utilizado para muitas outras coisas,,, por exemplo: limitar acesso a uma instância bloqueando...
253 0 /
Follow /28 Aug 2015 at 2:30pm / SQL Server

017 – Thinking Like A Manager - WaterOx Consulting

Reading Time: 2 minutes Thinking Like A Manager In WOxPod!, episode # 017 – “Thinking Like... The post 017 – Thinking Like A Manager appeared first on WaterOx Consulting .
260 0 /
Iggy Fernandez
Follow /28 Aug 2015 at 1:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 39: Unfriending the optimizer statistics

Previous installment: Shakespeare’s advice for database upgrades First installment: DON’T PANIC “Heigh-ho, sing heigh-ho, unto the green holly. Most friendship is feigning, most loving mere folly. Then heigh-ho, the holly. This life...
751 0 /
Fernando Garcia
Follow /27 Aug 2015 at 10:41pm / Oracle

Ejemplos de uso de expresiones de calendario

En este artículo veremos ejemplos de uso concreto de expresiones de calendario. Este es el cuarto artículo de una serie dedicada al planificador de tareas interno de Oracle. Te recomiendo leer los artículos anteriores: Oracle...
128 0 /
Dan Hotka
Follow /27 Aug 2015 at 8:14pm / Oracle

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

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...
152 0 /
Jen McCown
Follow /27 Aug 2015 at 6:22pm / SQL Server

I am not a “wogrammer”

So apparently the COO of Facebook is trying to make the word “wogrammer” – a woman programmer – a thing.  (Thanks to Vicky Harp for pointing out this infuriating thing.) I cannot stress how fundamentally opposed I am to this, new...
118 0 /
Marlon Ribunal
Follow /27 Aug 2015 at 4:30pm / SQL Server

Getting Started With Power BI Desktop: Simple Visualization

This is the third installment of our Getting Started With Power BI Desktop series. The first post is about installation and the second is about getting data . In this post, let’s see how easy it is to create visualization on Power BI Desktop. If...
182 0 /
Chris Yates
Follow /27 Aug 2015 at 2:39pm / SQL Server

SQLSat403 – Recap

The doors close, lights turn off, and cars begin to pull out of the parking lot. Another SQL Saturday event has come and gone, but this time it was different. The reason for this was from the hard work, effort, countless hours, and collaboration that...
172 0 /
Fernando Garcia
Follow /26 Aug 2015 at 9:49pm / Oracle

Como calendarizar tareas con DBMS_SCHEDULER

En los últimos dos artículos hemos estado conociendo el planificador de tareas interno de Oracle. Al crear una tarea es indispensable que indiquemos qué hacer y cuándo hacerlo. Como en general hablamos de tareas repetitivas...
142 0 /
Follow /26 Aug 2015 at 8:20pm / SQL Server

Use FILEPROPERTY to find free space in all the database

The use of SpaceUsed property of the FILEPROPERTY function gives how much space is used also we can derive lot of other attributes of it such as free space and percentage of free space. For other versions of SQL you can refer the below SQL. DECLARE...
181 0 /
Denny Cherry
Follow /26 Aug 2015 at 7:00pm / SQL Server

Connecting To SQL Server Running On An Azure VM

If you have setup a Windows Azure Virtual Machine running SQL Server you may have noticed that you might not be able to connect to the SQL Server running on the machine by using SQL Server Management Studio on your workstation (desktop, labtop, etc) from...
194 0 /
David Fitzjarrell
Follow /26 Aug 2015 at 5:11pm / Oracle

“But, You Don’t Understand…”

"Let me try once more," he said in an effort to explain. "In other words--" "You mean you have other words?" cried the bird happily. "Well, by all means, use them. You're certainly not doing very well with the...
150 0 /
Ben Thompson
Follow /26 Aug 2015 at 3:05pm / Oracle

Non-working logon trigger on Data Guard standby database

Today I did something very dumb when working with a vendor to trace and issue and rendered our Data Guard physical standby database unusable. I added an AFTER LOGON ON DATABASE trigger which collected information about a session and wrote it to a table...
66 0 /
Follow /26 Aug 2015 at 2:30pm / SQL Server

The Problem With AshleyMadison - WaterOx Consulting

Reading Time: 3 minutes What is the real problem with the AshleyMadison data breach? Well, let... The post The Problem With AshleyMadison appeared first on WaterOx Consulting .
134 0 /
Follow /26 Aug 2015 at 1:55pm / SQL Server

Agile Development – A DBA’s Initial Thoughts

I recently had the opportunity to attend a three day Agile development workshop.  At a very high level, Agile development values making small, iterative changes over short periods of time, unlike traditional software development methods that generally...
94 0 /
Jason Brimhall
Follow /26 Aug 2015 at 1:18pm / SQL Server

Shredding XML in XEvents

One of the biggest pains with Extended Events is the thing we love to hate – XML. XML is so foreign to many DBAs. It’s not relational and often brings nightmares of parsing and performance issues. Despite that, Extended Events takes advantage...
106 0 /