Journey to SQL Authority with Pinal DaveJourney to SQL Authority with Pinal DavePinalkumar Dave is the author of many SQL Server articles. He has five years experience as a Principal Database Administrator and Web Application Architecture Developer in MS SQL Server 2005 2000 and ColdFusion MX. He has a Masters of Science degree Articles
SQL SERVER - UDF - Remove Duplicate Chars From String
2007-12-05 02:30:00 Few days ago, I received following wonderful UDF from one of this blog reader. This UDF is written for specific purpose of removing duplicate chars string from one large string. Virendra Chauhan, author of this UDF is working as DBA in Lutheran Health Network. CREATE FUNCTION dbo.REMOVE_DUPLICATE_INSTR (@datalen_tocheck INT,@string VARCHAR(255)) RETURNS VARCHAR(255) AS BEGIN DECLARE @str VARCHAR(255) DECLARE @count INT DECLARE @start INT DECLARE ... More About: Server , String , Serve
SQLAuthority Author Visit - IT Outsourcing to India - Top 10 Reasons Compan
2007-12-04 02:30:00 Yesterday I had meeting with few of the leading outsourcing companies in Ahmedabad, India . Regular readers of this blog knows that I am currently in India handling large scale outsourcing assignment. My responsibilities includes managing application development, system architecture and database architecture. The purpose of meeting was to exchange the views and learn methodologies from ... More About: Outsourcing , Author , Reasons , Visit
SQL SERVER - Grouping JOIN Clauses In SQL
2007-12-03 02:30:00 I always enjoy writing and reading articles about JOIN Clause s. One of my friend and the best ColdFusion Expert Ben Nadel has written good article about SQL JOINs. There are few interesting comments as well at the end of article. “JOIN grouping is pretty powerful and can get you out of those sticky situations that involve ... More About: Technology , Join , Server , Serve
SQL SERVER - Q and A with Database Administrators
2007-12-02 02:30:00 I have been in India for more than a month now, as I am leading a very large outsourcing project. We have conducted few interviews since the project required more Database Administrators and Senior Developers. I am listing few of the questions discussed during all the interviews. The whole event of interviews was very interesting. ... More About: Server , Serve
SQL SERVER - Sharpen Your Skills: Brush up on FILLFACTOR, ISNULL, NULLIF, a
2007-12-01 13:30:00 Read my article in SQL Server Magazine December 2007 Edition I will be not able to post complete article here due to copyright issues. Please visit the link above to read the article. More About: Technology , Database , Brush , Skills
SQLAuthority News - Download SQL Server 2005 Books Online (September 2007)
2007-11-30 02:30:00 Download an updated version of Books Online for Microsoft SQL Server 2005. Books Online is the primary documentation for SQL Server 2005. The September 2007 update to Books Online contains new material and fixes to documentation problems reported by customers after SQL Server 2005 was released. Refer to “New and Updated Books Online Topics” for ... More About: News , Technology , Download , Database
SQL SERVER - Database Interview Questions and Answers Complete List
2007-11-29 02:30:00 If you are subscribed to my blog you will know that I receive request to send Database or SQL Server very frequently. Following is list of articles of my questions and answers series. Download SQL Server Interview Questions and Answers Complete List Complete Series of SQL Server Interview Questions and Answers SQL Server Interview Questions and Answers ...
SQL SERVER - Correct Syntax for Stored Procedure SP
2007-11-28 02:30:00 Just a day ago, I received interesting question about correct syntax for Stored Procedure. Many readers of this blog will think that it is very simple question. The reason this is interesting is the question behavior of BEGIN … END statements and GO command in Stored Procedure. Let us first see what is correct syntax. Correct Syntax : CREATE ... More About: Server , Serve , Rect
SQL SERVER - 2005 - List All Stored Procedure in Database
2007-11-27 02:30:00 Run following simple script on SQL Serve r 2005 to retrieve all stored procedure in database. SELECT * FROM sys.procedures; This will ONLY work with SQL Server 2005. Reference : Pinal Dave (http://www.SQLAuthority.com) More About: List , Database
SQL SERVER - Rules of Third Normal Form and Normalization Advantage - 3NF
2007-11-26 02:30:00 I always ask question about Third Normal Form in interviews I take. Q. What is Third Normal Form and what is its advantage? A. Third Normal Form (3NF) is most preferable normal form in RDBMS. Normalization is the process of designing a data model to efficiently store data in a database. The rules of 3NF are mentioned ... More About: Server , Rules
SQLAuthority News - SQL Server Compact 3.5 Downloads and ReportViewer Visua
2007-11-25 02:30:00 SQL Server Compact 3.5 Books Online and Samples SQL Server Compact 3.5 is a small footprint in-process database engine that allows developers to build robust applications for Windows Desktops and Mobile Devices. This download contains the Books Online and Samples for SQL Server Compact 3.5 SQL Server Compact 3.5 for Windows Mobile SQL Server Compact 3.5 is a ... More About: News , Technology , Downloads , Database
SQL SERVER - Upgrade Advise - From 2000 to 2005 or 2008
2007-11-24 02:30:00 There has some good amount of discussion going on in SQL Serve r community about should we upgrade from SQL Server 2000 to SQL Server 2005 or wait for SQL Server 2008 . I have received quite a few email and invitations to participate in forums on this topic. Instead of talking about this topic on different ...
SQL SERVER - 2008 - November CPT5 New Improvement
2007-11-23 02:30:00 The progress map of SQL Server 2008 is diagrammatically listed here. I am listing the new improvements here as list. Data Collection and Performance Warehouse for Relational Engine Service Broker Enhancements Registered Servers Enhancements Synchronous net-changes change tracking for SQL Server T-SQL IntelliSense Declarative Management Framework (DMF) Enhancements Geo-spatial Support Analysis Services Query and Writeback Performance Robust Report Server Platform Integration Services - Lookup Enhancements Analysis Services ... More About: Technology , Improvement , November , Prove
SQL SERVER - Shrinking Truncate Log File - Log Full - Part 2
2007-11-22 02:30:00 About a year ago, I wrote SQL SERVER - Shrinking Truncate Log File - Log Full . I was just going through some of the earlier posts and comments on this blog and one particular comment by Praveen Barath caught my eye. It is very good explanation. I am copying complete explanation here with full credit ... More About: Server , Part , Serve
SQL SERVER - Generate Incremented Linear Number Sequence
2007-11-21 02:30:00 Just a day ago, I received interesting question on this blog. Read original question here. This is very good question and after reading this question I quickly wrote small script as answer. Let us see the question and answer together. Q. How can we generate incremented linear number in sql server as in oracle we generate ... More About: Server , Sequence , Creme , Serve , Number
SQL SERVER - Sharpen Your Skills: Joins, Groupings, and Data Types
2007-11-20 02:30:00 Read my article in SQL Serve r Magazine November 2007 Edition More About: Data , Skills , Types
SQLAuthority News - SQL Server 2008 Community TechnoloyPreview (CTP) Downlo
2007-11-19 02:30:00 Download the latest SQL Server 2008 Community TechnoloyPreview (CTP) and try out the latest features of SQL Server 2008! The SQL Server development team uses your CTP feedback to help refine and enhance product features. Download it today and send your feedback. Microsoft SQL Server 2008, the next release of Microsoft SQL Server, provides a comprehensive ... More About: News , Technology
SQLAuthority News - Job Opportunity in Ahmedabad, India to Work with Techno
2007-11-18 02:30:00 If you have one or more years of experience in any web based programming language (.NET, ColdFusion, PHP) and interested in SQL Server as well willing to locate Ahmadabad, India . Please send me your resume, if selected you may get chance to work with one of the most progressing industry in world as well some ... More About: News , Technology , Techno , Work
SQL SERVER - 2005 - Best Practices for SQL Server Health Check
2007-11-17 02:30:00 Few days ago, I reviewed SQLAuthority News - Book Review - SQL Server 2005 Management and Administration (Paperback) on this blog. I received few comments on this review. Some people think it is good book, some thought that this waste of time. Well, after so many emails, I feel that I should point out something ... More About: Health , Technology , Check , Heal
SQL SERVER - 2005 - Generate Script with Data from Database - Database Publ
2007-11-16 02:30:00 I really enjoyed writing about SQL SERVER - 2005 - Create Script to Copy Data base Schema and All The Objects - Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects. Since then the I have received question that how to copy data as well along with schema. The answer to this is ... More About: Server , Serve
SQLAuthority News - Microsoft SQL Server 2005 Assessment Configuration Pack
2007-11-15 02:30:00 Microsoft SQL Server 2005 Assessment Configuration Pack for Gramm-Leach Bliley Act (GLBA) This configuration pack contains configuration items intended to help you establish and validate a desired configuration for your SQL 2005 servers in order to support your Gramm-Leach Bliley Act compliance efforts Microsoft SQL Server 2005 Assessment Configuration Pack for Sarbanes-Oxley Act (SOX) This configuration pack contains ... More About: News , Technology , Microsoft
SQLAuthority News - Microsoft SQL Server 2005 MSIT Three Configuration Pack
2007-11-14 02:30:00 Microsoft SQL Server 2005 MSIT Basic Configuration Pack for Configuration Manager 2007 This configuration pack contains configuration items intended to manage your SQL Server 2005 server roles, and was developed based on settings used by Microsoft IT in the configuration of these server roles. Microsoft SQL Server 2005 MSIT Intermediate Configuration Pack for Configuration Manager 2007 This configuration ... More About: News , Technology , Microsoft
SQLAuthority News - SQL Joke, SQL Humor, SQL Laugh - Database Dilbert
2007-11-14 02:30:00 This is my favorite Dilbert. Click on image to see large graphic. Reference : Dilbert More About: News , Humor , Technology , Joke , Database
SQL SERVER - DBCC CHECKDB Introduction and Explanation - DBCC CHECKDB Error
2007-11-13 02:30:00 DBCC CHECKDB checks the logical and physical integrity of all the objects in the specified database. If DBCC CHECKDB ran on database user should not run DBCC CHECKALLOC, DBCC CHECKTABLE, and DBCC CHECKCATALOG on database as DBCC CHECKDB includes all the three command. Usage of these included DBCC commands is listed below. DBCC CHECKALLOC - ... More About: Introduction , Server , Error , Serve
SQL SERVER - FIX : ERROR Msg 1803 The CREATE DATABASE statement failed. The
2007-11-12 02:30:00 Following error occurs when database which is attempted to be created is smaller than Model Database . It is must that all the databases are larger than Model database and 512KB. Following code will create the error discussed in this post. CREATE DATABASE Tests ON ( NAME = 'Tests', FILENAME = 'c: ests.mdf', SIZE = 512KB ) GO Msg 1803, Level 16, State 1, Line 1 The ... More About: Server , Error , Create , Statement
SQLAuthority News - The Equations of Relativist
2007-11-12 02:30:00 F = mg ?.. Galileo F = ma ?.. Newton E = mc˛?.. Einstein Reference : (Great Site - relationary) More About: News , Technology , Database , Quat
SQL SERVER - FIX : ERROR Msg 5174 Each file size must be greater than or eq
2007-11-12 02:30:00 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 post. CREATE DATABASE Tests ON ( NAME = 'Tests', FILENAME = ... More About: File , Server , Size , Error , Serve
SQLAuthority News - SQL Server 2005 Powers Global Forensic Data Security To
2007-11-11 02:30:00 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 Security Consolidated Event Management (ICE 3.0) to gather forensic data from more ... More About: News , Technology , Data Security , Data
SQL SERVER - 2005 2000 - Search String in Stored Procedure
2007-11-10 02:30:00 SQL Serve r 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. This blog has is heavily ... More About: Search , String , Tring
SQL SERVER - Versions, CodeNames, Year of Release
More articles from this author:2007-11-09 02:30:00 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 Serve r releases so far. I knew only two code names SQL Server 2005 - Yukon ... More About: Technology , Release , Year 1, 2, 3, 4, 5, 6, 7 |
|
 |
|
 |
