Introduction
This article will cover the most spectacular feature of SQL 2008 – Policy-based management and how the configuration of SQL Server with policy-based management architecture can make a powerful difference. Policy based management is loaded with several advantages. It can help you implement various policies for reliable configuration of the system. It also provides additional [...]
Archive for the ‘Software Development’ Category
SQL SERVER – Policy Based Management – Create, Evaluate and Fix Policies
Posted in Database, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, Software Development, T SQL, Technology, tagged Policy Management on November 13, 2009 | Leave a Comment »
SQLAuthority News – Effect of Oracle acquiring MySQL – A Delayed Analysis
Posted in Database, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, Software Development, T SQL, Technology, tagged MySQL on August 31, 2009 | 3 Comments »
On 20 April 2009, Oracle Corporation announced its acquisition of Sun Microsystems in a deal worth about US$ 6 billion. This would have been just another one of corporate mega-deals that sound interesting in the news but really have no effect on your life. Except for the fact that with the purchase, Oracle acquired the [...]
SQLAuthority News – Proposed eGov Standards Policy – Benefit for All or Only A Chosen Few
Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, Software Development, T SQL, Technology, tagged MySQL on August 2, 2009 | 5 Comments »
Does the proposed eGov Standards Policy benefit all or only a chosen few?
As a wider audience comes to accept new technology, so the technology itself grows. The recent debate in India on the eGov Standards policy has been a point of contention for some time. I would like to start our discussion on this [...]
SQL SERVER – Introduction to Cloud Computing
Posted in Pinal Dave, SQL, SQL Authority, SQL Documentation, SQL Query, SQL Server, SQL Tips and Tricks, Software Development, T SQL, Technology, tagged Cloud Computing on July 31, 2009 | 10 Comments »
Introduction
“Cloud Computing,” to put it simply, means “Internet Computing.” The Internet is commonly visualized as clouds; hence the term “cloud computing” for computation done through the Internet. With Cloud Computing users can access database resources via the Internet from anywhere, for as long as they need, without worrying about any maintenance or management of actual [...]
SQLAuthority News – Author’s Birthday – Top 7 Commenters – Volunteers
Posted in About Me, DBA, Database, Pinal Dave, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, Software Development, T SQL, Technology on July 30, 2009 | 33 Comments »
Today is July 30 and I am very happy; it’s my Birthday, celebration time!!! The most common question I receive on my every birthday is -what are my plans for birthday. Let me share my plans here today. Additionally, if you are interested to know when SQL Server was born read my post SQLAuthority News [...]
SQL SERVER – Server Type and File Extention
Posted in Database, Pinal Dave, SQL, SQL Add-On, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Utility, SQLServer, Software Development, T SQL, Technology on April 7, 2009 | 3 Comments »
Owing to my personal experience so far, I can undeniably say that Microsoft Windows products are outstanding. One of the reasons that make them exceptional is their little nifty tricks. For instance, every time I double click myfilename.sql it opens Microsoft SQL Server Management Studio (SSMS). The reason how Windows discerns that it has to [...]
SQL SERVER – Logical Query Processing Phases – Order of Statement Execution
Posted in Database, Pinal Dave, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Joins, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, Software Development, T SQL, Technology, tagged Logical Query Processing Phases on April 6, 2009 | 22 Comments »
Download Logical Query Processing Poster
Of late, I penned down an article – SQL SERVER – Interesting Observation of ON Clause on LEFT JOIN – How ON Clause Effects Resultset in LEFT JOIN – which received a very intriguing comment from one of my regular blog readers Craig. According to him this phenomenon happens due [...]
SQLAuthority News – Top 10 Strategic Technologies for 2009
Posted in Best Practices, SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLAuthority Website Review, Software Development, T SQL, Technology on March 30, 2009 | 1 Comment »
Gartner, Inc. analysts highlighted the top 10 technologies and trends that will be strategic for most organizations. Factors that denote significant impact include a high potential for disruption to IT or the business, the need for a major dollar investment, or the risk of being late to adopt.
The top 10 strategic technologies for 2009 include:
Virtualization. [...]
SQL SERVER – Interesting Interview Questions – Revisited
Posted in Best Practices, Pinal Dave, Readers Contribution, SQL, SQL Authority, SQL Interview Questions and Answers, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, Software Development, T SQL, Technology on December 17, 2008 | 3 Comments »
I really enjoyed users participation in my previous question. Read SQL SERVER – Interesting Interview Questions before continuing reading this article. This interview question was about user participation and about how good and how different you can come with your T-SQL script. What I really liked is that many users took this test seriously and [...]
SQL SERVER 2008 – Top 10 SQL Server 2008 Features for Independent Software Vendor Applications
Posted in Best Practices, Database, SQL, SQL Authority, SQL Documentation, SQL Download, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, SQLAuthority News, Software Development, T SQL, Technology on December 10, 2008 | Leave a Comment »
Microsoft SQL Server 2008 has hundreds of new and improved features, many of which are specifically designed for large scale independent software vendor (ISV) applications, which need to leverage the power of the underlying database while keeping their code database agnostic. This article presents details of the top 10 features that we believe are most [...]
About Pinal Dave
Pinalkumar Dave is a Microsoft SQL Server MVP and a Mentor for Solid Quality India. He has written over 1100 articles on the subject on his blog at http://blog.sqlauthority.com. He is a dynamic and proficient Principal Database Architect, Corporate Trainer and Project Manager, who specializes in SQL Server Programming and has 7 years of hands-on experience. He holds a Masters of Science degree and a number of certifications, including MCDBA and MCAD (.NET). He was awarded Regional Mentor for PASS Asia.
-
Blog Stats
- 10,853,057 Readers
SQLAuthority Links

