http://www.windowsitpro.com/authors/author/author/5570212/rss/5570212en-USSun, 27 May 2012 07:04:25 GMTSun, 27 May 2012 07:04:25 GMThttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-sql-server-skills
By Pinalkumar Dave
Pick up 7 basic query analysis rules from Dave.]]>Pinalkumar DaveMon, 29 Sep 2008 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-sql-server-skillshttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills98713
By Pinalkumar Dave
Discover the difference between Windows Authentication Mode and Mixed Mode, and learn the names and uses of installed system databases.]]>Pinalkumar DaveWed, 28 May 2008 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills98713http://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills98961
By Pinalkumar Dave
]]>Pinalkumar DaveThu, 24 Apr 2008 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills98961http://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills98299
By Pinalkumar Dave
Get answers to your questions about SQL Server 2005 Surface Area Configuration tools that can help you protect the SQL Server surface area from security breaches perpetrated by unauthorized users or applications.]]>Pinalkumar DaveFri, 28 Mar 2008 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills98299http://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97936
By Pinalkumar Dave
More answers to DBAs’ questions. What’s the difference between dividing an integer with NULL or zero, or between a unique constraint and a primary key constraint, or between decimal and numeric data types? And how do you retrieve random rows from a table?]]>Pinalkumar DaveThu, 28 Feb 2008 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97936http://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97768
By Pinalkumar Dave
Server backup doesn’t have to be complex. With these simple commands you can perform full, transaction log or incremental, differential, and file backups. Plus you’ll learn commands for recovering files and when to do a tail-log backup.]]>Pinalkumar DaveFri, 25 Jan 2008 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97768http://www.windowsitpro.com/article/sql-server-2000/sharpen-your-basic-sql-server-skills
By Pinalkumar Dave
DBAs get answers to basic Structured Query Language (SQL) questions on the difference between FILLFACTOR = 0 and FILLFACTOR = 100; ISNULL and NULLIF; clustered index and nonclustered index; % used as wildcard and % used as operator; TRUNCATE and DELETE. ]]>Pinalkumar DaveTue, 20 Nov 2007 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-2000/sharpen-your-basic-sql-server-skillshttp://www.windowsitpro.com/article/sql-server/sharpen-your-skills-joins-groupings-and-data-types
By Pinalkumar Dave
Learn the difference between UNION and UNION ALL; INNER JOIN and OUTER JOIN; DISTINCT and GROUP BY; NVARCHAR, VARCHAR, and CHAR; and timestamp and GETDATE().]]>Pinalkumar DaveThu, 25 Oct 2007 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server/sharpen-your-skills-joins-groupings-and-data-typeshttp://www.windowsitpro.com/article/sql-server/sharpen-your-skills-routines-and-clauses
By Pinalkumar Dave
SQL Server often features several ways to do the same or similar tasks. To select the best technique for the job, you need to understand the differences.]]>Pinalkumar DaveThu, 20 Sep 2007 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server/sharpen-your-skills-routines-and-clauses