Brady Upton

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
Title Category Date
Why does SQL Server require a transaction log? Database Administration2026-07-14
Querying Active Directory Data from SQL Server Linked Servers2025-06-17
How to recover data using a transaction log backup Database Administration2025-04-22
Introduction to the SQL Server Transaction Log Tutorial Database Administration2025-04-22
What is the transaction log? Database Administration2025-04-22
What is a transaction? Database Administration2025-04-22
What does BEGIN TRAN, ROLLBACK TRAN, and COMMIT TRAN mean? Database Administration2025-04-22
What is a nested transaction? Database Administration2025-04-22
How does Mirroring, Replication, and Log Shipping use transaction log Database Administration2025-04-22
What is a Virtual Log File (VLF)? Database Administration2025-04-22
How to monitor transaction log growth Database Administration2025-04-22
How to shrink the transaction log in SQL Server Database Administration2025-04-22
How large should the transaction log be? Database Administration2025-04-22
Do multiple transaction logs help performance? Database Administration2025-04-22
What are the recovery models and how does the log use them? Database Administration2025-04-22
Why does the transaction log grow? Database Administration2025-04-22
SQL Server DBCC CHECKDB Overview Database Console Commands DBCCs2025-01-20
Understanding Column Properties for a SQL Server Table SQL Server Management Studio2019-09-23
SQL Server Index Fragmentation Overview Fragmentation and Index Maintenance2016-06-22
Correct SQL TempDB Spills in Query Plans Caused by Outdated Statistics Query Plans2015-12-29
Managing the size of the SQL Server SSIS catalog database Database Administration2014-08-19
SQL Server Maintenance Plans Reporting and Logging Maintenance2014-05-01
Identify SQL Server databases that are no longer in use Auditing and Compliance2014-02-25
Collect SQL Server Performance Counters and Build Reports with SSRS Monitoring2014-02-11
Creating a Table Warehouse to Retain Historical Data for a SQL Server Table Database Administration2013-12-09
SQL Server Index Properties in Management Studio Indexing2013-11-07
Downgrade from SQL Server Enterprise Edition to Standard Edition Upgrades and Migrations2013-10-23
SSIS Data Type Conversion Testing Integration Services Data Flow Transformations2013-10-01
Removing Duplicates Rows with SSIS Sort Transformation Integration Services Data Flow Transformations2013-09-20
Using the Deploy Database to SQL Azure Wizard in SQL Server Management Studio to move to the Cloud Azure2013-09-09
Fixing SQL Server error in-row data RSVD page count is incorrect Database Console Commands DBCCs2013-09-03
Move an On-Premises SQL Server Database to the SQL Azure Cloud Azure2013-08-02
Identify and Correct SQL Server Forwarded Records Database Design2013-06-25
Microsoft’s new 3D data visualization BI product – GeoFlow Microsoft Excel Integration2013-05-31
More Uses for Data Explorer for Excel Microsoft Excel Integration2013-05-24
SQL Server Simple and Forced Parameterization Performance Tuning2013-04-23
Using the SSIS WMI Task to Gather System Information Integration Services Control Flow Transformations2013-04-12
Building Key Performance Indicators (KPIs) with PowerPivot Microsoft Excel Integration2013-03-05
Detect SQL Server CPU Pressure Dynamic Management Views and Functions2013-02-26
PowerPivot with Excel 2013 Microsoft Excel Integration2013-02-01
SQL Server Partition Wizard Partitioning2013-01-09
Restore SQL Server Databases using DateTime functions Dates2012-12-21
How to create and use Temp tables in SSIS Integration Services Development2012-12-07
Report to Capture Table Growth Statistics for SQL Server Monitoring2012-11-13
Managing SQL Server Extended Events in Management Studio Extended Events2012-07-17
SQL Server User Defined Server Roles Security2012-07-09
SQL Server Clustering Management inside the command line Clustering2012-06-18
Apply a Service Pack or Patch to Mirrored SQL Server Databases Database Mirroring2012-06-07
Adding Storage to SQL Server 2008 Cluster Clustering2012-05-14
Managing a Windows and SQL Server Cluster using the Failover Cluster Manager tool Clustering2012-05-07
Data Driven Colored Text for Reporting Services Reports Reporting Services Dynamic Reports2012-02-13
Creating an SSRS Map report with data pinpoints Reporting Services Development2011-12-20
SQL Server Always On Availability Groups Setup Availability Groups2011-11-10
SQL Server AlwaysOn Availability Groups – Part 1 configuration Availability Groups2011-11-09
Securing and protecting SQL Server data, log and backup files with TDE Security2011-11-03
SQL Server High Availability Options High Availability2011-10-20
Import data from Microsoft Access to SQL Server Microsoft Access Integration2011-09-07
Configure SQL Server Database Mirroring with Management Studio Database Mirroring2011-08-15
SQL Server performance tuning for each layer of an application Performance Tuning2011-08-02
SQL Server Multi Server Administration SQL Server Agent2011-07-26