I recently had the opportunity to view some of the newest courses from Pluralsight , an organization that offers online training courses for developers. One of the courses that I viewed was the SQL Server Questions & Answers ( http://www.pluralsight-training.net/microsoft/Courses/TableOfContents...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
02-22-2012
Filed under:
Filed under: Development, Administration, T-SQL, Performance Tuning, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, Guidance, DBA, SSMS, Tools and Utilities, Community, Myths
Lunch time for me, is time to refresh myself. It’s a time when I try to daily to take 10-15minutes out of my lunch time to close my E-mail client, stop all work and take my mind away from the day’s work. I spend the time learning about anything I am in the mood for – science, sports and SQL Server (of...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
06-29-2011
Filed under:
Filed under: Development, Administration, T-SQL, Performance Tuning, Tips, SQL Server, Denali, #SQLServer, #TSQL, Best Practices, Guidance, Installation, DBA, SSMS, Tools and Utilities, Community, Myths, Debugging
Ever since anyone starts learning Microsoft SQL Server, a misconception sets in. The misconception is that data and log files can be defined as under: File with extension - .mdf - is a Primary data file File with extension - .ndf - is a Secondary data file File with extension - .ldf - is a log file These...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
06-26-2011
Filed under:
Filed under: Administration, Tips, SQL Server, #SQLServer, Best Practices, Guidance, Installation, DBA, SSMS, Tools and Utilities, Myths
A couple of months ago, I ran into a strange issue. Whenever I fired the “RECONFIGURE” statement, the SQL Server returned an error message - “Ad hoc update to system catalog is not supported.” I was able to trace this to the fact that somebody had set the “allow updates”...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
06-15-2011
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, DBA, SSMS, Tools and Utilities, Myths, Connect Cases
As you probably know by now, I use the Template Explorer a lot and encourage everyone to do the same. It is a great tool within the SSMS, and most developers and administrators adopt it with a smiling face. You can read all about it via the following posts: Template Explorer – Underappreciated features...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
06-01-2011
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, DBA, SSMS, Tools and Utilities, Myths, Connect Cases
Today, we will talk about a slightly different, yet very common subject. We will talk about what are the different ways to measure the number of rows in a table. I found a couple of posts over the Internet, and I will reference them as and when I demonstrate the associated methods. This post basically...
Data type conversion has been one of the most used features of any programming language. Microsoft SQL Server users are familiar with the two functions: CAST() and CONVERT() and use them regularly, and more specifically, interchangeably. However, using CAST() and CONVERT() interchangeably is one of the...