• Home
  • SQL Server
    • Articles
    • T-SQL Puzzles
    • Output Puzzles
    • Interview Questions
    • Performance Tuning
    • SQL SERVER On Linux
    • Resources
  • SSRS
    • SSRS Articles
    • Interview Questions
  • SSAS
    • SSAS Articles
    • DAX
  • SQL Puzzles
  • Interview Questions
    • SQL Interview Questions
    • Data Interview Questions
  • New Features(SQL SERVER)
    • SQL SERVER 2017
    • SQL SERVER 2016
    • SQL SERVER On Linux
  • Social
    • Expert Exchange
      • Top Expert in SQL
      • Yearly Award
      • Certifications
      • Achievement List
      • Top Expert of the Week
    • HackerRank (SQL)
    • StackOverflow
    • About Me
      • Contact Me
      • Blog Rules

Improving my SQL BI Skills

Improving my SQL BI Skills

Tag Archives: SQL Server On Linux- Common Interview Questions and Answers

SQL Server 2017 on LINUX | Install sqlcmd and bcp the SQL Server command-line tools on Ubuntu

17 Tuesday Jul 2018

Posted by Pawan Kumar Khowal in SQL Concepts, SQL SERVER, SQL SERVER 2017 Linux, SQL Server Interview Questions

≈ Leave a comment

Tags

Advanced SQL Interview Questions and Answers, Buy SQL Server On Linux Interview Questions Book Online at Low Price, Download SQL Questions, Download SQL Server On Linux Interview Question in PDF, Download SQL Server On Linux Interview questions, Download SQL Server On Linux Interview questions and answers, download SQL Server On Linux interview questions and answers pdf, download SQL Server On Linux Interview questions by Pawan Khowal, download SQL Server On Linux Interview questions by Pawan Kumar, download SQL Server On Linux Interview questions by Pawan Kumar Khowal, Download T-SQL Interview Questions, Free Download SQL Server On Linux Interview questions, Improve SQL Skills, Interview Qs.SQL Server On LinuxQuestions, Interview questions and Answers for MS SQL Server On Linuxdesigning, Interview Questions and Answers For SQL, Interview questions on Joins, Interview Questions on SQL, InterviewQuestions, InterviewQuestions for SQL, Learn complex SQL, Learn SQL, Learn T-SQL, Microsoft SQL Server On Linux Interview questions for DBA, MS SQL Server On Linux Interview questions, MSBI Interview Questions, Objective Puzzle, Pawan, Pawan Khowal, Pawan Kumar, Pawan Kumar Khowal, PL/SQL Challenges, Puzzle SQL, puzzle sql developer, Puzzle SQl Server, Puzzles, PUzzles in SQL SERVER, Queries for SQL Interview, SQL Extreme Difficult Puzzle, SQL FAQ, SQL FAQs, sql group by only rows which are in sequence, SQL Interview Q & A, SQL Interview Questions, SQL Interview Questions - Part 2, SQL Interview Questions for SQL Professionals‎, SQL Queries, SQL Queries asked in interviews, SQL QUERY PUZZLES, SQL Questions, SQL Quiz, SQL Replace Puzzle, SQL Server On Linux Interview Puzzle, SQL Server On Linux Interview questions, SQL Server On Linux Interview questions & Answers, SQL Server On Linux Interview Questions - Part 1, SQL Server On Linux Interview questions and answers, SQL Server On Linux Interview Questions and Answers - Free PDF, SQL Server On Linux Interview questions and answers for experienced, SQL Server On Linux Interview questions and answers for net developers, SQL Server On Linux Interview Questions And Answers.pdf, SQL Server On Linux Interview questions by Pawan Khowal sql interview questions, SQL Server On Linux Interview questions pdf, SQL Server On Linux Interview Questions | MSBISKILLS.Com, SQL Server On Linux Interview Questions | MSBISKILLS.com Top 50 SQL Server On LinuxQuestions & Answers, SQL Server On Linux Interview Questions/Answers Part-1, SQL Server On Linux- Common Interview Questions and Answers, SQL Server On Linux- Find Nth Highest Salary of Employee, SQL Server On Linux- General Interview Questions and Answers, SQL Server On Linux2008 interview questions, SQL Server On Linux2008 Interview Questions and Answers, SQL Server On LinuxDatabase, SQL Server On Linuxdatabase developer interview questions and answers, SQL Server On Linuxdba interview questions, SQL Server On Linuxdeveloper Interview questions and answers, SQL Server On Linuxdeveloper Interview questions with answers, SQL Server On LinuxDeveloper T-SQL Interview Questions, SQL Server On Linuxfilter index with LIKE and RIGHT function?, SQL Server On LinuxPuzzle, SQL Server On LinuxPuzzles, SQL Server On LinuxQuestions and Answers, SQL Server On LinuxTips, SQL Skills, SQL Sudoku, SQL Tips & Tricks, SQL Tips and Tricks, SQL Top clause, SQL Tough Puzzle, SQL Tricks, SQL Trikcy question, sql/database interview for puzzle sql developer, SQLBI Interview Questions, SQLSERVER, SUM of grouped COUNT in SQL Query, T SQL Puzzles, T-SQL Challenge, T-SQL Interview Questions | SQL Server On Linux Interviews and Jobs, T-SQL Puzzle, T-SQL Server On Linux Interview Questions, T-SQL Tricky Puzzles, The Status Puzzle, Top 10 Frequently Asked SQL Query Interview Questions, TOP 100 SQL Server On Linux Interview QUESTIONS QUERIES, Top 50 SQL Server On Linux Interview Question for Testers, Tough SQL Challenges, Tough SQL Puzzles, Tricky Questions, TSQL, TSQL Challenge, TSQL Challenges, TSQL Interview questions, TSQL Puzzles, TSQL Queries


