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
SQLAuthority News - Thank You to Blog Readers
2007-12-31 02:30:00 Thank You very much for reading SQLAuthority.com for entire 2007 year. Wish you the BEST for year 2008. More About: News , Readers , Blog
SQL SERVER - Remove Duplicate Characters From a String
2007-12-30 02:30:00 Follow up of my previous article of Remove Duplicate Chars From String here is another great article written by Madhivanan where similar solution is suggested with alternate method of Number table approach. Check out Remove duplicate characters from a string More About: Technology , Characters , Server , Serve
SQL SERVER - Change Password of SA Login Using Management Studio
2007-12-29 02:30:00 Login into SQL Server using Windows Authentication. In Object Explorer, open Security folder, open Logins folder. Right Click on SA account and go to Properties. Change SA password, and confirm it. Click OK. Make sure to restart the SQL Server and all its services and test new password by log into system using SA login and new password. Reference ... More About: Management , Password , Studio
SQL SERVER - Difference Between Quality Assurance and Quality Control - QA
2007-12-28 02:30:00 Regular readers of this blog are aware of my current outsourcing assignment. I am managing very large outsourcing project in India. One thing is very special in all Indian offices is “Tea Time.” Everybody wants to attend Tea Time not only for tea or coffee but for the interesting discussion occurs at that time. This ... More About: Quality Assurance , Server , Quality Control , Control , Quality
SQLAuthority News - Book Review - A Practitioner?s Guide to Software Test D
2007-12-27 02:30:00 A Practitioner’s Guide to Software Test Design (Hardcover) by Lee Copeland (Author) Link to Amazon (This is not affiliate Link) Short Summary: A Practitioner’s Guide to Software Test Design is one book containing all the important latest test design approaches. This book makes life of software tester very easy. Software tester can find all the information in this ... More About: News , Book Review , Review , Book
SQL SERVER - TRUNCATE Can?t be Rolled Back Using Log Files After Transactio
2007-12-26 02:30:00 You might have listened and read either of following sentence many many times. “DELETE can be rolled back and TRUNCATE can not be rolled back”. OR “DELETE can be rolled back as well as TRUNCATE can be rolled back”. As soon as above sentence is completed, someone will object it saying either TRUNCATE can be or can not ... More About: Back , Server , Files , Serve , Ansa
SQL SERVER - Delete Duplicate Records - Count Duplicate Records Links
2007-12-25 02:30:00 I have wrote following two articles for Duplicate Rows Management in SQL Server . SQL SERVER - Count Duplicate Records - Rows SQL SERVER - Delete Duplicate Records - Rows More About: Links
SQL SERVER - Mirrored Backup Introduction and Explanation
2007-12-25 02:30:00 SQL Serve r 2005 Enterprise Edition and Development Edition supports mirrored backup. Mirroring a media set increases backup reliability by adding redundancy of backup media which effectively reduces the impact of backup-device failing. While taking backup of database, same backup is taken on multiple media or locations. T-SQL code to take Mirrored Backup : BACKUP DATABASE AdventureWorks TO DISK ... More About: Introduction
SQLAuthority News - Jobs, Search, Best Articles, Homepage
2007-12-24 02:30:00 If you are looking for solution of any of your question : Search SQLAuthority If you are looking for best job in IT field : Find Job or email pinal@sqlauthority.com If you are looking for talented IT professional : Post Job or email pinal@sqlauthority.com If you want to read my personally selected articles : Best Articles If you want ... More About: News , Technology , Jobs
SQLAuthority News - Download Microsoft SQL Server 2000/2005 Management Pack
2007-12-24 02:30:00 The SQL Server Management Pack monitors the availability and performance of SQL Server 2000 and 2005 and can issue alerts for configuration problems. Availability and performance monitoring is done using synthetic transactions. In addition, the Management Pack collects Event Log alerts and provides associated knowledge articles with additional user details, possible causes, and suggested resolutions. ... More About: News , Technology , Microsoft , Download
SQL SERVER - Object Oriented Database Management Systems
2007-12-24 02:30:00 I have received few emails and comments about why I do not write about Object Oriented Database Management Systems (OODBMS). The reason for that is that I am big follower of Relational Database Management Systems (RDBMS) and that particularly of Microsoft SQL Server . If you are interested in reading about OODBMS, I have came across ...
SQL SERVER - 2008 - New DataTypes DATE and TIME
2007-12-23 02:30:00 One of our project manager asked me why SQL Serve r does not have only DATE or TIME datatypes? I thought his question is very valid, he is not DBA however he understands the RDBMS concepts very well. I find his question very interesting. I told him that there are ways to do that in SQL ... More About: Time , 2008
SQL SERVER - Difference Between Index Rebuild and Index Reorganize Explaine
2007-12-22 02:30:00 Index Rebuild : This process drops the existing Index and Recreates the index. USE AdventureWorks; GO ALTER INDEX ALL ON Production.Product REORGANIZE GO Index Reorganize : This process physically reorganizes the leaf nodes of the index. USE AdventureWorks; GO ALTER INDEX ALL ON Production.Product REBUILD GO Recommendation: Index should be rebuild when index fragmentation is great than 40%. Index should be reorganized when index fragmentation ... More About: Technology , Server , Index , Difference , Diff
SQL SERVER - Enabling Clustered and Non-Clustered Indexes - Interesting Fac
2007-12-21 02:30:00 While playing with Indexes I have found following interesting fact. I did some necessary tests to verify that it is true. When a clustered index is disabled, all the nonclustered indexes on the same tables are auto disabled as well. User do not need to disable non-clustered index separately. However, when clustered index is enabled, it ... More About: Interesting , Server , Stere , Eres , Serve
SQL SERVER - DISTINCT Keyword Usage and Common Discussion
2007-12-20 02:30:00 Jr. DBA asked me a day ago, how to apply DISTINCT keyword to only first column of SELECT. When asked for additional information about question, he showed me following query. SELECT Roles, FirstName, LastName FROM UserNames He wanted to apply DISTINCT to only Roles and not across FirstName and LastName. When he finished I realize that it is ... More About: Keyword , Server , Common , Usage , Discussion
SQL SERVER - Cumulative Update Package 5 for SQL Server 2005 Service Pack 2
2007-12-19 02:30:00 Microsoft SQL Server 2005 hotfixes are created for specific SQL Server service packs. You must apply a SQL Server 2005 Service Pack 2 hotfix to an installation of SQL Server 2005 Service Pack 2. By default, any hotfix that is provided in a SQL Server service pack is included in the next SQL Server service ... More About: Technology , Update
SQLAuthority News - RML Utilities for SQL Server
2007-12-19 02:30:00 The RML utilities allow you to process SQL Serve r trace files and view reports showing how SQL Server is performing. For example, you can quickly see: Which application, database or login is using the most resources, and which queries are responsible for that Whether there were any plan changes for a batch during the time when ... More About: News , Utilities , Technology
SQL SERVER - Get Information of Index of Tables and Indexed Columns
2007-12-18 02:30:00 Knowledge of T-SQL inbuilt functions and store procedure can save great amount of time for developers. Following is very simple store procedure which can display name of Index es and the columns on which indexes are created. Very handy stored Procedure. USE AdventureWorks; GO EXEC sp_helpindex 'Person.Address' GO Above SP will return following information. IndexName - IX_Address_AddressLine1_AddressLine2_City _StateProvinceID_PostalCode Index_Description - nonclustered, unique located on ... More About: Information , Tables , Columns , Server
SQL SERVER - T-SQL Script to Find Details About TempDB
2007-12-17 02:30:00 Two days ago I wrote article about SQL SERVER - Temp DB Restrictions - Temp Database Restrictions. Since then I have received few emails asking details about TempDB. I use following T-SQL Script to know details about my TempDB. I have found this script from MSDN site. I have mentioned original source link in reference at ... More About: Find , Server , Details
SQL SERVER - Solution - Log File Very Large - Log Full
2007-12-16 02:30:00 I have been receiving following question again and again either through email or through comments on this blog. My log file is too big, what should I do? Answer to this question is in three steps. Backup the log file to any device. Truncate the log file. Shrink the log file. I have previously written two article about this issue. Refer ... More About: File , Server , Full , Solution , Large
SQL SERVER - TempDB Restrictions - Temp Database Restrictions
2007-12-15 02:30:00 While conducting Interview for my outsourcing project, I asked one question to interviewer that what are the restrictions on Temp DB? Candidate was not able to answer the question. I thought it would be good for all my readers to know answer to this question so if you face this question in interview or if you ... More About: Database , Server , Serve , Strict
SQLAuthority News - Top 10 Tips for Successful Software Outsourcing
2007-12-14 02:30:00 Few days ago, I wrote article about SQLAuthority Author Visit - IT Outsourcing to India - Top 10 Reasons Companies Outsource. I received quite a few emails regarding this article. I was really impressed that how much vendors care about their reputation and their client. I received so many requests from my blog readers who ... More About: Software , News , Tips
SQL SERVER - Do Not Store Images in Database - Store Location of Images (UR
2007-12-13 02:30:00 Just a day ago I received phone call from my friend in Banglore. He asked me What do I think of storing images in database and what kind of datatype he should use? I have very strong opinion about this issue. I suggest to store the location of the images in the database using VARCHAR datatype instead of ... More About: Images , Store , Database , Location , Server
SQL SERVER - White Papers: Migration from Oracle Sybase, or Microsoft Acces
2007-12-12 02:30:00 Guide to Migrating from Oracle to SQL Server 2005 This white paper explores challenges that arise when you migrate from an Oracle 7.3 database or later to SQL Server 2005. It describes the implementation differences of database objects, SQL dialects, and procedural code between the two platforms. The entire migration process using SQL Server Migration Assistant ... More About: Technology , Microsoft , White
SQL SERVER - Microsoft Synchronization Services for ADO.NET v2.0 CTP1 Refre
2007-12-11 02:30:00 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 store. Applications are increasingly used ... More About: Technology , Microsoft , Server
SQLAuthority News - Microsoft SQL Server 2008 Community Technology Preview
2007-12-10 02:30:00 SQL Server 2008, the next release of Microsoft SQL Server, will provide a comprehensive data platform that is more secure, reliable, manageable and scalable for your mission critical applications, while enabling developers to create new applications that can store and consume any type of data on any device, and enabling all your users to make ... More About: News , Technology , Community , Preview
SQL SERVER - ACID (Atomicity, Consistency, Isolation, Durability)
2007-12-09 02:30:00 ACID (an acronymn for Atomicity Consistency Isolation Durability) is a concept that Database Professionals generally look for when evaluating databases and application architectures. For a reliable database all this four attributes should be achieved. Atomicity is an all-or-none proposition. Consistency guarantees that a transaction never leaves your database in a half-finished state. Isolation keeps transactions separated ... More About: Server , Acid , Serve
SQL SERVER - Generic Architecture Image
2007-12-08 02:30:00 Just a day ago, while I was surfing wikipedia about SQL Server , I came across this generic architecture image. I found it interesting. Click on image to view it in large size. Reference : Pinal Dave (http://www.SQLAuthority.com), Wikipedia - SQL Server More About: Architecture , Image , Generic , Neri
SQL SERVER - FIX : Error : 3702 Cannot drop database because it is currentl
2007-12-07 02:30:00 Msg 3702, Level 16, State 3, Line 2 Cannot drop database “DataBaseName” because it is currently in use. This is very generic error when DROP Database is command is executed and database is not dropped. The common mistake user does is keep the connection open with this database and trying to drop the database. Following commands will raise ... More About: Server , Error , Drop , Anno
SQL SERVER - 2005 - Dynamic Management Views (DMV) and Dynamic Management F
More articles from this author:2007-12-06 02:30:00 Dynamic Management Views (DMV) and Dynamic Management Functions (DMF) return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance. They can exactly tell what is going on with SQL Server and its objects at the moment.There are tow kinds of DMVs and DMFs. Server-scoped ... More About: Dynamic , Nami 1, 2, 3, 4, 5, 6, 7 |
|
 |
|
 |
