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 New - O?relly Style Book Cover for SQLAuthority
2008-01-29 02:30:00 Yo Ming, Chin regular reader from Los Angeles, CA has sent me following image for SQLAuthority. Checkout O’reillymaker and create your own Book Cover . Reference : O’reillymaker More About: Technology , Style , Database
SQLAuthority News - Book Review - Beginners Guide to SQL Server Integration
2008-01-28 02:30:00 Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 (Paperback) by Jayaram Krishnaswamy (Author) Link to Amazon (This is not affiliate Link) Short Summary: SQL Server Integration Services Using Visual Studio 2005 contains all the information and education needed for one to begin with SSIS. It covers all the basic concepts in depth and moves towards ... More About: News , Technology , Book Review , Review
SQLAuthority News - SQL Joke, SQL Humor, SQL Laugh - Funny Quotes
2008-01-27 02:30:00 Following is the collection of some funny quotes regarding computers. Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. Rich Cook. UNIX is basically a simple operating system, but you have to be a genius ... More About: News , Funny , Humor , Technology , Joke
SQLAuthority News - Microsoft SQL Server 2000 MSIT Configuration Pack for C
2008-01-26 02:30:00 Microsoft SQL Server 2000 MSIT Comprehensive Configuration Pack for Configuration Manager 2007 This configuration pack contains configuration items intended to manage your SQL Server 2000 server roles, and was developed based on settings used by Microsoft IT in the configuration of these server roles. Microsoft SQL Server 2000 MSIT Intermediate Configuration Pack for Configuration Manager 2007 This configuration ... More About: News , Technology , Microsoft
SQL SERVER - 2005 - Database Table Partitioning Tutorial - How to Horizonta
2008-01-25 02:30:00 I have received call from my DBA friend who read my article SQL SERVER - 2005 - Introduction to Partitioning. He suggested that I should write simple tutorial about how to horizontal partition database table. Here is simple tutorial which explains how a table can be partitioned. Please read my article Introduction to Partitioning before ... More About: Tutorial , Database , Server , Table
SQL SERVER - 2005 - Introduction to Partitioning
2008-01-24 02:30:00 Partitioning is the database process or method where very large tables and indexes are divided in multiple smaller and manageable parts. SQL Server 2005 allows to partition tables using defined ranges and also provides management features and tools to keep partition tables in optimal performance. Tables are partition based on column which will be used for ... More About: Introduction
SQLAuthority News - Download Microsoft SQL Server 2005 Assessment Configura
2008-01-23 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 , Download , Database
SQLAuthority News - Fix : Remote Desktop Copy Paste Stop Working
2008-01-22 02:30:00 Today’s article is not related to SQL Server 100%, however it is quite related to SQL Server, or atleast I found it while working with SQL Server. Just two days ago, while I was working with remote SQL Server using Remote Desktop tool provided by Windows XP. Suddenly, copy/paste feature of windows stop working on ... More About: News , Stop , Copy
SQL SERVER - 2005 - Get a row per file of a database as stored in the maste
2008-01-21 02:30:00 Each database have minimum of two files associated with database. If database has more than one filegroup it will have many files associated with one database. Following quick script will give you recordset per file of a database which are stored in master database. ELECT name, physical_name, type_desc, state_desc FROM sys.master_files Above script will return following result set. Reference ... More About: File , Database , Server , Serve
SQL SERVER - Introduction to Statistical Functions - VAR, STDEVP, STDEV, VA
2008-01-20 02:30:00 Yesterday I wrote article about SQL SERVER - Introduction to Aggregate Functions . I received one email that four of the aggregate functions are statistical function and I should write something about that. VAR, STDEVP, STDEV, VARP are statistical functions as well they absolutely fit in the definition of aggregate function as well. The usage of ... More About: Server , Serve
SQL SERVER - Introduction to Aggregate Functions
2008-01-19 02:30:00 Recently I have been taking many interviews to increase work force in my companies outsourcing establishment. One question I ask to all interview candidates. What is Aggregate Function? So far I have received two different kind of response. First, I do not know. Second, AVG, SUM, COUNT are aggregate functions. The second response is good ... More About: Functions , Introduction , Server , Serve
SQL SERVER - 2005 Best Practices Analyzer (January 2008)
2008-01-18 02:30:00 The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. With this tool, you can test and implement a combination of SQL Server best practices and then implement them on your SQL Server. The SQL Server 2005 Best Practices Analyzer gathers data from Microsoft Windows and ... More About: Technology , January , January 2008
SQLAuthority News - Job Description of Database Administrator (DBA) or Data
2008-01-17 02:30:00 Job Description of Data base Administrator (DBA) or Database Developer Develop standards and guidelines to guide the use and acquisition of software and to protect vulnerable information. Modify existing databases and database management systems or direct programmers and analysts to make changes. Test programs or databases, correct errors and make necessary modifications. Plan, coordinate and implement security measures to ... More About: News , Technology
SQLAuthroity News - Microsoft SQL Server 2000 Assessment Configuration Pack
2008-01-16 02:30:00 Microsoft SQL Server 2000 Assessment Configuration Pack for Federal Information Security Management Act (FISMA) This configuration pack contains configuration items intended to help you establish and validate a desired configuration for your SQL 2000 servers in order to support your Federal Information Security Management Act compliance efforts. Microsoft SQL Server 2000 Assessment Configuration Pack for Gramm-Leach Bliley ... More About: News , Technology , Microsoft
SQL SERVER - What is - DML, DDL, DCL and TCL - Introduction and Examples
2008-01-15 02:30:00 DML DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database. Examples : SELECT, UPDATE, INSERT statements DDL DDL is abbreviation of Data Definition Language. It is used to create and modify the structure of database objects in database. Examples: CREATE, ALTER, DROP statements DCL DCL is abbreviation of Data ... More About: Introduction , Server , Serve
SQL SERVER - Time Out Due to Executing DELETE on Large RecordSet
2008-01-14 02:30:00 Just a day ago, I received following question: “I have large table more than 1M rows. I want to delete every row in my table. Everytime I ran DELETE statement, it times out and does not do it job. The data in table is useless and I do not need it ever. Your suggestion please.” The ... More About: Time , Server , Time Out , Delete , Large
SQLAuthority News - Find Job Related to SQL Server and Database Administrat
2008-01-13 02:30:00 It is real pleasure for me when I learn that reader of my blog has got something good out of this blog. Please read following abstract of one of the recent email I received. “Dear Dave, I am very thankful to you for wonderful blog. I do not know how can I repay you for all ... More About: News , Technology , Find , Database , Server
SQL SERVER - 2005 - Change Compatibility Level - T-SQL Procedure
2008-01-12 02:30:00 Six months ago I wrote article about SQL SERVER - 2005 Change Database Compatible Level - Backward Compatibility . Yesterday I received an email asking that one of my blog reader is not able to use the sp_dbcmptlevel command with error that database is in use. He has asked me to write about proper procedure of ... More About: Server , Serve
SQL SERVER - Reclaim Space After Dropping Variable-Length Columns Using DBC
2008-01-11 02:30:00 All DBA and Developers must have observed when any variable length column is dropped from table, it does not reduce the size of table. Table size stays the same till Indexes are reorganized or rebuild. There is also DBCC command DBCC CLEANTABLE, which can be used to reclaim any space previously occupied with variable length ... More About: Space , Columns , Server , Serve
SQL SERVER - 2005 - Display Fragmentation Information of Data and Indexes o
2008-01-10 02:30:00 One of my friend involved with large business of medical transcript invited me for SQL Serve r improvement talk last weekend. I had great time talking with group of DBA and developers. One of the topic which was discussed was how to find out Fragmentation Information for any table in one particular database. For SQL Server ... More About: Data , Display
SQL SERVER - Execute Same Query and Statement Multiple Times Using Command
2008-01-09 02:30:00 Following question was asking by one of long time reader who really liked trick of SQL SERVER - Explanation SQL Command GO and SQL SERVER - Insert Multiple Records Using One Insert Statement - Use of UNION ALL. She asked how can I execute same code multiple times without Copy and Paste multiple times in ... More About: Server , Times , Query
SQL SERVER - 2005 - Export Data From SQL Server 2005 to Microsoft Excel Dat
2008-01-08 02:30:00 Enable Ad Hoc Distributed Queries. Run following code in SQL Server Management Studio - Query Editor. EXEC sp_configure 'show advanced options', 1; GO RECONFIGURE; GO EXEC sp_configure 'Ad Hoc Distributed Queries', 1; GO RECONFIGURE; GO Create Excel Spreadsheet in root directory c:contact.xls (Make sure you name it contact.xls). Open spreadsheet, on the first tab of Sheet1, create two columns with FirstName, LastName. Alternatively you ... More About: Microsoft , Data , Export
SQL SERVER - 2005 - Introduction and Explanation to SYNONYM - Helpful T-SQL
2008-01-07 02:30:00 One of my friend and extremely smart DBA Jonathan from Las Vegas has pointed out nice little enhancement in T-SQL. I was very pleased when I learned about SYNONYM feature in SQL Serve r 2005. DBA have been referencing database objects in four part names. SQL Server 2005 introduces the concept of a synonym. A synonyms is ... More About: Introduction
SQL SERVER - Download Frequently Asked Generic Interview Questions
2008-01-06 02:30:00 Yesterday I posted article about SQL SERVER - Most Frequently Asked Generic Interview Questions . I always enjoy when I receive emails and comments about my article. Many readers have asked me to write more about this, I suggest that my readers help me here and add their suggestion and answers to original article. The common ... More About: Technology , Download , Database
SQL SERVER - Most Frequently Asked Generic Interview Questions
2008-01-05 02:30:00 SQL SERVER - Download Frequently Asked Generic Interview Questions PDF Tell me about yourself. What experience do you have in this field? How many years of experience do you have in area you are applying for? Why did you leave your last job? Why are you planning to leave your current job? What do you know about this organization? ... More About: Server , Serve
SQL SERVER - 2005 - CROSS APPLY
2008-01-04 02:30:00 Yesterday I wrote article about SQL SERVER - 2005 - Last Ran Query - Recently Ran Query. I had used CROSS APPLY in the query. I got email from one reader asking what is CROSS APPLY. In simpler words, cross apply is like inner join to table valued function which can take parameters. This particular ... More About: Cross , Server , Serve
SQLAuthority New - Best Practices for Speeding Up Your Web Site
2008-01-03 02:30:00 Steve Souders, Chief Performance Yahoo! Best Practices for Speeding Up Your Web Site . I suggest everybody should read this basic guidelines. They are extremely important for high performance websites. 1. Make Fewer HTTP Requests 2. Use a Content Delivery Network 3. Add an Expires Header 4. Gzip Components 5. Put Stylesheets at the Top 6. Put Scripts at the Bottom 7. Avoid ... More About: Web site
SQL SERVER - 2005 - Last Ran Query - Recently Ran Query
2008-01-03 02:30:00 How many times we have wondered what were the last few queries ran on SQL Serve r ? Following quick script demonstrates last ran query along with the time it was executed on SQL Server 2005. SELECT deqs.last_execution_time AS [Time], dest.text AS [Query ] FROM sys.dm_exec_query_stats AS deqs CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest ORDER BY deqs.last_execution_time DESC Reference : Pinal Dave (http://www.SQLAuthority.com), BOL ... More About: Recently
SQL SERVER - Fix : Error : 15281 SQL Server blocked access to STATEMENT ?Op
2008-01-02 02:30:00 Error : Msg 15281, Level 16, State 1, Line 3 SQL Serve r blocked access to STATEMENT ‘OpenRowset/OpenDatasource’ of component ‘Ad Hoc Distributed Queries’ because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Ad Hoc Distributed Queries’ by using sp_configure. For more information ... More About: Access , Error , Statement
SQLAuthority New - Happy New Year 2008
More articles from this author:2008-01-01 02:30:00 Today is New Year and I wish you all Best for Year 2008. Let us all start our new year with motivational new year quote. We will open the book. Its pages are blank. We are going to put words on them ourselves. The book is called “Opportunity” and its first chapter is New Year’s Day. - ... More About: Technology , Database , Happy , Happy New Year 1, 2, 3, 4, 5, 6, 7 |
|
 |
|
 |
