All Articles - SQL Authority with Pinal Dave

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

April 29, 2013

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 – UNION ALL and UNION are Different Operation

April 26, 2013

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Union clause, Union

I have previously written about the difference between UNION ALL and UNION multiple times over this blog but it seems like this question never gets old and I keep on getting the question again and again. Let us learn about the different operations about the unions.

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…

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

April 23, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server

“How do I return a few of my resultset rows at the bottom of the entire resultset?”

SQL SERVER – Discussion – Scale-up vs Scale-out Architectures

April 22, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

NuoDB

Note: NuoDB is a complete re-think of relational databases with innovative support for the Cloud’s dynamic, asynchronous nature. Download NuoDB to experience the Scaling Out scenario discussed in this blog post. Scaling Up There are many different ways of scaling SQL Server to accommodate more transactions and throughput. The general scale-up approach includes:…

SQLAuthority News – Webinar SQL Server Locking and Concurrency by Rick Morelan

April 22, 2013

Pinal Dave

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

My book co-author Rick Morelan is giving away SQL Queries Book and DVD set (valued at over $200) in his next webinar. SQL Server is known for handing many requests at once and updating as new data comes in. If concurrency allows many things to happen at once, and locking prevents…

SQLAuthority News – Women in SQL – Youngest SQL Speaker – Bangalore SQL User Group Event on April 20, 2013

April 21, 2013

Pinal Dave

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

SQLAuthority Author Visit

It was a great day today as at a SQL Bangalore User Group we had an event “Women in SQL” day. This event was one of the milestone event as in India there was no UG in my knowledge had done an event where we appreciated “Women Power”. We had…