My Homepage
My Resume
My Other Blog
--------------------
Top Downloads
PDF Downloads
Script Downloads
Script Bank
Favorite Scripts
All Scripts - 1
All Scripts - 2
Top Articles
Best Articles
Favorite Articles - 1
Favorite Articles - 2
--------------------
SQL Interview Q & A
SQL Coding Standards
SQL FAQ Download
--------------------
Jobs @ SQLAuthority
Top 7 Commenters
357 - Imran Mohammed
135- Brian Tkatch
55 - Tejas Shah
54 - Jacob Sebastian
47 - Jerry Hung
46 - Kuldip Bhatt
42 - Ashish GilhotraCategories
- About Me (61)
- Best Practices (91)
- Business Intelligence (14)
- Data Warehousing (30)
- Database (268)
- DBA (124)
- MVP (97)
- Poll (5)
- Readers Contribution (37)
- Readers Question (44)
- Software Development (67)
- SQL Add-On (91)
- SQL Backup and Restore (54)
- SQL BOL (10)
- SQL Coding Standards (20)
- SQL Constraint and Keys (51)
- SQL Cursor (28)
- SQL Data Storage (45)
- SQL DateTime (37)
- SQL Documentation (218)
- SQL Download (222)
- SQL Error Messages (125)
- SQL Function (124)
- SQL Humor (25)
- SQL Index (96)
- SQL Interview Questions and Answers (58)
- SQL Joins (63)
- SQL Optimization (65)
- SQL Performance (221)
- SQL Puzzle (25)
- SQL Security (119)
- SQL Server DBCC (42)
- SQL Server Management Studio (28)
- SQL Stored Procedure (101)
- SQL String (19)
- SQL System Table (50)
- SQL Trigger (24)
- SQL User Group (48)
- SQL Utility (126)
- SQL White Papers (36)
- SQLAuthority (371)
- SQL Training (1)
- SQLAuthority Author Visit (80)
- SQLAuthority Book Review (18)
- SQLAuthority News (341)
- SQLAuthority Website Review (28)
- SQLServer (74)
- Tech (910)
- Pinal Dave (900)
- SQL Scripts (531)
- Technology (1152)
- SQL (1152)
- SQL Authority (1152)
- SQL Query (1152)
- SQL Server (1152)
- SQL Tips and Tricks (1152)
- T SQL (1152)
-
Top Posts
- SQL SERVER - Insert Data From One Table to Another Table - INSERT INTO SELECT - SELECT INTO TABLE
- SQL Server Interview Questions and Answers Complete List Download
- SQL SERVER - Insert Multiple Records Using One Insert Statement - Use of UNION ALL
- SQL SERVER - Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()}
- SQL SERVER - Import CSV File Into SQL Server Using Bulk Insert - Load Comma Delimited File Into SQL Server
- SQL SERVER - Convert Text to Numbers (Integer) - CAST and CONVERT
- SQL SERVER - 2005 - Create Script to Copy Database Schema and All The Objects - Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects
- SQL SERVER - Shrinking Truncate Log File - Log Full
- SQL SERVER - 2005 NorthWind Database or AdventureWorks Database - Samples Databases
- SQL SERVER - 2008 - Interview Questions and Answers Complete List Download
- SQL SERVER - FIX : ERROR : (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: )
- SQL SERVER - Restore Database Backup using SQL Script (T-SQL)
-
Authors
-
pinaldave
- SQLAuthority News – Disk Partition Alignment Best Practices for SQL Server
- SQL SERVER – Policy Based Management – Create, Evaluate and Fix Policies
- SQL SERVER – Disable CHECK Constraint – Enable CHECK Constraint
- SQL SERVER – Sharepoint Resource Available for SQL Server
- SQL Authority News – Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning
- SQL SERVER – Removing Key Lookup – Seek Predicate – Predicate – An Interesting Observation Related to Datatypes
- SQL SERVER – Stored Procedure are Compiled on First Run – SP taking Longer to Run First Time
- SQLAuthority News – Data Compression Strategy Capacity Planning and Best Practices
- SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 4
- SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 3
-
Archives
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
Pages
Category Cloud
About Me Best Practices Database DBA MVP Pinal Dave Software Development SQL SQL Add-On SQL Authority SQLAuthority Author Visit SQLAuthority News SQL Documentation SQL Download SQL Error Messages SQL Function SQL Index SQL Joins SQL Optimization SQL Performance SQL Query SQL Scripts SQL Security SQLServer SQL Server SQL Stored Procedure SQL Tips and Tricks SQL Utility Technology T SQL


