Discuss in the Community

Blogs

Chris Webb
Follow /19 Apr 2014 at 9:00am / SQL Server

Web Services And POST Requests In Power Query

In my recent post on web services in Power Query I mentioned that while the Power Query Web.Contents() function generates a GET request by default, you can make it generate a POST request by specifying the Content option. Since this is a useful thing...
16 0 /
Kellyn PotVin
Follow /18 Apr 2014 at 7:57pm / Oracle

REPVFY Diagnostics, Part I of…Well, A Zillion

Tweet There are a number of Verification Utilities for Enterprise Manager 12c, (EM12c) and I’ve written about them before, but today I’m going to start on the Repository Verification Utility, (REPVFY).  This will be an ongoing series, as there are so...
16 0 /
Jason Strate
Follow /18 Apr 2014 at 5:00pm / SQL Server

Reblog: April 11 to April 17

Photo credit – Travis Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time to dig out some old posts and find out if there are any undiscovered finds there. In this post, I’m bringing...
26 0 /
Tracy McKibben
Follow /18 Apr 2014 at 1:00pm / SQL Server

Friday Followup For April 18, 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 Why So Serious? – #TSQL2sDAY #53 Do You Need...
30 0 /
Dinesh Asanka
Follow /18 Apr 2014 at 4:50am / SQL Server

By the Numbers: The VAR - Big Data Market Opportunity

If you've been following the trends, you already know that Big Data can be very good for your business . But do you know just how good it can be? Let's take a look at some numbers, courtesy of the analysts. Read more at here http://dbfriend.blogspot...
40 0 /
Natik Ameen
Follow /18 Apr 2014 at 2:20am / Oracle

Migrating a Database to an Exadata Machine

We have been migrating our databases from the non-Exadata servers to the Exadata Database Machine using the “RMAN 11g Duplicate standby from Active database” command, to create the standby databases on the Exadata machine. Below are the steps which were...
25 0 /
James Serra
Follow /17 Apr 2014 at 6:36pm / SQL Server

What is the Microsoft Analytics Platform System (APS)?

Analytics Platform System (APS) is simply a renaming of the Parallel Data Warehouse (PDW).   It is not really a new product, but rather a name change due to a new feature in Appliance Update 1 (AU1) of PDW.  That new feature is the ability to have a HDInsigh...
58 0 /
David Dye
Follow /17 Apr 2014 at 6:06pm / SQL Server

SQL Saturday Puerto Rico 2014

WHAT AN AWESOME EVENT!! I want to thank everyone for such an incredible experience and special thanks to Jose Rivera, Guillermo Caicedo and all the volunteers for all of your work. Can’t wait for next year! As promised my presentation materials can...
31 0 /
Josh Howard
Follow /17 Apr 2014 at 4:23pm / Toad for Oracle

Vote for Toad / Dell Products in DBTA Readers’ Choice Awards Poll

Voting is now open for the Database Trends and Applications (DBTA) Readers Choice Awards! Several Toad and Dell Software products are nominated in many categories including: Best Database Administration Tool - Dell Toad Best Database Development...
19 0 /
Josh Howard
Follow /17 Apr 2014 at 4:08pm / Toad Data Point

Vote for Toad in the DBTA Reader's Choice Awards!

Voting is now open for the Database Trends and Applications (DBTA) Readers Choice Awards! Several Dell Software products are nominated in many categories, including Toad Data Point in best Query & Reporting Tool and Toad Business Intelligence Suite...
8 0 /
SQLDBAPros
Follow /17 Apr 2014 at 1:56pm / SQL Server

Hey Native Tools – What Have You Done for Me Lately?

When it comes to backup and recovery, industry veterans know that for years Microsoft has provided a very capable, out-of-the-box tool, already built into SQL Server. However, these same veterans have also figured out that with this solution, comes limitations...
158 0 /
Vaclav Frolik
Follow /17 Apr 2014 at 10:46am / Toad Data Modeler

Relationship Lines in Toad Data Modeler

Toad Data Modeler version 5.2 introduced new system of relationship lines. The new system contains various enhancements and new features. Improvements and New Features See a short list of available actions: Move lines or part of lines Move...
17 0 /
Gethyn Ellis
Follow /17 Apr 2014 at 9:00am / SQL Server