SQL Server 2017 on LINUX | Install sqlcmd and bcp the SQL Server command-line tools on Ubuntu

In this article we shall discuss about the installation of sqlcmd and bcp on Ubuntu 16.04.

The following steps install the command-line tools, Microsoft ODBC drivers, and their dependencies. The mssql-tools package contains following tools.

1. sqlcmd: Command-line query utility.
2. bcp: Bulk import-export utility.

Install tools on Ubuntu 16.04
We need to use the following steps to install the mssql-tools on Ubuntu.

Steps-

1. Import the public repository GPG keys.

	--

	curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

	--
	

2. Register the Microsoft Ubuntu repository.

	--

	curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list

	--
	

3. Update the sources list and run the installation command with the unixODBC developer package.

	--

	sudo apt-get update 
	sudo apt-get install mssql-tools unixodbc-dev

	--
	

4. Optional: Add /opt/mssql-tools/bin/ to your PATH environment variable in a bash shell.
To make sqlcmd/bcp accessible from the bash shell for login sessions, modify your PATH in the ~/.bash_profile file with the following command:

	--

	echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile

	--
	

References-

1 https://docs.microsoft.com/en-us/sql/sql-operations-studio/download
2 https://go.microsoft.com/fwlink/?linkid=875602
3 https://msbiskills.com/2018/01/19/2017-new-data-management-tool-for-sql-server-sql-operations-studio/
4 https://docs.microsoft.com/en-us/sql/sql-operations-studio/download?view=sql-server-2017
5 https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-linux-2017
6 https://msbiskills.com/2018/07/17/sql-server-2017-on-linux-installing-sql-server-on-ubuntu/

Other SQL SERVER on Linux related articles

1 https://msbiskills.com/2018/07/11/sql-server-2017-on-linux-faqs-microsoft/
2 https://msbiskills.com/2018/07/17/sql-server-2017-on-linux-how-to-install-sql-operations-studiosos-on-linuxubuntu/

Enjoy.

Thank you for reading.!!!

Pawan Khowal

Pawan is a SQL Server Developer. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go throgh the top pages from his blog.

Page Detail URL
☛ SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
☛ SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
☛ SQL Server Performance tuning Articles https://msbiskills.com/sql-performance-tuning/
☛ SQL Server Articles https://msbiskills.com/t-sql/
☛ SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com

Share this

  • Facebook
  • Twitter
  • WhatsApp
  • Email
  • LinkedIn
  • Skype
  • Reddit
  • Tumblr
  • Pinterest
  • Pocket
  • Telegram

SQL Server 2017 on LINUX | Installing SQL Server on Ubuntu

17 Tuesday Jul 2018

