SQL Server: Data File Structure

In our earlier posts , we have discussed about various types pages in details. In this post let us discuss about...

Handling Large Many to Many bridge tables

In some scenarios you will need to create a many to many relationship in your cube in SSAS. One of...

70-457 Reviewer #11 Configuring and Maintaining a Backup Strategy

This topic is the second part for lesson Manage Data which covers 20% of the examination. Understanding Backup Types SQL...

Is the Master Certification Dead or Will it be Born Again?

The Certified Master and Architect community was collectively notified Friday, August 30, 10 PM Pacific Time (Microsoft Time) that the...

70-457 Reviewer #10 Managing SQL Server Agent

This review topic is part of Managing Data lesson which covers 20% of the certification exam. SQL Server Agent enables...

Retiring of the MCM Certifications

The MCM is dead. Long live the MCM.
The small, exclusive club of SQL Server Microsoft Certified Masters is going to...

Terminal #MCM – 30 days to go

We just finished the webshow last night, when one of our chatroom fellows – Nic Cain – told us that the MCM...

How to find SQL Server Version,Edition,Server Name?

How to find sql server version,edition,Server Name?

SQL Server provides a System Defined function SERVERPROPERTY(propertyname) .
By using this function you can...

PASS Virtual Chapter Events : September 2013

 
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...

SSRS: Ignore Series Grouping in Chart

In SSRS, when you add a Series Group to a chart the data for each series is aggregated based on the series grouping specified. In some situations, you may...