Profile

Cover photo
Jack Vamvas
Works at sqlserver-dba.com
Attended University of North London
Lives in Brighton
103 followers|30,419 views
AboutPostsPhotosVideos+1's

Stream

Jack Vamvas

Shared publicly  - 
 
Performance Tuning very large databases with OLTP presents a whole new set of problems. There are thousands of articles and tutorials on tuning databases of a generic shape & size . Here are some thoughts on approaching database servers with...
1
Add a comment...

Jack Vamvas

Shared publicly  - 
 
Question: This error appeared in the SQL Server Logs today. Error: 17836, Severity: 20, State: 14. Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the...
1
Add a comment...

Jack Vamvas

Shared publicly  - 
 
Question: How can I find if a file exists on the OS using the sql command language? I’m executing some stored procedures, requiring some checks on files . Answer: The extended stored procedure xp_fileexist will return some information about whether...
1
Add a comment...

Jack Vamvas

Shared publicly  - 
 
Question: How can I find details about TSAMP (Tivoli System Automation for Multiplatforms) failover details? I discovered that a failover occurred and need, what sources will give me details? I have a TSA single storage solution in place Answer: There...
1
Add a comment...

Jack Vamvas

Shared publicly  - 
 
The importance of the deal between Britain and France keeping border checks on the French side of the channel has increased . Although the politics of Calais border control, doesn't initially suggest a direct influence of the IT industry and...
1
Add a comment...

Jack Vamvas

Shared publicly  - 
 
The top 10 visited pages for 2016 on dba-db2.com SQL0911N Reason Code 68 The current transaction has been rolled back because of a deadlock or timeout DB2 – Backup history DB2 SET CURRENT SCHEMA DB2 – Restore database from a...
1
Add a comment...

Jack Vamvas

Shared publicly  - 
 
Question: In the SQL Server Error Logs I saw the following message: The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or...
1
Add a comment...

Jack Vamvas

Shared publicly  - 
 
Question: What is the difference between TCP and UDP? When is TCP used instead of UDP? Answer: SQL Server databases are shared across different locations , so it’s important to understand network communications . To read on the importance network...
1
Add a comment...

Jack Vamvas

Shared publicly  - 
 
Question: How can I monitor SQL Server blocked processes with a SQL Server alert and capture the details for analysis. I’d like the alert to trigger when there is more than one blocked process. When the blocked process triggers the...
1
Add a comment...
Story
Tagline
Jack Vamvas is a Database Architect.Managing SQL Server and DB2 environments.Database Tuning very large databases.Everything else SQL server and DB2.Coffee and Running.See me working on sqlserver-dba.com and dba-db2.com
Introduction
DBA,SQL Server,DB2,Performance Tuning very large databases. See me working on sqlserver-dba.com and dba-db2.com. Coffee & Running
Education
  • University of North London
    Computer Science, 1994 - 2012
  • University of Melbourne
    Philosophy, 1987 - 1991
Basic Information
Gender
Male
Work
Occupation
Senior DBA / Database Architect
Employment
  • sqlserver-dba.com
    Database Architect, 2008 - present
  • Travelers Co.
    Senor DBA, 2008 - 2012
  • Microsoft
    DBA, 1996 - 1998
  • Angryfish
    Techical Director, 1999 - 2007
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Brighton
Previously
Melboune - Sydney - London - Brighton
Links
Other profiles
Contributor to
Jack Vamvas's +1's are the things they like, agree with, or want to recommend.
sp_WhoIsActive utility for SQL Server troubleshooting
www.sqlserver-dba.com

One of my favourite utilities for Production SQL Server troubleshooting is the sp_WhoIsActive utility. My main uses are to identify blocking

DBA DB2: Contact me
www.dba-db2.com

Highly specialized expert focused on DB2 support,architecture and Performance Tuning

Security audit for SQL public role - SQL Server DBA
www.sqlserver-dba.com

Create a regular security audit on the SQL Server public role. The public role exists in every user database and by default every login is a

SQL0911N Reason Code 68 The current transaction has been rolled back bec...
www.dba-db2.com

Question : I am seeing this SQL0911N Reason Code 68 message in my DB2 diaglog file: command : db2 backup db MYDB online use TSM include logs

How to protect DB2 against External Attack - DBA DB2
www.dba-db2.com

Fully protecting DB2 against an external attack requires solid design and regular Audits. Exposing some surface area to external connections

SQL Database Status with sys.databases - SQL Server DBA
www.sqlserver-dba.com

While writing a Powershell script for a SQL Server checkout procedure after a reboot , I needed to query the SQL Server database to find the

How to crack the SQL Login password from sys.syslogins - SQL Server DBA
www.sqlserver-dba.com

A fellow DBA forgot the password for a SQL login and hadn’t lodged the password in the Password vault. One option was to change the SQL logi

SQL Server Database SUSPECT state - SQL Server DBA
www.sqlserver-dba.com

According to BOL , a database in SUSPECT state is : “At least the primary filegroup is suspect and may be damaged. The database cannot be re

Factors that can delay Log Truncation – LOG BACKUP - SQL Server DBA
www.sqlserver-dba.com

When log records remain active for a long time – truncation can be delayed. The delays can cause the transaction logs to fill. This can lead

The transaction log for database is full due to ACTIVE_TRANSACTION - SQL...
www.sqlserver-dba.com

During an ETL process failure occurred. An alert was raised and I started to investigate . This is a chronology of the errors with some expl

SQL Server - Monitoring a Rollback and sys.dm_exec_requests - SQL Server...
www.sqlserver-dba.com

SQL Rollback Transaction is easy with sys.dm_exec_requests. The dynamic management view (DMV) sys.dm_exec_requests returns information about

Business Objects versus SSRS - SQL Server DBA
www.sqlserver-dba.com

Question: I’d like to implement a low-cost Reporting solution. The user base is internal IT staff. We’d like to exploit a large investment i

How to request SQL Server troubleshooting - SQL Server DBA
www.sqlserver-dba.com

When requesting SQL Server troubleshooting ,don’t send messages such as “users are complaining of sudden slow performance “ or “this was OK

OFFLINE Database files not deleted when DROP DATABASE is executed - SQL ...
www.sqlserver-dba.com

A DBA contacted me in a panic this afternoon. They’d accidentally dropped a database . We had a brief conversation about whether a valid bac

How to crack the SQL Login password from sys.syslogins - SQL Server DBA
www.sqlserver-dba.com

A fellow DBA forgot the password for a SQL login and hadn’t lodged the password in the Password vault. One option was to change the SQL logi

How Get IP Address of connections to DB2 server - DBA DB2
www.dba-db2.com

Question: How can I get the IP address of connections to a DB2 server? When connected to a DB2 server and execute db2 list applications, a l

How to get the DB2 server instance owner - DBA DB2
www.dba-db2.com

Getting the DB2 server instance owner is a common requirement for auditing and inventory management. As a DBA, application owners request my

SQL Server – Current queries executing on SQL Server - SQL Server DBA
www.sqlserver-dba.com

I use this query to get list of queries executing on the current SQL Server. The sys.dm_exec_requests DMV returns a list of executing reques

Script to change database owner to sa for all user databases - SQL Serve...
www.sqlserver-dba.com

There was a SQL Server upgrade. All the user databases were restored from the older SQL Server instance. As a result, the database owner of

How to tune every query - SQL Server DBA
www.sqlserver-dba.com

Tune queries by using the SQL Optimizer I’ve tuned thousands of sql queries. There are common patterns and methods, but there isn’t a guaran