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


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


Generate insert scripts from a result set of SQLserver table

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


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


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


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


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
    .fetch()) { // fetch() here


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

… 196 more words