Learn more about SQL Server tools


Connect with MSSQLTips

MSSQLTips Facebook Page MSSQLTips LinkedIn Page MSSQLTips RSS Feed MSSQLTips Pinterest Page MSSQLTips Twitter Page MSSQLTips Google+ Page

SQL Server DBA Tips and Tricks

Latest SQL Server Tips
Getting Started with HDInsight - Part 1 - Introduction to HDInsight
I have read the previous tips on Big Data Basics series of tips and have an overview of Big Data, Hadoop, and the related concepts. My current employer is more of a Microsoft shop and we use Microsoft technologies day-in and day-out. My employer is planning to implement one of our upcoming projects using Hadoop. So I would like to know about Microsoft's Hadoop offering and get prepared before the start of the project.
What's Trending?
SQL Server Cursor Example
In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them. Can you provide some cursor examples? Can you give any guidance on when to use cursors? I assume Microsoft created them for a reason so they must have a place where they can be used in an efficient mann
SQL Server Tutorials
SQL Server Webcasts
Free SQL Server tools to manage, optimize and monitor your environment
Managing a SQL Server environment can be quite challenging. There are several aspects and data sets to monitor, configure, tune, administer and optimize.

Microsoft provides tools that are pre-built into SQL Server such as DMVs, Activity Monitor, Import Export Wizard, Profiler and Database Tuning Advisor. Gaining a good understanding of your SQL Server environment requires an efficient set of tools, and sometimes these donít meet y
All Categories

Sponsor Information