Aug 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – 2008 – November CPT5 New Improvement

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
CTP, SQL Download
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…
Read More

SQLAuthority News – SQL Server 2008 Community Technology Preview (CTP) Download Now Available

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
CTP, SQL Download
Download the latest SQL Server 2008 Community Technology Preview (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…
Read More

SQL SERVER – Generate Script with Data from Database – Database Publishing Wizard

Pinal Dave
SQL
DBA, SQL Backup, SQL Download, SQL Restore, SQL Scripts

I really enjoyed writing about 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. Since then the I have received question that how to copy data as well along with schema. The answer to this is Database Publishing Wizard. This wizard is very flexible and works with modes like schema only, data only or both. It generates a single SQL script file which can be used to recreate the contents of a database by manually executing the script on a target server.

Read More

SQLAuthority News – Microsoft SQL Server 2005 Assessment Configuration Pack Download

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Download
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…
Read More

SQLAuthority News – Microsoft SQL Server 2005 MSIT Three Configuration Pack for Configuration Manager 2007

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Download
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…
Read More

SQLAuthority News – SQL Server 2005 Powers Global Forensic Data Security Tool

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Download, SQL Utility, SQL White Papers
Note :  Download Whitepaper by Microsoft 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…
Read More

SQLAuthority News – Microsoft Synchronization Services for ADO.NET v2.0 CTP1

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Download
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…
Read More