Posted by Pawan Kumar Khowal in SQL Concepts, SQL SERVER, SQL SERVER 2017 Linux

≈ Leave a comment

Tags

Advanced SQL Interview Questions and Answers, Buy SQL Server On Linux Interview Questions Book Online at Low Price, Download SQL Questions, Download SQL Server On Linux Interview Question in PDF, Download SQL Server On Linux Interview questions, Download SQL Server On Linux Interview questions and answers, download SQL Server On Linux interview questions and answers pdf, download SQL Server On Linux Interview questions by Pawan Khowal, download SQL Server On Linux Interview questions by Pawan Kumar, download SQL Server On Linux Interview questions by Pawan Kumar Khowal, Download T-SQL Interview Questions, Free Download SQL Server On Linux Interview questions, Improve SQL Skills, Interview Qs.SQL Server On LinuxQuestions, Interview questions and Answers for MS SQL Server On Linuxdesigning, Interview Questions and Answers For SQL, Interview questions on Joins, Interview Questions on SQL, InterviewQuestions, InterviewQuestions for SQL, Learn complex SQL, Learn SQL, Learn T-SQL, Microsoft SQL Server On Linux Interview questions for DBA, MS SQL Server On Linux Interview questions, MSBI Interview Questions, Objective Puzzle, Pawan, Pawan Khowal, Pawan Kumar, Pawan Kumar Khowal, PL/SQL Challenges, Puzzle SQL, puzzle sql developer, Puzzle SQl Server, Puzzles, PUzzles in SQL SERVER, Queries for SQL Interview, SQL Extreme Difficult Puzzle, SQL FAQ, SQL FAQs, sql group by only rows which are in sequence, SQL Interview Q & A, SQL Interview Questions, SQL Interview Questions - Part 2, SQL Interview Questions for SQL Professionals‎, SQL Queries, SQL Queries asked in interviews, SQL QUERY PUZZLES, SQL Questions, SQL Quiz, SQL Replace Puzzle, SQL Server On Linux Interview Puzzle, SQL Server On Linux Interview questions, SQL Server On Linux Interview questions & Answers, SQL Server On Linux Interview Questions - Part 1, SQL Server On Linux Interview questions and answers, SQL Server On Linux Interview Questions and Answers - Free PDF, SQL Server On Linux Interview questions and answers for experienced, SQL Server On Linux Interview questions and answers for net developers, SQL Server On Linux Interview Questions And Answers.pdf, SQL Server On Linux Interview questions by Pawan Khowal sql interview questions, SQL Server On Linux Interview questions pdf, SQL Server On Linux Interview Questions | MSBISKILLS.Com, SQL Server On Linux Interview Questions | MSBISKILLS.com Top 50 SQL Server On LinuxQuestions & Answers, SQL Server On Linux Interview Questions/Answers Part-1, SQL Server On Linux- Common Interview Questions and Answers, SQL Server On Linux- Find Nth Highest Salary of Employee, SQL Server On Linux- General Interview Questions and Answers, SQL Server On Linux2008 interview questions, SQL Server On Linux2008 Interview Questions and Answers, SQL Server On LinuxDatabase, SQL Server On Linuxdatabase developer interview questions and answers, SQL Server On Linuxdba interview questions, SQL Server On Linuxdeveloper Interview questions and answers, SQL Server On Linuxdeveloper Interview questions with answers, SQL Server On LinuxDeveloper T-SQL Interview Questions, SQL Server On Linuxfilter index with LIKE and RIGHT function?, SQL Server On LinuxPuzzle, SQL Server On LinuxPuzzles, SQL Server On LinuxQuestions and Answers, SQL Server On LinuxTips, SQL Skills, SQL Sudoku, SQL Tips & Tricks, SQL Tips and Tricks, SQL Top clause, SQL Tough Puzzle, SQL Tricks, SQL Trikcy question, sql/database interview for puzzle sql developer, SQLBI Interview Questions, SQLSERVER, SUM of grouped COUNT in SQL Query, T SQL Puzzles, T-SQL Challenge, T-SQL Interview Questions | SQL Server On Linux Interviews and Jobs, T-SQL Puzzle, T-SQL Server On Linux Interview Questions, T-SQL Tricky Puzzles, The Status Puzzle, Top 10 Frequently Asked SQL Query Interview Questions, TOP 100 SQL Server On Linux Interview QUESTIONS QUERIES, Top 50 SQL Server On Linux Interview Question for Testers, Tough SQL Challenges, Tough SQL Puzzles, Tricky Questions, TSQL, TSQL Challenge, TSQL Challenges, TSQL Interview questions, TSQL Puzzles, TSQL Queries


