Expert Blogs - Toad World

Expert Blogs

Blogs

Michael J. Swart
Follow /27 Jul 2016 at 4:11pm / SQL Server Blog

Do you Use CLR in SQL Server?

We don’t use CLR assemblies in SQL Server. For us, programming in the database means that maybe “you’re doing it wrong”. But there have been rare circumstances where I’ve wondered about what the feature can do for us. For...
1 0 /
Kenneth Fisher
Follow /27 Jul 2016 at 1:00pm / SQL Server Blog

When was this database restored?

I frequently need to know where backups went and I restore those backups for operational recovery on a regular basis. Would you believe in 20+ years as a DBA I can count the number of database restores for a disaster on my fingers? (Which is good because...
30 0 /
DBAFromTheCold
Follow /27 Jul 2016 at 12:13pm / SQL Server Blog

Bug fixes in SQL Server

SQL Server 2016 CU1 has been released and one thing I noticed was: – FIX: Canceling a backup task crashes SQL Server 2014 or 2016 That’s pretty nasty, when I originally clicked on the link I was expecting to see detailed a pretty precise...
23 0 /
Clarisa Maman Orfali
Follow /27 Jul 2016 at 3:05am / Oracle Blog

A sólo días de mi viaje al OTN Tour México 2016

Estamos casi en la recta final y preparándome para mi viaje a México. La agenda está lista y disponible en el siguiente link: Agenda OTN Tour México Estaré presentando un conferencia de 45 minutos referente al...
49 0 /
Clarisa Maman Orfali
Follow /27 Jul 2016 at 2:43am / Oracle Blog

Cursor activo en el cuadro de búsqueda del Informe Interactivo

Hace unos días me hicieron la siguiente consulta, cómo se puede colocar el cursor del mouse en el cuadro de búsqueda del Informe Interactivo cuando ingresamos a la página y considero que si bien es simple puede ser algo muy...
36 0 /
Pinal Dave
Follow /27 Jul 2016 at 2:30am / SQL Server Blog

SQL SERVER 2016 – Learn Installation of SQL Server 2016 in 2 Minutes Video

Every time when new SQL Server version arrives, lots of people want to install it, however the biggest hesitance is the fear of unknown . Lots of people do not try out new software because they are worried what would happen if the installation does not...
47 0 /
Fernando Garcia
Follow /27 Jul 2016 at 12:42am / NoSQL Blog

Neo4j: Una base de datos orientada a grafos.

El cuadrante mágico de Gartner es un informe que publica el Grupo Gartner, una compañía de consultoría e investigación en el mercado de las tecnologías de información. El cuadrante mágico consiste...
45 0 /
prashanthjayaram
Follow /26 Jul 2016 at 9:52pm / SQL Server Blog

PowerSQL – Get SQL TraceFlag SQL Service and Config Information

Get SQL Server configuration, service info, start type along with enabled Trace Flags of local or remote servers. This script outputs sql server configuration, service, start type, Service Account along with startup trace flags. The script will work...
67 0 /
John Sterrett
Follow /26 Jul 2016 at 7:24pm / SQL Server Blog

Azure SQL Database Live Migrations

Unfortunately, with Azure SQL Database you are not able to take an existing SQL Server Backup and restore it on an Azure SQL Database server.  We are talking about Microsoft’s database as a service (DaaS)  offering, not Azure VMs also known as infrastructure...
16 0 /
Steven Feuerstein
Follow /26 Jul 2016 at 6:00pm / Oracle Blog

Watch out for redundant code with WHILE loops

Generally, you should use a simple loop if you always want the body of the loop to execute at least once. You use a WHILE loop if you want to check before executing the body the first time. Since the WHILE loop performs its check “up front,” the variables...
45 0 /
Chris Webb
Follow /26 Jul 2016 at 1:53pm / SQL Server Blog

Value.ResourceExpression() And Query Folding In Power BI

When the June update for Power BI Desktop was released, I was extremely excited to discover an undocumented new feature that allows you to see when query folding is taking place while loading data in the Query Editor. Devin Knight beat me to blogging...
11 0 /
Sten Vesterli
Follow /26 Jul 2016 at 11:43am / Oracle Blog

SQL Injection is Still Dangerous

I recently heard someone talk of SQL injection as "solved," and that is a dangerously arrogant attitude. It is true that experienced developers know what SQL injection is and how to prevent it (use bind variables, sanitize inputs), but that...
196 0 /
Brendan Tierney
Follow /26 Jul 2016 at 9:59am / Oracle Blog

Oracle Text, Oracle R Enterprise and Oracle Data Mining - Part 1

A project that I've been working on for a while now involves the use of Oracle Text, Oracle R Enterprise and Oracle Data Mining. Oracle Text comes with your Oracle Database licence. Oracle R Enterprise and Oracle Data Mining are part of the Oracle...
141 0 /
Deiby Gomez
Follow /26 Jul 2016 at 9:17am / Oracle Blog

Quick guide to use Transparent Data Encryption (TDE 12c)

In this article I will show you how to configure TDE quickly, directly to the steps that you are looking for. You can also see the quick guide to configure TDE in 11g HERE . We will go through the following steps: Configuring sqlnet.ora ...
276 0 /
Pinal Dave
Follow /26 Jul 2016 at 2:30am / SQL Server Blog

SQL SERVER – System Stored Procedures I Use to Get Started

Call me an old school or whatever – there are certain things I believe in strongly. I have a working style and these in my opinion have evolved over the years. I keep innovating myself as I learn on my way, but there are few things I do that always makes...
88 0 /
Clarisa Maman Orfali
Follow /25 Jul 2016 at 8:22pm / Oracle Blog

Creando una Región de tipo Árbol desde el Diseñador de Páginas en Oracle APEX 5.0

Un árbol se basa en una consulta SQL y devuelve los datos representados en una jerarquía. El formato de la consulta que debemos respetar es el siguiente: SELECT status, level, name, icon, id, tooltip, link FROM ... WHERE ......
38 0 /
Dan Hotka
Follow /25 Jul 2016 at 2:49pm / Oracle Blog

Oracle Explain Plan Review

Hi, Here is one from email…the original questions and my reply, my suggestions and why. I have a quick question about the rows on the IO tab of the Session Browser. I have a single SQL running that is doing a DELETE of about 1.8 million...
65 0 /
Kenneth Fisher
Follow /25 Jul 2016 at 2:00pm / SQL Server Blog

Blogger Questions: What should I blog about?

Over the last four years I’ve blogged almost 400 times. It’s become a refuge, a resource, a source of pride, and a pleasure. I started out trying to build an on-line resume (just in case) and over time it’s evolved like crazy. I’ve...
33 0 /
sqlkris
Follow /25 Jul 2016 at 12:00pm / SQL Server Blog

How to Study for the 70-461 Exam

Preparing for the 70-461 Exam In order to be successful studying for the 70-461 exam, you’ll need a good strategy and plan.  Before we get into how to study for the 70-461, I want to tell you a quick story. Back in 2002 I heard a piece on National...
35 0 /
Hemantgiri S. Goswami
Follow /25 Jul 2016 at 10:40am / SQL Server Blog

Learn About SQL Server Master Data Services 2016

SQL Server 2016 comes up with the new release of Master Data Services (MDS). In it, some new features have been added to improve its performance. It helps the database administrators to manage the database properly. In the following discussion, we will...
49 0 /
Deiby Gomez
Follow /25 Jul 2016 at 9:32am / Oracle Blog

Quick guide to use Transparent Data Encryption (TDE 11g)

Transparent Data Encryption (TDE) is designed to provide the ability to transparently apply encryption within the database without impacting our applications. TDE provides the benefit of encryption without the overhead associated with traditional database...
288 0 /
Deiby Gomez
Follow /25 Jul 2016 at 7:59am / Oracle Blog

How to schedule a procedure to run inside a period of time

How many of us have had to schedule a job to run inside an Oracle Database? I believe this is one of the most common task that a DBA performs. But, some time the request doesn't end there, how about if the job is longer that we think? how about if...
465 0 /
Nakul Vachhrajani
Follow /25 Jul 2016 at 4:30am / SQL Server Blog

#0378 – SQL Server – Performance – CASE evaluates all the input result expressions

Microsoft SQL Server will evaluate all the input result expressions of a CASE expression - causing performance issues when sub-queries access large tables.
89 0 /
Pinal Dave
Follow /25 Jul 2016 at 2:30am / SQL Server Blog

SQL SERVER Installation – FeatureUpgradeMatrixCheck (SQL Server 2016 Feature Upgrade) setup rule failed

One of the best ways to learn problems faced by individuals and organizations is to look at the forums for these issues. Often I have visited MSDN forums and see if there are some hot or interesting issues. Sometimes it is interesting to see some setup...
82 0 /
Chris Webb
Follow /24 Jul 2016 at 10:58pm / SQL Server Blog

Happy First Birthday Power BI!

To mark the first anniversary of Power BI reaching RTM, Paul Turley and Adam Saxton  have organised a celebration in the form of coordinated blog posts from the community and a video to say thank you to the Power BI team at Microsoft: This has been...
36 0 /