All Articles - SQL Authority with Pinal Dave

SQL SERVER – FIX : ERROR Msg 5174 Each file size must be greater than or equal to 512 KB

November 12, 2007

Following error occurs when database which is attempted to be created is smaller than 512KB. It is must that all the databases are larger than 512KB. It will also follow with another error 1802, which is due to previous error 5174. Following code will create the error discussed in this…

SQLAuthority News – SQL Server 2005 Powers Global Forensic Data Security Tool

November 11, 2007

Pinal Dave

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

SQL Download, SQL Utility, SQL White Papers

Note : Download Whitepaper by Microsoft Find out how SQL Server 2005 powers a 27 TB data management system called ICE 3.0 that gathers forensic data from more than 85 Microsoft corporate proxy servers into a single database. The Information Security team at Microsoft uses an internal tool called Information…

SQL SERVER – 2005 2000 – Search String in Stored Procedure

November 10, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure

SQL Server has released SQL Server 2000 edition before 7 years and SQL Server 2005 edition before 2 years now. There are still few users who have not upgraded to SQL Server 2005 and they are waiting for SQL Server 2008 in February 2008 to SQL Server 2008 to release.…

SQL SERVER – Versions, CodeNames, Year of Release

November 9, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Just a day ago, while I was discussing one of the project with another outsourcing team lead in India (who is leading team of 100+ programmer and developer) he asked me if I know all the codenames of the SQL Server releases so far. I knew only two code names…

SQLAuthority News – Book Review – SQL Server 2005 Management and Administration (Paperback)

November 8, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQLAuthority Book Review

SQL Server 2005 Management and Administration (Paperback) by Ross Mistry (Author), Chris Amaris (Author), Alec Minty (Author), Rand Morimoto (Author) Link to Amazon Short Summary: SQL SERVER 2005 is a trusted database platform that provides organizations a competitive advantage by allowing them to obtain faster results and make better business…

SQLAuthority News – 1 Million Visitors in last 1 year – [Update 2019]

November 7, 2007

Pinal Dave

SQLAuthority News

SQL Milestone

It is indeed a bit day for me. I am very happy that I have 1 million visitors in just last 1 year. Read my story of 365 days.

SQLAuthority News – Microsoft Synchronization Services for ADO.NET v2.0 CTP1

November 6, 2007

Pinal Dave

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

SQL Download

Microsoft Synchronization Services for ADO.NET provides the ability to synchronize data from disparate sources over two-tier, N-tier, and service-based architectures. Rather than simply replicating a database and its schema, the Synchronization Services application programming interface (API) provides a set of components to synchronize data between data services and a local…

SQLAuthority News – Few Add-ons for SQLAuthority

November 5, 2007

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Database, DBA

SQL Random Article Find Post SQL Jobs Search SQLAuthority Subscribe Email Update SQLAuthority Feed My Other Blog Reference : Pinal Dave (https://blog.sqlauthority.com)

SQLAuthority News – Best Articles on SQLAuthority.com

November 4, 2007

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Performance, SQL Server, SQL Tips and Tricks

Data Warehousing, Database, DBA, Software Development, SQL Backup and Restore, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL DateTime, SQL Download, SQL Error Messages, SQL Function, SQL Humor, SQL Index, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure, SQL Trigger, SQL Utility

SQL SERVER – Cursor to Kill All Process in Database SQL SERVER – Find Stored Procedure Related to Table in Database – Search in All Stored procedure SQL SERVER – Shrinking Truncate Log File – Log Full SQL SERVER – Simple Example of Cursor SQL SERVER – UDF – Function…

SQLAuthority News – Best SQLAuthority Articles on Other Popular Sites

November 3, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Coding Standards, SQL Function, SQL Stored Procedure

Best SQLAuthority Articles on Other Popular Sites SQL SERVER – UDF vs. Stored Procedures and Having vs. WHERE (SQL Server Magazine) SQL SERVER – Pre-Code Review Tips – Tips For Enforcing Coding Standards (dotnetslackers.com) Reference : Pinal Dave (https://blog.sqlauthority.com)