Adding Storage to SQL Server 2008 Cluster
I'm running out of disk space on my SQL Server 2008 cluster and need to add a new storage device. In this tip we walk through how this can be done.
Brady has been in the IT industry for 10+ years. He has worked in administrative roles using MSSQL 2000 to 2012 as well as Sharepoint 2007 and 2010. He currently serves as a Database Administrator in Nashville, TN. You can view his blog @ http://www.sqlbrady.com.
- MSSQLTips Awards: Trendsetter (25+ tips) - 2013
Managing a Windows and SQL Server Cluster using the Failover Cluster Manager tool
From a DBA standpoint, I’ve installed my first Windows and SQL Server cluster on the 2008 platform. Now that it has been setup, let's walk through some of the management options.
Data Driven Colored Text for Reporting Services Reports
How can I color code certain entries in a SSRS report? In SSRS you can use data driven expressions to color code certain rows, so check out this tip to see how to accomplish this.
Querying Active Directory Data from SQL Server
My boss is asking for a list of email addresses and phone numbers for all users in the company. I know this data exists in Active Directory, so how can I access this data from SQL Server? In this tip we walk through how you can query Active Directory fro
Creating an SSRS Map report with data pinpoints
SQL Server Reporting Services has some cool features such as displaying maps and data points on the maps. In this tip I show how to take a list of addresses and display them as pinpoints on a map in an SSRS report.
SQL Server Always On Availability Groups Setup
The new AlwaysOn feature combines the powers of clustering and mirroring into one High Availability option. This tip covers setting up Availability Groups.
SQL Server AlwaysOn Availability Groups – Part 1 configuration
The new AlwaysOn feature combines the powers of clustering and mirroring into one High Availability option, but also allows you to interact with the secondary databases something that clustering and mirroring do not allow. In addition, AlwaysOn Availabil
Securing and protecting SQL Server data, log and backup files with TDE
I need to keep some old SQL data and log files in a backup folder for DR purposes. What is the best way to protect these files? In this tip we look at using TDE to safeguard your files and the steps necessary to move a TDE database to another SQL Server
SQL Server High Availability Options
I need to implement a high availability solution for one of my SQL Server databases, but Im not sure of which option to implement to satisfy my companys needs. Check out this tip to learn about the five native SQL Server High Availability options.
Import data from Microsoft Access to SQL Server
Tired of using SSIS packages to import data from Access to SQL Server? Is SQL Server Integration Services more complicated than what you are looking for? Check out this tip to see how to import data from Access (Access 2007 or above) to SQL Server.
Configure SQL Server Database Mirroring with Management Studio
I have a need to setup SQL Server Database Mirroring in my environment. I understand it can be complicated to setup. Can you provide an example on setting up SQL Server Database Mirroring? Check out this tip for a basic look at how to setup this SQL Ser
SQL Server performance tuning for each layer of an application
Performance is always a key factor when using SQL Server and should be thought about before the initial setup of the server as well as when the application is being used in production. In this tip I cover the approach I like to take when setting up and t
SQL Server Multi Server Administration
I have multiple SQL Servers that need the exact same SQL Server Agent Job created. I know I can script a SQL Server Agent Job out and run the T-SQL script on multiple servers or bounce from server to server creating the SQL Server Agent Jobs, but isn't th