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

SQL SERVER – How to Hide Yourself from SQL Server? – Guest Post by Balmukund Lakhani

January 9, 2013

Balmukund Lakhani (Blog | Twitter | Site) is currently working as Technical Lead in SQL Support team with Microsoft India GTSC. In past 7+ years with Microsoft he was also a part of the Premier Field Engineering Team for 18 months. During that time he was a part of rapid on-site support (ROSS) team. Prior…

SQLAuthority News – Register for NuoDB the Elastically Scalable, SQL/ACID Database

January 8, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

NuoDB

If you are reading this blog, you will be familiar with the innovative database product NuoDB, which I have been experimenting recently. I have been working with this product since last year. I got my hand’s on this product when the product was in its very early phase as well, the…

SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 2

January 7, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

Before you start reading this blog post, I strongly suggest you to read the part 1 of this series. It talks about What is Redundant Index. The story is a conversation between two individuals – Jon and Mike. They are different but have single goal learn and explore SQL Server.…

SQLAuthority News – Download Whitepaper – Cleanse and Match Master Data by Using EIM

January 6, 2013

Pinal Dave

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

SQL White Papers

Master Data Services (MDM) and Data Quality Services (DQS) go hand to hand together when they have to maintain the integrity of the database. If you are new to either of concept I suggest you to read following two articles to get an idea about them. Why Do We Need…

SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 1

January 4, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

Index never stops amazing me, there are so much to learn about Index that I never feel that there is enough knowledge out about this subject. If you are interested you can watch my Indexing Course on Pluralsight for further learning on this subject. On my production server I personally use embarcadero DB…

SQL SERVER – Wrap SQL Code in SSMS – SQL in Sixty Seconds #038 – Video

January 2, 2013

Pinal Dave

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

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

Every developer has a different habit. Some like to format the functions in upper case and some wants it in lower case. I often see developers listing the columns in SELECT clause in a different way. I have my own preference but I do respect the other developer’s preference as…

SQLAuthority News – Resolutions of Year 2013 – Commitment to Myself

January 1, 2013

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

First of all, happy New Year to all of you – 2013 has started! Every year I make at least one resolution, some I do for the public on my blog. The reason is simple – if I declare something in front of all of you, there is a good…