4,483 reputation
1133
bio website thomaslarock.com
location United States
age
visits member for 3 years, 3 months
seen yesterday

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 Technical Evangelist for Confio Software, makers of Ignite8 and IgniteVM database monitoring tools 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.


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?
Mar
3
answered DB2 SUM / INNER JOIN question
Jan
29
answered Does RAM taken up Shared Memory connection counts against Max Server Memory?
Jan
10
awarded  Yearling
Dec
30
comment Setting Audit Events in SQL Server 2012
Did you want to use a server trace for auditing? Or were you asking to use SQL Server Audit?
Dec
30
answered Access 2003 (SQL Server 2000) migration to SQL Azure
Dec
30
answered Stop and Start the Instance In a Job
Dec
18
comment Memory is not released after the execution stored procedure followed by a process end
Which database platform is this question for?
Dec
18
comment Database backuped, but “Last database backup” property shows bad date
If you look in the msdb.dbo.backupset table, do you see the backups listed that were created by your procedure? Or are they missing from that table, implying that perhaps your backups are not completing successfully?
Oct
31
answered How to transfer database from SQL Server to DB2?
Oct
31
comment How to launch SQL Server Agent job on completion of another one?
@Fulproof You could choose to look at creating master jobs, too. Also, jobs can be scripted, so if you had to make a change to many servers you could get that done using a script, too.
Oct
31
answered How to launch SQL Server Agent job on completion of another one?
Oct
5
comment Using Mirroring to upgrade SQL Server 2008 R2 to SQL Server 2012
Weird, how about this: sqlsoldier.com/wp/sqlserver/…
Oct
3
comment Using Mirroring to upgrade SQL Server 2008 R2 to SQL Server 2012
I'd point you here first: sqlsoldier.com/wp/sqlserver/…;, let me know if that helps in any way.
Oct
2
comment Grouping Selecting unique values in a single column
Can you tell us what you mean by "first occurence[sic] of the value of Field7"? That might then help us to understand how to best compare that value to something considered to be previous.
Sep
17
awarded  Nice Answer
Sep
12
answered How to retrieve a query from 3000 tables in SQL?