SQL Archives - Page 234 of 519 - 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 – Cursor, Truncate Log and More – Memory Lane #010

January 5, 2013

Pinal Dave

SQL

Memory Lane, SQL Server

This is the 10th episode of 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. My favorite articles this week are about cursor and truncate log. Let me know which one of the following is your favorite article from memory lane.

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…