SQL Server Interview: How to prevent ‘SELECT *’ using T-SQL Script?

7 More

SQL Server Interview: A Golden question, Can we disable the Clustered Index?

6 More

A Day in the life of a DBA !

10 More

NoSQL: The latest buzzword in Data Science, What is NoSQL? (Day 1)

2 More

Database Research & Development

  • Home
  • NoSQL
    • NoSQL
    • Cassandra
  • Databases
    • Database Theory
    • Database Designing
    • SQL Server Coding Standards
    • SQL Server
    • PostgreSQL
    • MySQL
    • Greenplum
    • Linux
  • Interviews
    • SQL Server Interviews
    • MySQL Interviews
    • SQL Puzzles
  • DBA Scripts
    • SQL Server DBA Scripts
    • PostgreSQL DBA Scripts
    • MySQL DBA Scripts
    • Greenplum DBA Scripts
  • Home
  • Blog Archives !
  • (: Laugh@dbrnd :)
  • Contact Me !
sqlserverinterviews

SQL Server: Encrypt Password using HASHBYTES function

In this post, I am sharing the use of HASHBYTE() function in SQL Server. I am late for sharing this because HASHBYTE is not a new feature. Recently, one developer asked few questions on TDE for specific column encryption. I suggested him to use HASHBYTE() and got to know that I didn’t share anything about […]

October 1, 2018 SQL Server
September 24, 2018

SQL Server: Generate the DROP Script for Table, Function, Stored Procedure, Schema

September 17, 2018

MySQL: Script to check the size of Database and Tables

 
September 10, 2018

SQL Server: How to create Read Only Table?

September 3, 2018

PostgreSQL: Script to find all Objects of a Particular User

August 27, 2018

PostgreSQL: How to get the list of all Schemas of a database in PSQL?

August 20, 2018

PostgreSQL: How to get the list of all privileges of a database in PSQL?

August 13, 2018

PostgreSQL: How to get the list of all tables and all databases in PSQL?

August 6, 2018

MySQL: How to Swap Table or Rename the table in one transaction?

July 30, 2018

MySQL: Script to find all the Tables without having a Primary Key

Page 1 of 10212345...102030...»Last »
Follow Me !
  • Facebook
  • Linkedlin
  • Twitter
  • Google
  • Youtube
  • Flickr
MySQL !
Find any text into Stored Procedure and Function of MySQL
MySQL: Script to identify the locks and blocking transactions
Insert-Update, Merge statement in MySQL
MySQL: Using SQL Query Profiler finds total execution time and CPU information of the Queries
MySQL: ERROR 1130: Host is not allowed to connect to this MySQL server
MySQL: Copy Database From One Server to Another Server (Using mysqldump)
MySQL: UDF to SELECT value from a Comma Separated String at any position
PostgreSQL !
PostgreSQL: Change or Move Default Data Directory in Windows
How to reset postgres user password in windows ?
PostgreSQL: Performance difference between VARCHAR and VARCHAR(n)
PostgreSQL: ERROR – data type character varying has no default operator class for access method “gist”
PostgreSQL: Shell script to store psql result in RECORD ARRAY using WHILE LOOP
PostgreSQL: How to Install PostgreSQL 9.6 on Ubuntu 16.04?
PostgreSQL: Find a list of active Temp tables with Size and User information
Email Subscription !
Please subscribe for daily Update...
About Me!

I'm Anvesh Patel, a Database Engineer certified by Oracle and IBM. I'm working as a Database Architect, Database Optimizer, Database Administrator, Database Developer. Providing the best articles and solutions for different problems in the best manner through my blogs is my passion. I have more than six years of experience with various RDBMS products like MSSQL Server, PostgreSQL, MySQL, Greenplum and currently learning and doing research on BIGData and NoSQL technology. -- Hyderabad, India.

About DBRND !

dbrnd

This is a personal blog (www.dbrnd.com).

Any views or opinions represented in this blog are personal and belong solely to the blog owner and do not represent those of people, institutions or organizations that the owner may or may not be associated with in professional or personal capacity, unless explicitly stated.

Feel free to challenge me, disagree with me, or tell me I’m completely nuts in the comments section of each blog entry, but I reserve the right to delete any comment for any reason whatsoever (abusive, profane, rude, or anonymous comments) - so keep it polite.

The content of this website is protected by copyright. No portion of this website may be copied or replicated in any form without the written consent of the website owner.

Recent Comments !
  • Ankush { Select * from ( Select rw, case when (mod(rw,2) 0 OR rw= 2) AND (mod(rw,3) 0 OR rw = 3) AND (mod(rw,5) 0 OR rw = 5) AND mod(rw,9) 0 AND mod(rw,11) 0 THEN 'Prime' ELSE 'Not Prime' END as Number_Status FROM (Select Rownum as rw From dual Connect By... } – Sep 17, 11:26 AM
  • Ankush { Select rwn, CASE WHEN mod(rwn,3) =0 AND mod(rwn,5) =0 THEN 'UpDown' WHEN mod(rwn,3) = 0 then 'Up' WHEN mod(rwn,5) = 0 then 'Down' ELSE to_char(rwn) END from (Select rownum as rwn from dual connect by rownum <=100) } – Sep 14, 12:33 PM
  • Ankush { Select power(2, power) from ( Select 0 as power from dual Union Select Rownum r From dual Connect By Rownum <= 10) foo } – Sep 14, 11:58 AM
  • Ankush { Select sum(col1) as col1, sum(col2) as col2 from (Select distinct coalesce(col1,0)as col1 ,coalesce(col2,0)as col2 from ( Select 10 as col1, NULL as col2 from dual UNION Select NULL as col1, 20 as col2 from dual)foo) Situation would be different when there are no numbers but characters!! } – Sep 14, 9:45 AM
  • Ankush { Select * from ( Select count(*) as cnt, num as val from table_1 group by num order by cnt desc) where rownum = 1 } – Sep 14, 9:10 AM
  • Ankush { SELECT COALESCE(foo.num+foo1.num, foo.num, foo1.num), foo.code From table_1 foo Left join table_2 foo1 on foo.code = foo1.code } – Sep 14, 8:41 AM
  • Ankush { Select max(diff) from (Select num, rownum, num-rownum as diff from table) } – Sep 14, 8:27 AM
  • Older »
Follow Me !
  • facebook
  • linkedin
  • twitter
  • youtube
  • google
  • flickr
© 2015 – 2018 All rights reserved. Database Research & Development (dbrnd.com)