In addition to providing support for SQL Server 2008 database projects, this release incorporates many previously released Power Tools as well as several new features. The new features include distinct Build and Deploy phases, Static Code Analysis and improved integration with SQL CLR projects. Database Edition no longer requires a Design Database. Therefore, it is no longer necessary to install an instance of SQL Express or SQL Server prior to using Database Edition.
-
-
About Pinal Dave
Pinalkumar Dave is Microsoft SQL Server MVP and author of over 800 SQL Server articles. He has six years experience as Principal Database Administrator in MS SQL Server 2008/2005, .NET (C#) and ColdFusion MX. He has a Masters of Science degree in Computer Networks, along with MCDBA, MCAD(.NET) and ColdFusion Advanced MX Certifications.
MVP Profile
-
Blog Stats
- 5,765,898 Readers
-
SQLAuthority Links
My Homepage
My Resume
My Other Blog
SQL Server Mag Articles
--------------------
SQLAuthority
Best Articles
Favorite Articles
SQL Script Bank
Top Downloads
--------------------
SQL Interview Q & A
SQL Coding Standards
SQL FAQ Download
--------------------
SQL Random Article
Search SQLAuthority
Subscribe Email Update
SQLAuthority Feed
Translate SQLAuthority
--------------------
Jobs @ SQLAuthority
Find Your IP
Categories
- About Me (41)
- Best Practices (48)
- Data Warehousing (26)
- Database (242)
- DBA (202)
- Main (67)
- MVP (38)
- Pinal Dave (546)
- Software Development (73)
- SQL (827)
- SQL Add-On (77)
- SQL Authority (827)
- SQL Backup and Restore (50)
- SQL Coding Standards (84)
- SQL Constraint and Keys (46)
- SQL Cursor (63)
- SQL Data Storage (19)
- SQL DateTime (35)
- SQL Documentation (293)
- SQL Download (430)
- SQL Error Messages (361)
- SQL Function (96)
- SQL Humor (21)
- SQL Index (68)
- SQL Interview Questions and Answers (63)
- SQL Joins (356)
- SQL Performance (414)
- SQL Puzzle (10)
- SQL Query (827)
- SQL Scripts (531)
- SQL Security (369)
- SQL Server (827)
- SQL Server DBCC (254)
- SQL Stored Procedure (133)
- SQL Tips and Tricks (827)
- SQL Trigger (40)
- SQL User Group (16)
- SQL Utility (62)
- SQLAuthority (17)
- SQLAuthority Author Visit (38)
- SQLAuthority Book Review (29)
- SQLAuthority News (170)
- SQLAuthority Website Review (18)
- T SQL (827)
- Technology (827)
-
Top Posts
- SQL SERVER - Insert Data From One Table to Another Table - INSERT INTO SELECT - SELECT INTO TABLE
- SQL SERVER - Insert Multiple Records Using One Insert Statement - Use of UNION ALL
- 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 - 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 - Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()}
- SQL Server Interview Questions and Answers Complete List Download
- SQL SERVER - 2008 - Interview Questions and Answers Complete List Download
- SQL SERVER - Restore Database Backup using SQL Script (T-SQL)
- SQL SERVER - 2005 List All Tables of Database
- SQL SERVER - Shrinking Truncate Log File - Log Full
- SQL SERVER - 2005 NorthWind Database or AdventureWorks Database - Samples Databases
-
Recent Posts
- SQL SERVER - Find Currently Running Query - T-SQL
- SQL SERVER - Interesting Observation - Using sqlcmd From SSMS Query Editor
- SQL SERVER - sqlcmd vs osql - Basic Comparison
- SQL SERVER - 2008 - Change Color of Status Bar of SSMS Query Editor
- SQL SERVER - Time Delay While Running T-SQL Query - WAITFOR Introduction
- SQL SERVER - 2008 - 2005 - Find Longest Running Query - TSQL
- SQLAuthority News - Happy New Year - 5 SQL New Year Resolutions
- SQLAuthority News - Recap Year 2008 - Two Most Important Event of My Life
- SQLAuthority Author Visit Report - Tech Meetings - Recession - Job Market - Consolidation of Servers - OS Choice - Server Reboots - Performance Optimization - Backup and Restore
- SQL SERVER - 2008 - Certification Path Complete Download PDF
- SQL SERVER - Fix : Msg 15151, Level 16, State 1, Line 3 Cannot drop the login ‘test’, because it does not exist or you do not have permission
- SQL SERVER - Add Any User to SysAdmin Role - Add Users to System Roles
- SQL SERVER - Fix : Error : Msg 15151, Level 16, State 1, Line 2 Cannot alter the login ’sa’, because it does not exist or you do not have permission
- SQLAuthority Author Visit - Valsad, Daman, Silvassa, Vapi - Tech Meetings
- SQLAuthority News - Merry Christmas - Search SQLAuthority
-
Recent Comments
- gkw on SQL SERVER - FIX : Error 15023: User already exists in current database.
- Anoob.K.A on Contact Me
- pushpa on SQL SERVER - Stored Procedure to display code (text) of Stored Procedure, Trigger, View or Object
- Sanjeev on SQL SERVER - Collate - Case Sensitive SQL Query Search
- bhavani on SQL SERVER - Change Collation of Database Column - T-SQL Script
- Rajpreeti on SQL SERVER - Find Table in Every Database of SQL Server
- suresh on SQL SERVER - Change Password of SA Login Using Management Studio
- supriya on SQL SERVER - Understanding new Index Type of SQL Server 2005 Included Column Index along with Clustered Index and Non-clustered Index
- ganesh on Contact Me
- bhavani on SQLAuthority News - Recap Year 2008 - Two Most Important Event of My Life
- Vaibhav on Contact Me
- Ram on SQL SERVER - Find Currently Running Query - T-SQL
- Nikhil on SQL SERVER - 2008 - 2005 - Find Longest Running Query - TSQL
- Cush on SQL SERVER - Query to find number Rows, Columns, ByteSize for each table in the current database - Find Biggest Table in Database
- Aldo on SQL SERVER - FIX : Error 15023: User already exists in current database.
Archives
- 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
-
Latest Articles
-
pinaldave
- SQL SERVER - Find Currently Running Query - T-SQL
- SQL SERVER - Interesting Observation - Using sqlcmd From SSMS Query Editor
- SQL SERVER - sqlcmd vs osql - Basic Comparison
- SQL SERVER - 2008 - Change Color of Status Bar of SSMS Query Editor
- SQL SERVER - Time Delay While Running T-SQL Query - WAITFOR Introduction
- SQL SERVER - 2008 - 2005 - Find Longest Running Query - TSQL
- SQLAuthority News - Happy New Year - 5 SQL New Year Resolutions
- SQLAuthority News - Recap Year 2008 - Two Most Important Event of My Life
- SQLAuthority Author Visit Report - Tech Meetings - Recession - Job Market - Consolidation of Servers - OS Choice - Server Reboots - Performance Optimization - Backup and Restore
- SQL SERVER - 2008 - Certification Path Complete Download PDF
-
-
-
Click Cloud
