Discuss in the Community

Blogs

Craig Mullins
Follow /1 Apr 2015 at 8:20pm / IBM DB2

SQL Performance Basics: Part 3, Eliminating Predicates?

It is technically possible to learn how to write SQL statements without having an in-depth knowledge of the data. However, the better you know your data, the better your application performance will be. Let's look at a qimple example. By reducing...
28 0 /
sqlkris
Follow /1 Apr 2015 at 4:48pm / SQL Server

What is a Data Dictionary?

What is a Data Dictionary? In SQL Server the data dictionary is a set of database tables used to store information about a database’s definition.  The dictionary contains information about database objects such as tables, indexes, columns, datatypes...
47 0 /
Steven Feuerstein
Follow /1 Apr 2015 at 4:35pm / Oracle

PL/SQL Now Available for Microsoft Excel, MongoDB, Cassandra and VoltDB!

In a surprise announcement today, Oracle Corporation announced that the PL/SQL language, its (formerly) proprietary database programming language, would now be available as open source on Github . Simultaneously, Oracle Corporation announced that PL/SQL...
157 0 /
Steven Feuerstein
Follow /1 Apr 2015 at 2:27pm / Oracle

Lint Checkers for PL/SQL

Received this question today: " Is there a commercial tool available for scanning PL/SQL code and providing feedback on adherence to coding standards, like say in much the same way ‘lint’ works on C code? Do you sell such a product or know of anyone...
86 0 /
Derik Hammer
Follow /1 Apr 2015 at 2:00pm / SQL Server

Database Deployment Work Flow with SQL Server Data Tools (SSDT)

Happy April Fools Day everyone! I hope that you do not spend too much time reading completely false blog posts today. I, for one, promise that this post is not an April Fools Day joke. Feel free to read on without fear of frustration. Today I wanted...
52 0 /
Kenneth Fisher
Follow /1 Apr 2015 at 12:00pm / SQL Server

Microsoft buys the dictionary

It seems that Microsoft has finally gotten tired of all the jokes about the word “performant” or using “ask” as a noun. Microsoft has decided to put it’s money where it’s mouth is and has announced today that they have...
69 0 /
Michael J. Swart
Follow /1 Apr 2015 at 12:00pm / SQL Server

Some Tweets I Drew

Last week I asked for people to give me illustration ideas on twitter using the hashtag #SwartDrawsTweets . Thanks for everyone who gave me suggestions. Here are a few of them. The Stig Brent Ozar tweeted: @Jorriss @MJSwart Running Enterprise Edition...
56 0 /
Chris Webb
Follow /1 Apr 2015 at 11:30am / SQL Server

BI Survey 15

It’s BI Survey time again! BI Survey is the largest annual survey of BI users in the world, so if you want to share your feelings on Microsoft BI tools or whatever else you’re using then this is the opportunity to do it. As in the past, in return for...
61 0 /
Vinoth Nm
Follow /1 Apr 2015 at 10:51am / SQL Server

Create SQL Azure Database(PaaS)

