4,657 reputation
1134
bio website thomaslarock.com
location United States
age
visits member for 3 years, 10 months
seen 6 hours ago

I am a Microsoft Certified Master, a SQL Server MVP, a VMWare vExpert, and also a Microsoft Certified Trainer. I have over 15 years experience in the IT industry in various roles such as programmer, developer, analyst, and database administration.

You can find out more info about me at my blog: http://thomaslarock.com/resume/

I'm the author of DBA Survivor: Become a Rock Star DBA and have participated in the technical review of several other books.

Currently I am a Head Geek for SolarWinds, makers of the Database Performance Analyzer database monitoring tool for SQL Server, Oracle, Sybase, and DB2. This role allows for me to work with a variety of customers to help solve questions regarding database performance tuning and virtualization.


1d
reviewed Approve suggested edit on Opening a .backup file for PostgreSQL
1d
reviewed Approve suggested edit on XMLTABLE solution without getting right parenthesis missing error
Nov
15
answered Restoring master database
Sep
30
awarded  Explainer
Sep
8
reviewed Approve suggested edit on Iterate through all non-system databases and empty them
Sep
5
comment Database Mirroring and Snapshots
What version of SQL Server? Also, what exactly are you trying to accomplish with the use of the snapshot that the mirror would not suffice?
Sep
5
reviewed Approve suggested edit on How to query for records based on most recent version
Aug
28
comment How I can monitor SQL Server 2012 databases to determine the security privileges that are called by different processes
Have you looked at using SQL Server Audit for this yet?
Jul
25
reviewed Approve suggested edit on Derive daily delta from total daily counts? Tsql
Jul
24
comment SQL Server data files in Windows Azure: filegroups and partitioning still applicable?
Have you seen this link yet? msdn.microsoft.com/en-us/library/azure/dn133149.aspx
Jul
24
reviewed Approve suggested edit on Update the other columns which are for to have minimum of other 2 columns , difference between 2 columns , and others
Jul
24
answered Use GUID as primary key in Azure?
Jul
24
comment SQL Server 2014 Install Not Creating Default Instance
Check the setup log files for errors: msdn.microsoft.com/en-us/library/ms143702.aspx
Jul
22
reviewed Approve suggested edit on Master-master Replication with 3 Nodes
Jun
30
answered Is it always faster to create indexes after loading data?
Jun
24
comment SQL Server Database Audit
Is it possible that the user John is mapped to the dbo schema?
Mar
28
awarded  Enlightened
Mar
28
awarded  Nice Answer
Mar
25
comment Sql Server Standard VS Enterprise
Can you share the execution plans for each test?
Mar
6
comment SQL-Server Custom Database Role
Can you post your exact code?