SQL Archives - Page 222 of 519 - SQL Authority with Pinal Dave

SQLAuthority News – Learn Fundamentals of MySQL Online – Pluralsight Course

May 1, 2013

SQL, SQL Server, SQL Tips and Tricks, SQL Video, SQLAuthority News

Here are few of the question I often receive – Do you know anything besides SQL Server? So how does it feel when the only thing which you know is SQL Server? Have you worked in the past with any other programming language? Actually, I find these questions very interesting…

SQL SERVER – UPDATE From SELECT Statement – Using JOIN in UPDATE Statement – Multiple Tables in Update Statement

April 30, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Joins

This is one of the most interesting questions I keep on getting on this email and I find that not everyone knows about it. In recent times I have seen a developer writing a cursor to update a table. When asked the reason was he had no idea how to…

SQL SERVER – Disable All the Foreign Key Constraint in Database – Enable All the Foreign Key Constraint in Database

April 29, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys

Here is an email I received during the weekend. “Hi Pinal, I am a senior tester in the leading organization and we have two different environments 1) Testing 2) Production. As a part of the testing we want to insert garbage data into the database system and see how the application…

SQLAuthority News – Download PowerPivot or PowerView enabled Workbook Optimizer – Download SQL Server Connector for Apache Hadoop

April 28, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

PowerPivot, SQL Download

Earlier this week Microsoft have released two very interesting downloads which got my attention. Haddop, PowerPivot and PowerView all three are not directly related to traditional RDBMS but their important is growing in the industry as big data is taking over market. The Microsoft SQL Server SQOOP Connector for Hadoop…

SQL SERVER – Weekly Series – Memory Lane – #026

April 27, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…

SQL SERVER – Return Specific Row to at the Bottom of the Resultset – T-SQL Script – Part 2

April 25, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, Union

“How do I return a few of my resultset rows at the bottom of the entire resultset?” I was previously asked this question and my response was that we can do this by using the CASE statement in the ORDER BY clause and I wrote a blog post describing the…

SQL SERVER – Interview Questions and Answers Sample Chapter Free Download – SQL in Sixty Seconds #050

April 24, 2013

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, sqlcmd

This journey of SQL in Sixty Seconds we started almost a year ago and today we are at very interesting milestone where I am recording 50th episode. Thought I wanted to keep the length of each video to sixty seconds, sometimes it went up by a few seconds. Due to this we are also at very…