SQL Server 2017 on LINUX | Installing SQL Server on Ubuntu

In this article we shall discuss about the installation SQL Server 2017 on Ubuntu 16.04.

Note – To configure SQL Server on Ubuntu, run the following commands in a terminal to install the mssql-server package. If you have previously installed a CTP or RC release of SQL Server 2017, you must first remove the old repository before registering one of the GA repositories.

Steps-

1. Import the public repository GPG keys:

	--

	sudo wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

	--
	

2. Register the Microsoft SQL Server Ubuntu repository.

	--

	sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)"

	--
	

3. Run the following commands to install SQL Server.

	--

	sudo apt-get update
	sudo apt-get install -y mssql-server

	--
	

4. After the package installation finishes, run mssql-conf setup and follow the prompts to set the SA password and choose your edition.

	--

	sudo /opt/mssql/bin/mssql-conf setup	

	--
	

Notes-

1. You can choose editions from Evaluation, Developer, and Express.
2. Specify a strong password for the SA account – Minimum length 8 characters, including uppercase and lowercase letters, base 10 digits and/or non-alphanumeric symbols.

5. Once the configuration is done please verify that the service is running or not.

	--

	systemctl status mssql-server

	--
	

Note – If you plan to connect remotely, you might also need to open the SQL Server TCP port (default 1433) on your firewall.

References-

1 https://docs.microsoft.com/en-us/sql/sql-operations-studio/download
2 https://go.microsoft.com/fwlink/?linkid=875602
3 https://msbiskills.com/2018/01/19/2017-new-data-management-tool-for-sql-server-sql-operations-studio/
4 https://docs.microsoft.com/en-us/sql/sql-operations-studio/download?view=sql-server-2017
5 https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-linux-2017

Other SQL SERVER on Linux related articles

1 https://msbiskills.com/2018/07/11/sql-server-2017-on-linux-faqs-microsoft/
2 https://msbiskills.com/2018/07/17/sql-server-2017-on-linux-how-to-install-sql-operations-studiosos-on-linuxubuntu/

Enjoy.

Thank you for reading.!!!

Pawan Khowal

Pawan is a SQL Server Developer. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go throgh the top pages from his blog.

Page Detail URL
☛ SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
☛ SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
☛ SQL Server Performance tuning Articles https://msbiskills.com/sql-performance-tuning/
☛ SQL Server Articles https://msbiskills.com/t-sql/
☛ SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com

Share this

  • Facebook
  • Twitter
  • WhatsApp
  • Email
  • LinkedIn
  • Skype
  • Reddit
  • Tumblr
  • Pinterest
  • Pocket
  • Telegram

SQL Server 2017 on LINUX | How to install SQL Operations Studio(SOS) on LINUX(Ubuntu)

17 Tuesday Jul 2018

Posted by Pawan Kumar Khowal in Download SQL Interview Q's, SQL Concepts, SQL SERVER, SQL SERVER 2017 Linux, SQL Server Interview Questions

≈ 1 Comment

Tags

