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

SQL SERVER – How to Refresh SSMS Intellisense Cache to Update Schema Changes

July 4, 2013

Have you ever faced situation where you have just created or modified object but SSMS still shows the error. I quite often face this situation where I come across situation where my SSMS Intellisense Cache is not refreshed or updated. This is indeed very frustrating when you are presenting something…

Personal Technology – Excel Tip: Comparing Excel Files

July 2, 2013

Pinal Dave

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

Excel, Personal Technology

This guest post is by Vinod Kumar. Vinod Kumar has worked with SQL Server extensively since joining the industry over a decade ago. Working on various versionsfrom SQL Server 7.0, Oracle 7.3 and other database technologies – he now works with the Microsoft Technology Center (MTC) as a Technology Architect. Let us read…

SQL SERVER – Check If Column Exists in SQL Server Table

July 1, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

A very frequent task among SQL developers is to check if any specific column exists in the database table or not. Based on the output developers perform various tasks. Here are couple of simple tricks which you can use to check if column exists in your database table or not.…

SQL SERVER – 2014 CTP1 Available for Download – SQL SERVER 2014 Community Technology Preview 1

June 30, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

CTP, SQL Service Pack

Microsoft announced that SQL Server 2014 CTP 1 available to download at TechEd Europe. You can download SQL Server 2014 CTP1 from here. Additionally, there is in depth documentation of the product in the Product Guide over here. In this blog post I have in depth discussed what are the salient features…

SQL SERVER – Weekly Series – Memory Lane – #035

June 29, 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 – How to Set Variable and Use Variable in SQLCMD Mode

June 28, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio, sqlcmd

Here is the question which I received the other day on SQLAuthority Facebook page. Social media is a wonderful thing and I love the active conversation between blog readers and myself – actually I think social media adds lots of human factor to any conversation. Here is the question – “I…

SQL SERVER – Another lesser known feature of SQL Server Management Studio 2012 – Guest Post by Balmukund Lakhani

June 27, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server, SQL Server Management Studio

This is a fantastic blog post from my dear friend Balmukund ( blog | twitter | facebook ). He had presented a fantastic session in our last UG and there were lots of requests from attendees that he blogs about it. Well, here is the blog post about the same very popular UG session. Let us read the entire blog post in the voice of the Balmukund himself.

In one of my previous guest blog on SQL Authority, I wrote about “Additional Connection Parameter” tab of login screen in SQL Server Management Studio (a.k.a. SSMS). On the similar lines, this blog is going to show little less known new feature of login main screen (“Connect to Server”) of SSMS 2012.