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

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

April 24, 2013

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…

SQL SERVER – Weekly Series – Memory Lane – #025

April 20, 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 – Using SSIS to Import CSV File into Salesforce Online Database with dotConnect for Salesforce from Devart

April 18, 2013

Pinal Dave

SQL

CSV, Devart

I have previously written article how one can import a CSV file into a database table using SSIS package. This was a simple import operation when the CSV file structure corresponded to the table structure column-to-column. However SQL Server Integration Services is a very powerful tool that can be used for much more complex data import CSV operations.