Advanced SQL Interview Questions and Answers, Buy SQL Server On Linux Interview Questions Book Online at Low Price, Download SQL Questions, Download SQL Server On Linux Interview Question in PDF, Download SQL Server On Linux Interview questions, Download SQL Server On Linux Interview questions and answers, download SQL Server On Linux interview questions and answers pdf, download SQL Server On Linux Interview questions by Pawan Khowal, download SQL Server On Linux Interview questions by Pawan Kumar, download SQL Server On Linux Interview questions by Pawan Kumar Khowal, Download T-SQL Interview Questions, Free Download SQL Server On Linux Interview questions, Improve SQL Skills, Interview Qs.SQL Server On LinuxQuestions, Interview questions and Answers for MS SQL Server On Linuxdesigning, Interview Questions and Answers For SQL, Interview questions on Joins, Interview Questions on SQL, InterviewQuestions, InterviewQuestions for SQL, Learn complex SQL, Learn SQL, Learn T-SQL, Microsoft SQL Server On Linux Interview questions for DBA, MS SQL Server On Linux Interview questions, MSBI Interview Questions, Objective Puzzle, Pawan, Pawan Khowal, Pawan Kumar, Pawan Kumar Khowal, PL/SQL Challenges, Puzzle SQL, puzzle sql developer, Puzzle SQl Server, Puzzles, PUzzles in SQL SERVER, Queries for SQL Interview, SQL Extreme Difficult Puzzle, SQL FAQ, SQL FAQs, sql group by only rows which are in sequence, SQL Interview Q & A, SQL Interview Questions, SQL Interview Questions - Part 2, SQL Interview Questions for SQL Professionals‎, SQL Queries, SQL Queries asked in interviews, SQL QUERY PUZZLES, SQL Questions, SQL Quiz, SQL Replace Puzzle, SQL Server On Linux Interview Puzzle, SQL Server On Linux Interview questions, SQL Server On Linux Interview questions & Answers, SQL Server On Linux Interview Questions - Part 1, SQL Server On Linux Interview questions and answers, SQL Server On Linux Interview Questions and Answers - Free PDF, SQL Server On Linux Interview questions and answers for experienced, SQL Server On Linux Interview questions and answers for net developers, SQL Server On Linux Interview Questions And Answers.pdf, SQL Server On Linux Interview questions by Pawan Khowal sql interview questions, SQL Server On Linux Interview questions pdf, SQL Server On Linux Interview Questions | MSBISKILLS.Com, SQL Server On Linux Interview Questions | MSBISKILLS.com Top 50 SQL Server On LinuxQuestions & Answers, SQL Server On Linux Interview Questions/Answers Part-1, SQL Server On Linux- Common Interview Questions and Answers, SQL Server On Linux- Find Nth Highest Salary of Employee, SQL Server On Linux- General Interview Questions and Answers, SQL Server On Linux2008 interview questions, SQL Server On Linux2008 Interview Questions and Answers, SQL Server On LinuxDatabase, SQL Server On Linuxdatabase developer interview questions and answers, SQL Server On Linuxdba interview questions, SQL Server On Linuxdeveloper Interview questions and answers, SQL Server On Linuxdeveloper Interview questions with answers, SQL Server On LinuxDeveloper T-SQL Interview Questions, SQL Server On Linuxfilter index with LIKE and RIGHT function?, SQL Server On LinuxPuzzle, SQL Server On LinuxPuzzles, SQL Server On LinuxQuestions and Answers, SQL Server On LinuxTips, SQL Skills, SQL Sudoku, SQL Tips & Tricks, SQL Tips and Tricks, SQL Top clause, SQL Tough Puzzle, SQL Tricks, SQL Trikcy question, sql/database interview for puzzle sql developer, SQLBI Interview Questions, SQLSERVER, SUM of grouped COUNT in SQL Query, T SQL Puzzles, T-SQL Challenge, T-SQL Interview Questions | SQL Server On Linux Interviews and Jobs, T-SQL Puzzle, T-SQL Server On Linux Interview Questions, T-SQL Tricky Puzzles, The Status Puzzle, Top 10 Frequently Asked SQL Query Interview Questions, TOP 100 SQL Server On Linux Interview QUESTIONS QUERIES, Top 50 SQL Server On Linux Interview Question for Testers, Tough SQL Challenges, Tough SQL Puzzles, Tricky Questions, TSQL, TSQL Challenge, TSQL Challenges, TSQL Interview questions, TSQL Puzzles, TSQL Queries


SQL Server 2017 on LINUX | How to install SQL Operations Studio(SOS) on LINUX(Ubuntu)

First lets us understand What is Ubuntu and SQL operations studio? Ubuntu is a free and open source operating system and Linux distribution based on Debian.
Ref – https://en.wikipedia.org/wiki/Ubuntu_(operating_system)

SQL Operations Studio is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. For more details please refer- https://msbiskills.com/2018/01/19/2017-new-data-management-tool-for-sql-server-sql-operations-studio/

In this post we shall check out the how to install SQL Operations Studio on Ubuntu.

