Tags » SQL

ShoreTel Connect: SQL Injection Vulnerability

Version(s) Affected:

This issue affects all Connect builds from 21.70.2173.0 to 21.79.4313.0 but does not affect any ShoreTel 14.2 or earlier builds.

Problem Details:

ShoreTel have released a product bulletin (PB 16054) which details a problem with ShoreTel Connect builds… 63 more words

ShoreTel

How to login without password in phpMyAdmin

For this you have to made some changes in /etc/phpmyadmin/config.inc.php
so Open this in your editor. (There may be permission issue while writing into this file so open this with root user) 145 more words

Sql

Generate insert scripts from a result set of SQLserver table

Requirement:
We have a table called employee which contains two columns eno, esal. The table contains ten records.
We are supposed to create a similar table with the same values in other server/database. 200 more words

Software

sql expert (1Z0-047) reference Sheet

I put together a reference sheet that combines everything I thought as important from the materials I used… (I used a 6pt font because I thought everything was important). 50 more words

SQL Server: Monitoring Disk Space with FSUTIL command line utility

Table of Contents

Introduction

This article talks about one of SQL method to fetch the disk usage details and use of T-SQL in conjunction with invoking FSUTIL utility using SQL Windows Shell interface xp_cmdshell. 1,270 more words

SQL

A Day in the life of SQL Mirroring

This past week I have been working with a client to setup mirroring on a SQL 2014 instance. I realize mirroring is a deprecated feature; but many DBAs and companies still use it as a fail safe line of defense. 411 more words

SQL

A Hidden jOOQ Gem: Foreach Loop Over ResultQuery

A recent question on Stack Overflow about jOOQ caught my attention. The question essentially asked:

Why do both of these loops work?

// With fetch()
for (MyTableRecord rec : DSL
    .using(configuration)
    .selectFrom(MY_TABLE)
    .orderBy(MY_TABLE.COLUMN)
    .fetch()) { // fetch() here

    doThingsWithRecord(rec);
}

// Without fetch()
for (MyTableRecord rec : DSL
    .using(configuration)
    .selectFrom(MY_TABLE)
    .orderBy(MY_TABLE.COLUMN)) { // No fetch() here

    doThingsWithRecord(rec);
}
… 196 more words
Java