Learn more about SQL Server tools

 
 

Tutorials          DBA          Dev          BI          Career          Categories          Events          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Events

DBA    Dev    BI    Categories

 

SQL Server Professional Development Tips and Tricks


Latest SQL Server Tips

Microsoft SQL Server Exam 70-466 - Implementing Data Models and Reports Preparation Materials

Check out these books, videos, links and advice you to prepare for the Microsoft SQL Server exam 70-466 - Implementing Data Models and Reports.



Applying for a SQL Server job even when you do not meet all the requirements

Very few applicants in the IT world have 100% of the skills listed on a job description. This isn’t necessarily a hindrance, here are some recommendations and best practices to address those skills gaps.



SQL Server DBA Phone Interview Questions

The phone interview. It has tales of bringing normally rationale people to a terrified state. I have even heard of a DBA that was so worried about a SQL Server phone interview that 'they just happened to be in the office park' where the company was loca



MSSQLTips.com Author and Rookie of 2015

Check out the 17 MSSQLTips.com Authors competing for the Author and Rookie of 2015.



SQL Server Tutorials

SQL Server Backup Tutorial

One of your last lines of defense for just about any system is to have a backup in place in case there is a need to recover some or all of your data. This is also true for SQL Server. In this tutorial we will discuss selecting the correct recovery models, what backup options are available, and how to create backups using T-SQL commands and SQL Server Management Studio.



SQL Server Restore Tutorial

What good is a backup if you do not know to restore the backup. In this tutorial we will look at what restore options are available and which options are only accessible using T-SQL commands.



SQL Server INFORMATION SCHEMA Tutorial

The INFORMATION_SCHEMA views allow you to retrieve metadata about the objects within a database. These views can be found in the master database under Views / System Views and be called from any database in your SQL Server instance. In this tutorial we look at some of these INFORMATION_SCHEMA views and how they can be used.



SQL Server Performance Monitoring and Tuning Tutorial

In this tutorial we will cover some of the common issues with performance such as: deadlocks, blocking, missing and unused indexes, I/O bottlenecks, poor query plans, statistics, wait stats and fragmentation.



SQL Server Webcasts

High Availability for SQL in VMware without Raw Device Mapping

You CAN have high availability (HA) protection for SQL in a VMware environment without the hassles of Raw Device Mapping (RDM)! As you know, creating shared storage clusters in a VMware environment means complex implementation using RDM - and giving up important VMware features, such as Vmotion, but that doesn't have to be the case anymore.



Multi-platform Database Administration with DBArtisan

Proactively manage all major DBMSs (Oracle, SQL Server, DB2 and Sybase) from a single common interface. Reduce training requirements and streamline collaboration among different database teams across the organization. Learn about these items and more in this product demonstration of IDERA's DBArtisan.



15 Traits of Top Performers

Want to be considered one of the best employees on your team? In your group? At your company? Looking for ideas on how you can improve your performance and be known as “one of the best?” Especially if you want to set yourself apart and grow within your organization, you’ll want to make every effort to establish yourself as a reliable, eager, competent and value-add professional! In this workshop, we’ll highlight our top 15 traits in becoming a top performer, which include being proactively helpful, providing unanticipated value, and having the mentality that building relationships with all internal and external stakeholders and providing superior customer service are part of every job description.



Top-Down SQL Server Security

Security, when possible, should follow the KISS principle: Keep It Simple, Stupid! The more unnecessarily complex security is, the more likely for a weakness or vulnerability to work its way in. Therefore, it's best to start looking at security from the top down. Going the other direction tends to leave us overwhelmed in the details.



More SQL Server Solutions




Learn more about SQL Server tools