Today we can see the step by step procedure to create SQL Azure database(PaaS),As mentioned in the previous couple of articles any Microsoft Cloud based service you need a Azure Subscriptio n ( http://azure.microsoft.com/en-us/pricing/ ); Select SQL database...
67 0 /
Iggy Fernandez
Follow /1 Apr 2015 at 1:00am / Oracle

OT: Oracle wants your votes

It used to be that if you had an enhancement suggestion for Oracle Database, you had to file an enhancement request in MOS and pray that the Oracle product management gods would hear your request someday. It is now possible to make your enhancement...
354 0 /
Kellyn PotVin
Follow /31 Mar 2015 at 7:36pm / Oracle

SQLd360 with the AWR Warehouse

Mauro decided to give me another challenge-  run SQLd360 against the AWR Warehouse and let him know how it does straight “out of the box”.  It’s a simpler installation process than SQLTXPLAIN, you simply unzip and run, (no installation...
84 0 /
Kellyn PotVin
Follow /31 Mar 2015 at 5:48pm / Oracle

SQLTXPLAIN and the AWR Warehouse- Part II

I finally have a moment to look into my “hacked” SQLT XPRECT/XTRACT runs and see if the changes I made were enough to run properly with the AWR Warehouse. The answer is yes and no… and maybe “it depends”… The Results...
83 0 /
khanine
Follow /31 Mar 2015 at 3:41pm / Oracle

The Internet of Everything

The Internet of Things (IoT) has become one of the most popular buzzwords for IT companies. Businesses want to carve their own niches within this new space, and they are vying for the maximum number of customers. The IoT has become so popular throughout...
88 0 /
Iggy Fernandez
Follow /31 Mar 2015 at 1:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 37: POISED: A problem-solving method

Previous installment: The sisters of the mother of all SQL antipatterns First installment: DON’T PANIC P.O.I.S.E.D. is the acronym I invented for the performance tuning method described by Chris Lawson in The Art and Science of Oracle Performance...
260 0 /
Iggy Fernandez
Follow /31 Mar 2015 at 1:00pm / Oracle

OT: Never buy an Oracle book again (if you live in California)

If you are a resident of California, you are entitled to become a member of the San Jose Public Library (register at https://catalog.sjlibrary.org/selfreg/public ). Library members have access to Safari Books Online and Books24x7 . At last count, there...
396 0 /
Thomas LaRock
Follow /31 Mar 2015 at 11:31am / SQL Server

Presenting This Week: Enterprise Data World

This week I will be attending Enterprise Data World in Washington, DC. I’m excited to have been given the opportunity to present not one but TWO sessions at the premiere data management conference in the world. On Wednesday, April 1st, I will be...
89 0 /
regbac
Follow /31 Mar 2015 at 6:10am / SQL Server

Extending SSIS With .NET scripting

Earlier this year I got embarked on a book project together with Joost Van Rossum ( B | T ) , a dutch fellow MVP. A book about a subject that has always been very dear to me and crucial to the success of my work as an ETL developer. Namely how to extend...
93 0 /
Dan Hotka
Follow /30 Mar 2015 at 7:02pm / Oracle

SQL Scripting continued with SQL creating SQL

Hi! Lets continue with SQL scripting with something that Oracle has always been good at: SQL creating SQL. With SQL*Plus’s (and now TOAD and SQL Developer) ability to open a file, the output from a SQL statement can be formatted SQL. ...
136 0 /
David Fitzjarrell
Follow /30 Mar 2015 at 3:33pm / Oracle

Sound Advice

"There is much worth noticing that often escapes the eye." - Norton Juster, The Phantom Tollbooth Oracle has provided views to assist in managing the SGA and PGA settings when you’re not using Automatic Memory Management (AMM) and...
91 0 /
Chris Yates
Follow /30 Mar 2015 at 2:00pm / SQL Server

Backups – They Are Needed, Who Knew?

Backups are essential for a successful business model. That statement may or may spark some topics for debate, but at the end of the day if the data professional does not have a form of backup in place for his/her business needs you may, no you will,...
109 0 /
Kenneth Fisher
Follow /30 Mar 2015 at 1:00pm / SQL Server

Port numbers and SQL Server

I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are shocked, but it does happen on rare occasions. So what was I wrong about you might ask? One of the dev groups I support has been referring to their instances as...
114 0 /
Chris Webb
Follow /30 Mar 2015 at 1:00pm / SQL Server

NaturalInnerJoin And NaturalLeftOuterJoin DAX Functions In Excel 2016

Continuing my series on new DAX functions in Excel 2016, here are two more: NaturalInnerJoin() and NaturalLeftOuterJoin(). Both do pretty much what you’d expect. Consider the following two tables in an Excel worksheet, called ColourFruit and FruitPrice...
98 0 /
Sten Vesterli
Follow /30 Mar 2015 at 8:36am / Oracle

Database Innovation Forum - lots of good questions and answers

If you missed the online Database Innovation Forum with Tom Kyte and others on March 18th, it is now available on demand here: https://event.on24.com/eventRegistration/EventLobbyServlet?target=registration.jsp&eventid=940750&sessionid=1&key...
169 0 /
Mark Broadbent
Follow /30 Mar 2015 at 7:52am / SQL Server

How to install SharePoint 2013 on Windows 2012R2

If you want to jump straight to the condensed solution, then please feel free to go to the Condensed Installation instructions below. If you find this post useful or have any feedback then please leave me a comment so that I know my efforts were not wasted...
105 0 /
Ayman El-Ghazali
Follow /29 Mar 2015 at 1:16pm / SQL Server

SQL Server 2014 BI دورة تمهيدية شاملة في

الزملاء الأعزاء من العالم! السلام عليكم و رحمه الله و بركاته أقدم لكم دورة تمهيدية شاملة في SQL Server 2014 BI. وتقدم هذه الدورة التدريبية باللغة العربية، وتهدف إلى المساعدة فى التقديم للمفاهيم الأساسية للمهنيين المتخصصين فى قواعد البيانات عامه وبخاصه...
137 0 /