SQL Tips and Tricks Archives - Page 236 of 536 - SQL Authority with Pinal Dave

SQLAuthority News – NuoDB Announces Webinar Series To Demystify Cloud Data Management

February 18, 2013

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

For those of you who read my blog regularly, you know that I’ve been evaluating NuoDB, a new database company that is re-writing the rules for relational databases. They’ve introduced a new category – Cloud Data Management Systems (CDMS) – and are claiming to be the first and only. In…

SQL SERVER – Fix : Error – sqljdbc_auth.dll Issue – com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed

February 17, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Server

It seems that Sundays are marked for strange errors. Every Sunday I come across something interesting and different to post. This time I receive error from one of JDBC driver users. He sent me a message that he is not able to connect to SQL Server and he is facing the following error while connecting to SQL Server. He has already checked firewall and TCP/IP settings and still he is facing the errors.

SQL SERVER – Weekly Series – Memory Lane – #016

February 16, 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 – Presenting at Sarasota IT Pro Camp, Florida on February 16, 2013

February 15, 2013

Pinal Dave

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

SQLAuthority Author Visit

I am traveling the entire month of February 2013 in USA. First 18 days I am Florida and later part I am heading to another part of the country. When I am in India, every weekend I make a point to attend one of the User Group Meeting in the…

SQL SERVER – Get SQL Server Version and Edition Information – SQL in Sixty Seconds #043 – Video

February 13, 2013

Pinal Dave

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

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

What do consultants do when they come across any new instance of SQL Server? Well, their very first question is what version of SQL Server is it? The reason is simple – SQL Server is a very vast product and each version of the product have new features released and…

SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1 and Included Columns Col2 and Col3 – Part 5

February 12, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

This is the fifth part of the series regarding Redundant Indexes. If have not read earlier part – there is quite a good chance that you will miss the context of this part. I quickly suggest you to read earlier four parts. On my production server I personally use embarcadero DB Optimizer for…

SQL SERVER – What is Semantics Model – A Simple Explanation

February 11, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

“Semantics” refers to the meaning behind words, sentences, or phrases. This is its general meaning. In technology, even the word “semantics” has more meanings. Semantics, and semantic models, refer to how data is organized within a database to make it more useful for users. So, in technology, semantics have the…