SSMS Auto Recovery

By David Postlethwaite At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover. SQL Server Management Studio will autosave your unsaved query...
52 0 /
Jen Stirrup
Follow /17 Apr 2014 at 9:00am / SQL Server

Why I refused a session at SQLBits; it's not about your rank, but your legacy

In martial arts it is not your belt rank that matters but the legacy you leave.” – Grandmaster CK Leow, Founder, Moodukkwan Malaysia I've attended every SQLBits except two: the first one, because I didn't know about it, and SQLBits 6, because...
50 0 /
Tom LaRock
Follow /17 Apr 2014 at 2:00am / SQL Server

You’re Doing It Wrong – Database Standards

Having standards is important. If you don’t believe me, just ask your spouse or significant other. Knowing that such things are important I am willing to wager that your company has spent time putting together a set of standards to be followed with...
58 0 /
Kellyn PotVin
Follow /16 Apr 2014 at 7:42pm / Oracle

EM12c Utilizing After Hours Notification Schedule- Part II

Tweet Now that we learned in Part I how to create a notification schedule for a specified user so that it will only page one individual on an oncall rotation, I’ll now show you how to use this in conjunction with rulesets to complete the process...
18 0 /
Kenneth Fisher
Follow /16 Apr 2014 at 1:00pm / SQL Server

Who is an expert?

Recently Paul Randal had a brief rant on twitter where he complained about the fact that there are no stupid questions which lead to a discussion on and how experts should and should not react to said questions. I’ve been thinking about what makes...
66 0 /
Gethyn Ellis
Follow /16 Apr 2014 at 9:00am / SQL Server

From where does SSMS get its database defaults?

We can create a database simply by typing in the command create database DB1 We don’t have to provide any other parameters for SSMS to be able to create the database My Question is from where does SQL get the default values when we create a database without...
55 0 /
Ryan Adams
Follow /15 Apr 2014 at 9:30pm / SQL Server

Central Management Server White Paper

Below is a link to a white paper I wrote on Central Management Server.  This white paper is an excellent guide for those who have never used it before.  It walks you through how to use CMS from beginning to end.  Here is what you can expect to learn:...
72 0 /
WaterOx
Follow /15 Apr 2014 at 6:20pm / SQL Server

Why a Boot Camp?

As a some of you may already know, I am now offering SQL Server boot camps with the first one being this July in Washington DC. Over the last couple of weeks since I announced this I’ve had a few questions as to why I am offering a boot camp and more...
67 0 /
James Serra
Follow /15 Apr 2014 at 4:00pm / SQL Server

Parallel Data Warehouse (PDW) AU1 released

Microsoft’s PDW has seen a big boost in visibility and sales over the past year, and part of the reason is due to frequent upgrades to the hardware and software.  About every six months there is an appliance update, which is sort of like a service...
79 0 /
Ayman El-Ghazali
Follow /15 Apr 2014 at 1:55pm / SQL Server

[SQL Snacks Video] SQL Server Table Partitioning 102

Welcome back for part 2 of my SQL Snack Pack on Table Partitioning! If you have not watched the first video, I would highly encourage you to do so. In this second video I will discuss the following: Creating a new Range in our Partition for new data ...
83 0 /
sqlbischmidt
Follow /15 Apr 2014 at 12:31pm / SQL Server

Save an Excel table as a SharePoint List

Quick post today, but really handy. I recently had a list of values that I needed to save as a list on a SharePoint BI site. The good news is that this is much easier than I originally thought to accomplish. To demonstrate, I’ll start by opening up...
64 0 /
Rohit Garg
Follow /15 Apr 2014 at 10:33am / SQL Server

SQL Server 2000 || Disable sa login

Question : How to disable sa user in SQL Server 2000? Reason : Due to Security requirement of audit, We have to disable sa user for all SQL instances in environment having SQL 2000 \2005\2008 & 2008 R2. Answer : We can disable sa user from SQL...
48 0 /
SteveHood79
Follow /15 Apr 2014 at 9:00am / SQL Server

Optional Parameters Causing Index Scans

Optional parameters in a stored procedure often lead to scans in the execution plan, reading through the entire table, even if it’s obvious that the right index is in place. This is extremely common in procs that are used behind search screens where...
59 0 /