Learn more about SQL Server tools

   
   

















































SQL Server DBA Tips and Tricks


Latest SQL Server Tips
SQL Server Code Deployment from the File System with a Custom Stored Procedure
Our team wants to develop a Source Control process to apply SQL Server database code changes in various environments. As you can imagine the changes can relate to any of the following: creating new objects (tables, views, functions, stored procedures, etc.), altering objects, etc. Moreover, it was also important to define a Folder Structure to have the scripts run in a particular order, validating the dependencies are met. So how can we achieve t
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
Backup made easy with SQL Safe Backup

This demonstration will focus on the features and benefits of the SQL Safe Backup product developed by Idera to help you easily manage the backups and restores in your SQL Server environment.

Some of the features of SQL Safe Backup include:

  • Instant database restore
  • Speed up SQL Server backups
  • Maximize backup file compression
  • Reduce backup failures
  • Automate backup policies<
All Categories

 
Sponsor Information