Steps-

1. Open url – https://docs.microsoft.com/en-us/sql/sql-operations-studio/download?view=sql-server-2017

2. Go to – Get SQL Operations Studio (preview) for Linux -> Go to tar.gz Installation or find tar.gz Installation. Following code will be there.

3. Download SQL Operations Studio (preview) for Linux by using the tar.gz archive.

Download the SOS for Ubuntu

4.1 Go to terminal and execute the following command.

	--

	cd ~ 	

	--
	

4.2 Go to terminal and execute the following commands one by one.

	--

	cd ~ 
	cp ~/Downloads/sqlops-linux-<version string>.tar.gz ~ 
	tar -xvf ~/sqlops-linux-<version string>.tar.gz 
	echo 'export PATH="$PATH:~/sqlops-linux-x64"' >> ~/.bashrc
	source ~/.bashrc 

	--
	

4.3 Launch SQL Operations Studio using sqlops command via Terminal.

    Server Name: localhost
    Authentication Type: SQL Login
    User name: sa
    Password: sa password
    Database Name: default
    Server Group: default

Sample Script

--

CREATE TABLE Test
(
    Id INT
)
GO

INSERT INTO Test VALUES (1),(2)
GO

SELECT * FROM Test
GO

--

References-

1 https://docs.microsoft.com/en-us/sql/sql-operations-studio/download
2 https://go.microsoft.com/fwlink/?linkid=875602
3 https://msbiskills.com/2018/01/19/2017-new-data-management-tool-for-sql-server-sql-operations-studio/
4 https://docs.microsoft.com/en-us/sql/sql-operations-studio/download?view=sql-server-2017

Other SQL SERVER on Linux related articles

1 https://msbiskills.com/2018/07/11/sql-server-2017-on-linux-faqs-microsoft/

Enjoy.

Thank you for reading.!!!

Pawan Khowal

Pawan is a SQL Server Developer. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go throgh the top pages from his blog.

Page Detail URL
☛ SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
☛ SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
☛ SQL Server Performance tuning Articles https://msbiskills.com/sql-performance-tuning/
☛ SQL Server Articles https://msbiskills.com/t-sql/
☛ SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com

Share this

  • Facebook
  • Twitter
  • WhatsApp
  • Email
  • LinkedIn
  • Skype
  • Reddit
  • Tumblr
  • Pinterest
  • Pocket
  • Telegram

Blog Stats

  • 737,397 hits

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,113 other followers

Pawan Khowal

502 SQL Puzzles with answers

Achievement - 500 PuzzlesJuly 18th, 2018
The big day is here. Finally presented 500+ puzzles for SQL community.

200 SQL Server Puzzle with Answers

The Big DayAugust 19th, 2016
The big day is here. Completed 200 SQL Puzzles today

Archives

December 2019
M T W T F S S
« Sep    
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

Top Articles

  • pawankkmr.files.wordpress…
  • pawankkmr.files.wordpress…
  • pawankkmr.wordpress.com/2…
  • pawankkmr.files.wordpress…
  • pawankkmr.wordpress.com/2…

Archives

  • September 2018 (2)
  • August 2018 (6)
  • July 2018 (25)
  • June 2018 (22)
  • May 2018 (24)
  • April 2018 (33)
  • March 2018 (35)
  • February 2018 (53)
  • January 2018 (48)
  • December 2017 (32)
  • November 2017 (2)
  • October 2017 (20)
  • August 2017 (8)
  • June 2017 (2)
  • March 2017 (1)
  • February 2017 (18)
  • January 2017 (2)
  • December 2016 (5)
  • November 2016 (23)
  • October 2016 (2)
  • September 2016 (14)
  • August 2016 (6)
  • July 2016 (22)
  • June 2016 (27)
  • May 2016 (15)
  • April 2016 (7)
  • March 2016 (5)
  • February 2016 (7)
  • December 2015 (4)
  • October 2015 (23)
  • September 2015 (31)
  • August 2015 (14)
  • July 2015 (16)
  • June 2015 (29)
  • May 2015 (25)
  • April 2015 (44)
  • March 2015 (47)
  • November 2012 (1)
  • July 2012 (8)
  • September 2010 (26)
  • August 2010 (125)
  • July 2010 (2)

