Discuss in the Community

Blogs

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...
13 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...
28 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...
7 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
108 0 /
WaterOx
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 .
31 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...
103 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...
20 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...
108 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...
106 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...
93 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...
82 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...
110 0 /
SQLDBAWithABeard
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...
208 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...
132 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...
127 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...
123 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...
122 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...
164 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...
283 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...
269 0 /
WaterOx
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 .
287 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...
822 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...
141 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...
164 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...
134 0 /