SQL Server Archives - Page 113 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Remove Cached Login from SSMS Connect Dialog – SQL in Sixty Seconds #049

April 17, 2013

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

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio, sqlcmd

One of the most annoying thing which I have personally come across is drop down list of Server Lists on Connect dialog in SQL Server Management Studio. Here are two of the cases when I want to delete something from SSMS Connect Screen: 1) Incorrect server name typed 2) Server…

SQLAuthority News – Excellent Experience at TechEd India 2013 Bangalore and Pune – Photo Journey

April 15, 2013

Pinal Dave

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

SQLAuthority Author Visit

TechEd is the premier event from Microsoft and it is always pleasure to be part of the TechEd. This year I attended my fifth TechEd and I had presented at this event 4th time in the row. Presenting at TechEd is fun as there is a totally different level of…

SQL SERVER – Tricks for Row Offset and Paging in Various Versions of SQL Server

April 14, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Paging

Paging is one of the most needed tasks when developers are developing applications. SQL Server has introduced various features of SQL Server 2000 to the latest version of SQL Server 2012. Here is the blog post which I wrote which demonstrates how SQL Server Row Offset and Paging works in…

SQL SERVER – Weekly Series – Memory Lane – #024

April 13, 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…

SQLAuthority News – HP Project Moonshot Interchangeable and Interlockable Servers with Elastically Scale NuoDB

April 12, 2013

Pinal Dave

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

NuoDB

HP has recently released a new product called Project Moonshot. For anyone interested in databases, server systems, or cloud computing, the description of this new option was intriguing. On its most basic level, Project Moonshot is a scalable server system, available in small units that are easy to enlarge and…

SQL SERVER – The procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.

April 8, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure

Here is one of the very common question I receive on SQLAuthority Facebook page. I usually answer them on Facebook but this one I find it very interesting so I decided to answer here. “There are few of the stored procedure when I try to execute they return following message. Would…

SQL SERVER – Weekly Series – Memory Lane – #023

April 6, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane