Tags » SQL Server

Achieved Two New MCSE Certifications

This week I achieved two new MCSE (Microsoft Certified Solutions Expert) certifications:

SharePoint

SQL Server Plan Comparison Tool

MSSQL Tiger Team – Plan Comparison Tool
I ran across the above link detailing the execution plan comparison tool included as part of SSMS(SQL Server Management Studio). 131 more words

SQL Server

Conditional Formatting is not visible in Power report

Hi All,

I have this issue when trying to format some columns based on the values in that.

Below things needs to be fixed for this issue to be resolved. 63 more words

Sql Server

How to import bulk data in Azure SQL

Background

Its a common scenario for sql server based application to facilitate import/export data from various sources. With sql server import/export wizard it was so easy, that it never been a concern, but when you try to do the same for azure sql environment, that’s a different story. 353 more words

Tip/Trick

Numbers in ORDER BY Clause

One of my friends asked me “What does it mean when a number is used in the order by clause?” An example is

Order by 1
… 259 more words
SQL Server

How to collected inventory for SQL Server using Microsoft Assessment and Planning (MAP) tool

Hi friends,

We need to collect inventory for database migration as well as platform to set up environment for migration, development and testing.

Is there any tool from Microsoft to achieve this scenario? 777 more words

Sql Server