Discuss in the Community


Follow /29 Jul 2014 at 9:14pm / SQL Server

Tuesday Tips: Three Performance Objectives for Increased Proactivity

Take a minute and think about your typical day, which of course is much longer than nine to five. Of time spent on database management, whether in the office or remotely, how much is dedicated to proactive performance management versus reacting to performance...
11 0 /
Iggy Fernandez
Follow /29 Jul 2014 at 3:57pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 14: Damn the Cost, Full Speed Ahead

“Money is our madness, our vast collective madness. And of course, if the multitude is mad the individual carries his own grain of insanity around with him. I doubt if any man living hands out a pound note without a pang; and a real tremor, if he...
74 0 /
Pradeep Adiga
Follow /29 Jul 2014 at 3:45pm / SQL Server

SQL Server Agent failing to start with the error “StartServiceCtrlDispatcher failed (error 6)”

Recently I worked on an issue where SQL Server Agent was failing to start. Before this there was some problems with the disks on the server and the databases were restored from backups. I started looking for errors in few of the logs System Event...
30 0 /
Ricardo Leka
Follow /29 Jul 2014 at 2:11pm / SQL Server

Testar Porta

Vocês sabem que se quiser testar uma porta TCP um dos métodos mais simples é basicamente um telnet Nome/IP porta. Se o prompt sumir e o cursor ficar piscando a porta está respondendo (claro,, tirando todas as implicações de liberação de firewall e blá...
23 0 /
Follow /29 Jul 2014 at 1:33pm / SQL Server

Get Ready to Learn SQL: 13. Introduction to Inner Joins

Note:  This is the second in a series of articles covering joins. The series starts with the article Introduction to Database Joins .  All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database...
8 0 /
Rohit Garg
Follow /29 Jul 2014 at 10:22am / SQL Server

Rename or Change SQL Server Standalone Named Instance

Today, We will go through with the steps of renaming or changing SQL Server Standalone Named Instance. Renaming or Changing SQL Server Standalone Named Instance is almost same as SQL Server Standalone Default Instance. You can change a SQL server named...
41 0 /
Sten Vesterli
Follow /29 Jul 2014 at 8:23am / Oracle

Save $23,000 per CPU on your next license audit

As you have probably noticed, Oracle has released the database which includes the much-anticipated in-memory database option. So far, so good. Unfortunately, the in-memory option is enabled by default and Oracle expert Kevin Closson has...
128 0 /
Dinesh Asanka
Follow /28 Jul 2014 at 6:53pm / SQL Server

Report SQL Server Percentage Backup Completion and Time Completion

When executing a backup from a t-sql command, it is difficult to know what percentage has completed and when the backup will be complete. This FAQ tells how to do it. http://dbfriend.blogspot.com/feeds/posts/default?alt=rss
51 0 /
Shaun Stuart
Follow /28 Jul 2014 at 2:00pm / SQL Server

Fixing Broken SSRS Subscriptions

SQL Server Reporting Services provides functionality to automatically generate a report on a recurring basis. These reports can then be emailed or written to a file. The method for doing this is called a subscription. It's common for a developer to...
44 0 /
Kenneth Fisher
Follow /28 Jul 2014 at 1:00pm / SQL Server

What is ANSI_NULLS and why will I be glad when it finally goes away?

Recently I wrote about what it means that a value is NULL . Right at the beginning I mentioned ANSI_NULLS and said I would discuss it later. Well it’s later. In the previous post I discussed how NULL is basically “unknown”. And any...
38 0 /
Basit A. Farooq
Follow /28 Jul 2014 at 11:21am / SQL Server

Book: SQL Server 2014 Development Essentials

I am very happy to announce that my first book “ SQL Server 2014 Development Essentials ” has now been published by Packt Publishing . SQL Server 2014 Development Essentials, ISBN: 9781782172550 SQL Server 2014 Development Essentials is...
33 0 /
Chris Webb
Follow /28 Jul 2014 at 10:00am / SQL Server

Calculating The Value Of Overdue Invoices Using Many-To-Many Relationships in SSAS Multidimensional

Recently I had to solve the same, rather complex, problem for three different customers within the space of two weeks, a variation of the ‘events-in-progress’ problem I’ve blogged about a lot in the past. It’s this one: how can you calculate the value...
29 0 /
Aris Prassinos
Follow /28 Jul 2014 at 7:26am / Oracle

Storing images in Oracle NoSQL

Whether to store binary data in a relational database or on a filesystem is one of those religious questions that frequently comes up. These days the question that more often comes up is whether to store binaries inside a relational database or in...
39 0 /
Follow /28 Jul 2014 at 12:49am / Oracle

Understanding Optimizer Statistics and Keeping Them Simple - Part 1

I've been speaking and writing about optimizer statistics for many years, but it seems like everywhere I go - be it a speaking engagement or a client site - I'm always asked about gathering statistics and how they are used. So, I thought I'd...
64 1 /
Iggy Fernandez
Follow /27 Jul 2014 at 9:53am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 13: The Great Pretender

Oh-oh, yes I'm the great pretender Pretending that I'm doing well My need is such, I pretend too much I'm lonely but no one can tell Yes, I'm the great pretender Just laughin' and gay like a clown I seem to be what I'm not, you...
236 2 /
Rohit Garg
Follow /27 Jul 2014 at 6:39am / SQL Server

Cumulative Update – 1 for SQL Server 2012 Service Pack 2 Is Now Available !

The 1st cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 1 contains all the hotfixes released since the initial release of SQL Server 2012 SP2. Those who are...
45 0 /
Follow /25 Jul 2014 at 6:35pm / NoSQL

Clear Skies: How Cloud Computing Helps the Environment

Lots of people these days are doing their part to live a “greener” lifestyle. There’s certainly an effort to use more sustainable forms of energy as a way to protect the environment, and businesses in general are no different. It just...
28 0 /
Craig Mullins
Follow /25 Jul 2014 at 5:47pm / IBM DB2

Happy DBA Day!

Hey everybody, time to celebrate... today, July 25, 2014 is SysAdmin day! For the past 15 years, the last Friday in June has been set aside to recognize the hard work done by System Administrators. This is known as System Administrator Appreciation Day...
78 0 /
Jason Strate
Follow /25 Jul 2014 at 5:00pm / SQL Server

Reblog: July 18 to July 24

Photo credit – Husso I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need to solve a problem or answer a question. It’s that whole “cha-ching” – buried...
55 0 /
Deiby Gomez
Follow /25 Jul 2014 at 3:10pm / Oracle

Oracle RAC 12c: Password file

En versiones anteriores a 12c, teníamos el inconveniente de que cuando actualizábamos un usuario con "SYSDBA" en un nodo de nuestro ambiente RAC, dichas actualizaciones eran reflejadas inmediatamente en el password file del nodo...
293 0 /
Tracy McKibben
Follow /25 Jul 2014 at 1:00pm / SQL Server

Friday Followup For July 25, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway. Posts That Were Popular This Week Don’t Get Slimed By Bad Parameter Sniffing...
148 0 /
Follow /25 Jul 2014 at 1:45am / SQL Server

Cumulative Updates – SQL Server 2012 SP2 CU1

As part of their Incremental Service Modelling , Microsoft have released SQL Server 2012 Service Pack 2 Cumulative Update 1! In my article about SQL Server 2012 SP2 I shared a post about a bug that was not fixed in SQL 2012 SP2 which was in earlier...
181 0 /
Kellyn PotVin
Follow /24 Jul 2014 at 9:09pm / Oracle

AWR Warehouse, Status

So the AWR Warehouse patches are out, but documentation has not officially caught up to it yet, so as we appreciate your patience.  I thought I would post about what I went over in my webinar last week when I had the wonderful opportunity to speak to...
159 0 /
Deiby Gomez
Follow /24 Jul 2014 at 9:05am / Oracle

How to Know which Hub Node is used by a Leaf Node?

by Deiby Gómez After to read a lot of pages of Oracle Database 12c Documentation, Oracle Database 12c: HA New Features Student Guide and a RAC 12c Book I have found a lot of theory about Flex ASM and Flex Cluster which are two main new features...
256 2 /
Iggy Fernandez
Follow /24 Jul 2014 at 12:39am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 12: Throw Away that Execution Plan

Here's a little song I wrote You might want to sing it note for note: Don't worry, be happy. In every life we have some trouble; When you worry you make it double. Don't worry, be happy. —Don’t Worry Be Happy by Bobby McFerrin...
382 0 /