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

SQLAuthority News – SQL Server Data Tools – Business Intelligence for Visual Studio 2012 – SQL Server 2012 Data-Tier Application Framework

March 10, 2013

Microsoft SQL Server Data Tools provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform within Visual Studio. The SQL Server Object Explorer in Visual Studio offers a view of your database objects similar to SQL Server Management Studio. SQL…

SQL SERVER – Weekly Series – Memory Lane – #019

March 9, 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 – Tricky Question – What is the Default Size of the Database

March 8, 2013

Pinal Dave

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

I love tricky questions – they are fun and educating. Yesterday I was presenting in one of the largest organization in India on SQL Server Performance Tuning Subject. During the conversation, one of the user suggested that every single time they are creating new database it is created with the…

SQL SERVER – Watch Four Efficiency Tricks in SQL Server In Sixty Seconds – Subscribe for SQL Learning Videos

March 6, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

SQL in Sixty Seconds

SQL in Sixty Seconds has been my favorite thing to do every Wednesday. It is indeed truly said that “A picture is worth a thousand words” – it is equally true that “A video is worth a thousand pictures”. Though recording the video is easy the difficult part is to…

SQL SERVER – Exporting Query Results to CSV using SQLCMD

March 5, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

sqlcmd

Social media is evolving at a rapid pace and every day I keep on getting question from different methods. Here is the latest question which I received on my Facebook page. The question was how to export the data of query into CSV using SQLCMD. This is indeed very easy…

SQL SERVER – Download Microsoft PowerPivot for Excel 2010 and PowerPivot in Excel 2013 Samples

March 3, 2013

Pinal Dave

SQL

Excel, PowerPivot, SQL Download, SQL Server

Learning any technology is easy when we have good documentation and sample database to play along with. When I have to learn any new technology, my first action is to install the trial software and look for sample database next. Once I get sample database, I try to find a video tutorial about the technology and continue to learn onwards. Let’s see PowerPivot for Excel 2010 and PowerPivot in Excel 2013 Samples here.

SQL SERVER – Weekly Series – Memory Lane – #018

March 2, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane, SQL Scripts