June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Presenting on Best Practices Analyzer using Microsoft Baseline Configuration Analyzer

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Best Practices
Today (May 5, 2011) I will be presenting on Presenting on Best Practices Analyzer using Microsoft Baseline Configuration Analyzer at . I will be presenting on following subjects. The tools which I will be using in the demonstration are following: Engine – Backups outdated for databases Engine – Database files and…
Read More

SQL SERVER – Cartoon Challenge – 140 Character Winner is Here

Pinal Dave
Personal, SQL, SQL Performance, SQL Puzzle, SQL Server, SQL Tips and Tricks
Database, MVP, SQL Scripts
Earlier Idera has announced contest where participant can win Windows Mobile Phone by writing 140 character. Here is the details of the contest SQLAuthority News – Win Windows Phone from Idera in 140 Characters – A Cartoon Challenge of SQL. We received more than 200 comments on the blog post…
Read More

SQL SERVER – Error: Failed to retrieve data for this request. Microsoft.SqlServer.Management.Sdk.Sfc – ‘DATABASEPROPERTY’ is not a recognized built-in function name. (Microsoft SQL Server, Error: 195)

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages
I have four different machine at home. Office Laptop – Provided by work organization Personal Laptop – My wife uses it Demo Machine – A very old machine – I think I can only do demo of my messenger only – it is 32 bit – single CPU 1 GB…
Read More

SQL SERVER – Migration Assistant for Access, MySQL, Oracle, Sybase

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Documentation, SQL Download
SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from Sybase Adaptive Server Enterprise (ASE) to SQL Server or SQL Azure. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration…
Read More