Article Categories

  • Analysis Services (6)
    • DAX (6)
  • Data (2)
    • Data warehousing (2)
  • Integration Services (2)
  • Magazines (3)
  • Reporting Services (4)
  • SQL SERVER (820)
    • Download SQL Interview Q's (212)
    • SQL Concepts (323)
    • SQL Performance Tuning (155)
    • SQL Puzzles (331)
    • SQL SERVER 2017 Linux (6)
    • SQL Server Interview Questions (308)
    • SQL SERVER Puzzles (332)
    • T SQL Puzzles (547)
    • Tricky SQL Queries (439)
  • UI (30)
    • ASP.NET (5)
    • C# (13)
    • CSS (9)
    • OOPS (3)
  • Uncategorized (5)

Recent Posts

  • Microsoft SQL Server 2019 | Features added to SQL Server on Linux September 26, 2018
  • SQL Puzzle | The Map Puzzle September 26, 2018
  • SQL OUTPUT PUZZLE | The Equal to puzzle August 17, 2018
  • SQL Puzzle | How to alter a column from null to not null August 14, 2018
  • Advanced SQL | Fill the Price for missing months August 13, 2018
  • SQL Puzzle | Multiple ways to add Date and Time to a DATETIME | SQL Interview Question August 10, 2018
  • SQL Puzzle | The Grouping Puzzle – A Single SELECT | SQL Interview Question August 7, 2018
  • SQL Puzzle | The Compare * 100 Puzzle | SQL Interview Question August 1, 2018
  • SQL Server Interview Questions & Answers – SET 22(10 Questions & Answers) July 30, 2018
  • SQL OUTPUT PUZZLE | The JOINs – How well do you know them ? | SQL Interview Question[Updated Answers] July 28, 2018
  • SQL OUTPUT PUZZLE | The IN & NOT IN – How well do you know them ? | SQL Interview Question July 28, 2018
  • SQL Puzzle | Count total occurrence of a character in all columns | SQL Interview Question July 28, 2018
  • SQL Puzzle | Ranking Puzzle – 1 | SQL Interview Question July 27, 2018
  • SQL Server on LINUX | Performance best practices and configuration guidelines July 26, 2018
  • SQL Server 2017 on LINUX FAQs – II – Microsoft July 25, 2018
  • SQL Puzzle | The Hierarchy Spacing Puzzle | SQL Interview Question July 22, 2018
  • SQL Server Question | Can we declare a variable/ define a column as INTEGER or DEC? July 21, 2018
  • Updated SQL Puzzle | The INNER JOIN – Two Rows PUZZLE | Solution without UNION/UNION All July 20, 2018
  • SQL Puzzle | The NOT in Range Puzzle – SINGLE SELECT | SQL Interview Question July 20, 2018
  • SQL Puzzle | The INNER JOIN – Two Rows PUZZLE | SQL Interview Question July 20, 2018
  • SQL Server | Have you ever gave length in the Float data type declaration? | SQL Interview Question July 19, 2018
  • SQL Puzzle | Remove trailing zeros puzzle – The DOUBLE PRECISION/FLOAT(53) data type | Advanced SQL July 19, 2018
  • SQL Puzzle | The SINGLE INSERT Puzzle / The Double INTO Puzzle | Advanced SQL July 18, 2018
  • SQL Puzzle | The JOIN Puzzle – A Single SELECT | SQL Interview Question July 18, 2018
  • SQL Server 2017 on LINUX | Install sqlcmd and bcp the SQL Server command-line tools on Ubuntu July 17, 2018
  • SQL Server 2017 on LINUX | Installing SQL Server on Ubuntu July 17, 2018
  • SQL Server 2017 on LINUX | How to install SQL Operations Studio(SOS) on LINUX(Ubuntu) July 17, 2018
  • SQL Puzzle | Multiple ways to convert datetime to date with 00:00:00.000 Time | SQL Interview Question July 16, 2018
  • SQL Puzzle | Have you ever used SELECT TOP 0 ? – Multiple ways to create a new table from existing | SQL Interview Question July 12, 2018
  • SQL Server 2017 on LINUX FAQs – Microsoft July 11, 2018

Create a website or blog at WordPress.com

Cancel
loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.