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 Developer Tips and Tricks


Latest SQL Server Tips

Calculate Geographical Coding and Time Zone for an Address in SQL Server with PowerShell, T-SQL and Google Maps

Learn how to calculate geographical coding and time zone for an address in SQL Server with PowerShell and T-SQL code with Google Maps.



Simple Experiment with SQL Server In-Memory OLTP is 79 Times Faster

In this tip I will present a simple, yet comprehensive example of workload processing that was optimized using SQL Server In-Memory OLTP which led to a performance boost up to 79x times faster processing over disk-based execution.



SQL Server COUNT() Function Performance Comparison

This tip will explain the differences between the following COUNT function varieties: COUNT(*) vs. COUNT(1) vs. COUNT(column_name) to determine if there is a performance difference.



Disable SQL Server Triggers with PowerShell

Learn how to disable and enable SQL Server Triggers with PowerShell as well as alternatives in SQL Server Management Studio and T-SQL code.



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

VMware Guest Based High Availability Clusters - Ways to Protect SQL and Maintain Flexibility

Register for the webinar and join Dave Bermingham, Microsoft Clustering and Datacenter MVP, to discuss ways to protect SQL in a VMware environment without sacrificing IT flexibility or important VMware features, and whether you can have a cluster and multi-site replication with VMware. Bring your thoughts and questions to this interactive session.



Secure SQL Server on AWS EC2 and RDS

In this webcast we will review the Amazon SQL Server Database security features on EC2 and RDS as well as compare and contrast these technologies to an on-premises installation so that you can determine how well they meet your requirements.



Save Big by Right Sizing Your SQL Server VMware Environment

According to leading analysts, companies are over-provisioning VMware environments by as much as 80%, wasting tens of thousands of dollars annually in unnecessary server and storage acceleration hardware, VMware and application licenses, and capacity. Under-provisioning is equally problematic causing performance issues and, putting failovers (and critical applications that rely on them) at risk. Join this webinar to learn simple techniques for ensuring you have the performance and capacity your business needs without over provisioning.



Building an Auditing Framework for SQL Server

Do you know what security changed on your SQL Servers from yesterday to today? What about two days, two weeks, or two months ago? If you were called to answer an audit, would you be prepared? In this webinar we'll look at how you can build an auditing framework to provide answers to these questions. We'll cover developing the data structures you'll need to produce reports about changes and who had access to what, at least as far as SQL Server is concerned. Then we'll review what kind of automation you will need to put into place as well as how often you should run your data collection in order to be able to provide the details you'll be asked for.



More SQL Server Solutions




Learn more about SQL Server tools